diff options
| author | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2020-03-24 11:30:12 -0600 |
|---|---|---|
| committer | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2020-04-27 02:27:32 +0200 |
| commit | 731ea5215c543caa876b2087c4303970b011d824 (patch) | |
| tree | 0935f77fde8f2403f2e0af9c229511d4b1a65c0f /source/text/scalc/guide | |
| parent | dacce1ab09a52f8eecee9a0651069934eb91054b (diff) | |
Some more copyediting…
Change-Id: I43d4535b5c0ea659fd19177775ad00db71a2d7b3
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91001
Tested-by: Jenkins
Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
Diffstat (limited to 'source/text/scalc/guide')
| -rw-r--r-- | source/text/scalc/guide/subtotaltool.xhp | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/source/text/scalc/guide/subtotaltool.xhp b/source/text/scalc/guide/subtotaltool.xhp index 9b7e633b36..3ec316002b 100644 --- a/source/text/scalc/guide/subtotaltool.xhp +++ b/source/text/scalc/guide/subtotaltool.xhp @@ -33,7 +33,7 @@ <paragraph id="par_id241585177550504" role="listitem">Select the cell range for the subtotals that you want to calculate, and remember to include the column heading labels. Alternatively, click on a single cell within your data to allow Calc to automatically identify the range.</paragraph> </listitem> <listitem> - <paragraph id="par_id421585177574387" role="listitem">Select <menuitem>Data > Subtotals</menuitem> from the Menu bar to open the Subtotals dialog.</paragraph> + <paragraph id="par_id421585177574387" role="listitem">Choose <menuitem>Data - Subtotals</menuitem> to open the Subtotals dialog.</paragraph> </listitem> <listitem> <paragraph id="par_id41585177608508" role="listitem">In the <emph>Group by</emph> drop-down list on the <emph>First Group</emph> page, select a column by its label. Entries in the cell range from step 1 will be grouped and sorted by matching values in this column.</paragraph> @@ -51,14 +51,14 @@ <paragraph id="par_id511585177679372" role="listitem">You can create two more subtotal categories by using the <emph>Second Group</emph> and <emph>Third Group</emph> pages and repeating steps 3 to 6. If you do not want to add more groups, then leave the Group by list for each page set to “- none -”.</paragraph> </listitem> <listitem> - <paragraph id="par_id301585177698777" role="listitem">Click OK. Calc will add subtotal and grand total rows to your cell range.</paragraph> + <paragraph id="par_id301585177698777" role="listitem">Click <emph>OK</emph>. Calc will add subtotal and grand total rows to your cell range.</paragraph> </listitem> </list> <h2 id="hd_id211585178799496">Subtotal outline</h2> <paragraph role="paragraph" id="par_id841585178819108"> When you use the Subtotals tool, Calc inserts an outline to the left of the row number column. This outline represents the hierarchical structure of your subtotals, and can be used to hide or show data at different levels in the hierarchy using the numbered column indicators at the top of the outline or the group indicators, denoted by plus <emph>(+)</emph> and minus <emph>(-)</emph> signs.</paragraph> <paragraph role="paragraph" id="par_id371585181820075">This feature is useful if you have many subtotals, as you can simply hide low-level details, such as individual entries, to produce a high-level summary of your data.</paragraph> -<paragraph role="paragraph" id="par_id161585178829165">To turn off outlines, select <menuitem>Data > Group and Outline > Remove Outline</menuitem> from the Menu bar. To reinstate them, select <menuitem>Data > Group and Outline > AutoOutline</menuitem>.</paragraph> +<paragraph role="paragraph" id="par_id161585178829165">To turn off outlines, choose <menuitem>Data - Group and Outline - Remove Outline</menuitem>. To reinstate them, choose <menuitem>Data - Group and Outline - AutoOutline</menuitem>.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/01/12050000.xhp#subtotalheaderh1"/> </section> |