Options
Specify the settings for calculating and presenting subtotals.
To access this command...
Choose Data - Subtotals - Options tab.
Page break between groups
Inserts a new page after each group of subtotalled data.
Case-sensitive
Recalculates subtotals when you change the case of a data label.
Pre-sort area according to groups
Sorts the area that you selected in the Group by box of the Group tabs according to the columns that you selected.
Sort
Include formats
Considers formatting attributes when sorting.
Custom sort order
Uses a custom sorting order that you defined in the Options dialogue box at Office Calc - Sort Lists.
Ascending
Sorts beginning with the lowest value. You can define the sort rules on Data - Sort - Options. You define the default on Tools - Options - Language settings - Languages.
Descending
Sorts beginning with the highest value. You can define the sort rules on Data - Sort - Options. You define the default on Tools - Options - Language settings - Languages.