From 940b4d1848e8c70ab7642901a68594e8016caffc Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 27 Apr 2024 18:51:28 +0200 Subject: Adding upstream version 1:7.0.4. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/00/00000412.xhp | 172 +++++++++++++++++++++++++ 1 file changed, 172 insertions(+) create mode 100644 helpcontent2/source/text/scalc/00/00000412.xhp (limited to 'helpcontent2/source/text/scalc/00/00000412.xhp') diff --git a/helpcontent2/source/text/scalc/00/00000412.xhp b/helpcontent2/source/text/scalc/00/00000412.xhp new file mode 100644 index 000000000..c6de85323 --- /dev/null +++ b/helpcontent2/source/text/scalc/00/00000412.xhp @@ -0,0 +1,172 @@ + + + + + + + Data Menu + /text/scalc/00/00000412.xhp + + + +

Data Menu

+ Choose Data - Text to Columns. + Choose Data - Define Range. + Choose Data - Select Range. + Choose Data - Sort.... + Choose Data - Sort Ascending + Choose Data - Sort Descending +
+ Choose Data - Sort - Sort Criteria tab. + On Standard bar, click +
+
+ + + + + Icon Sort Ascending + + + + Sort Ascending + + +
+
+
+ + + + + Icon Sort Descending + + + + Sort Descending + + +
+
+
+
+ Choose Data - Sort - Options tab. + Choose Data - More Filters. +
+ Choose Data - AutoFilter. + On Tools bar or Table Data bar, click +
+ + + + + Icon + + + AutoFilter + + +
+
+
+ Choose Data - More Filters - Advanced Filter... . +
+ Choose Data - More Filters - Standard Filter... - Options label. + Choose Data - More Filters - Advanced Filter... - Options label. +
+
+ Choose Data - More Filters - Reset Filter. + On Table Data bar, click Reset Filter/Sort. + + + + + Icon + + + Reset Filter/Sort + + +
+
+ Choose Data - More Filter - Hide AutoFilter. + Choose Data - Subtotals. + Choose Data - Subtotals - 1st, 2nd, 3rd Group tabs. + Choose Data - Subtotals - Options tab. + Choose Data - Validity. + Menu Data - Validity - Criteria tab. + Choose Data - Validity - Input Help tab. + Choose Data - Validity - Error Alert tab. + Choose Data - Multiple Operations. + Choose Data - Consolidate. + Choose Data - Group and Outline. + Choose Data - Group and Outline - Hide Details. + Choose Data - Group and Outline - Show Details. +
+ Choose Data - Group and Outline - Group. + F12 + On Tools bar, click +
+ + + + + Icon + + + Group + + +
+
+
+
+ Choose Data - Group and Outline - Ungroup. + CommandCtrl+F12 + On Tools bar, click +
+ + + + + Icon + + + Ungroup + + +
+
+
+ Choose Data - Group and Outline - AutoOutline. + Choose Data - Group and Outline - Remove Outline. + Choose Data - Group and Outline - Show Details (for some pivot tables). + Choose Data - Pivot Table. + Choose Insert - Pivot Table. + Choose Insert - Pivot Table, in the Select Source dialog choose the option Data source registered in $[officename]. +
+ Choose Insert - Pivot Table, in the Select Source dialog choose the option Current selection. + Choose Insert - Pivot Table, in the Select Source dialog choose the option Data source registered in $[officename], click OK to see Select Data Source dialog. +
+ Choose Data - Pivot Table - Refresh. + Choose Data - Pivot Table - Delete. + Choose Data - Refresh Range. + Choose Data - Group and Outline - Group. + + -- cgit v1.2.3