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.