diff options
Diffstat (limited to 'source/text/scalc/guide/autofilter.xhp')
-rw-r--r-- | source/text/scalc/guide/autofilter.xhp | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/source/text/scalc/guide/autofilter.xhp b/source/text/scalc/guide/autofilter.xhp index 6e204cd843..9d7f1b5a0e 100644 --- a/source/text/scalc/guide/autofilter.xhp +++ b/source/text/scalc/guide/autofilter.xhp @@ -34,8 +34,8 @@ <bookmark_value>drop-down menus in sheet columns</bookmark_value> <bookmark_value>database ranges; AutoFilter function</bookmark_value> </bookmark><comment>mw made "drop-down..." a one level entry and added a "see also" reference</comment> -<paragraph xml-lang="en-US" id="hd_id3156423" role="heading" level="1"><variable id="autofilter"><link href="text/scalc/guide/autofilter.xhp" name="Applying AutoFilter">Applying AutoFilter</link> -</variable></paragraph> +<h1 id="hd_id3156423"><variable id="autofilter"><link href="text/scalc/guide/autofilter.xhp" name="Applying AutoFilter">Applying AutoFilter</link> +</variable></h1> <paragraph xml-lang="en-US" id="par_id3147427" role="paragraph">The <emph>AutoFilter</emph> function inserts a combo box on one or more data columns that lets you select the records (rows) to be displayed.</paragraph> <section id="autofiltertext"> <list type="ordered"> @@ -53,10 +53,13 @@ <paragraph xml-lang="en-US" id="par_id9216589" role="paragraph">When you apply an additional AutoFilter on another column of a filtered data range, then the other combo boxes list only the filtered data.</paragraph> <paragraph xml-lang="en-US" id="par_id3153714" role="paragraph">To display all records again, select the <emph>all</emph> entry in the AutoFilter combo box. If you choose <emph>Standard</emph>, the <item type="menuitem">Standard Filter</item> dialog appears, allowing you to set up a standard filter. Choose "Top 10" to display the highest 10 values only. </paragraph> <paragraph xml-lang="en-US" id="par_id3147340" role="paragraph">To stop using AutoFilter, reselect all cells selected in step 1 and once again choose <emph>Data - Filter - AutoFilter</emph>.</paragraph> - <paragraph xml-lang="en-US" id="par_id4303415" role="tip">To assign different AutoFilters to different sheets, you must first define a database range on each sheet.</paragraph> - <paragraph xml-lang="en-US" id="par_id3159236" role="warning">The arithmetic functions also take account of the cells that are not visible due to an applied filter. For example, a sum of an entire column will also total the values in the filtered cells. Apply the <link href="text/scalc/01/04060106.xhp" name="SUBTOTAL">SUBTOTAL</link> function if only the cells visible after the application of a filter are to be taken into account.</paragraph> + <section id="autofiltertip"> + <tip id="par_id4303415">To assign different AutoFilters to different sheets, you must first define a database range on each sheet.</tip> + </section> + <warning id="par_id3159236">The arithmetic functions also take account of the cells that are not visible due to an applied filter. For example, a sum of an entire column will also total the values in the filtered cells. Apply the <link href="text/scalc/01/04060106.xhp" name="SUBTOTAL">SUBTOTAL</link> function if only the cells visible after the application of a filter are to be taken into account.</warning> </section> <section id="relatedtopics"> + <embed href="text/scalc/01/12040100.xhp#autofilterh1"/> <embed href="text/scalc/guide/filters.xhp#filters"/> <embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/> <embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/> |