2012

Insert Totals Footer Displays a flyout menu with options for Sum, Max, Min,
and Average. Creates a footer row for the selected column that is placed below
all the data rows and displays values based on the selected arithmetic function.
This option is available only for columns that have a numeric data type.
Sum Displays a sum of all the values in the selected column in a footer row.
Max Displays the maximum value in the selected column in a footer row.
Min Displays the minimum value in the selected column in a footer row.
Average Displays the average value in the selected column in a footer row.
Remove Totals Footer Removes the Totals footer. This option is available
when a footer row exists.
Filter Options Displays the
Filter Column dialog box on page 446, where you
can specify filter conditions for the selected column.
Reset Filter Restores the default filter for the selected column.
Reset All Filters Restores default filters for all columns that have filters.
Copy to Clipboard Copies all the data cells, including column names, to the
Clipboard.
Choose Output
Specifies the type of output to which the data is extracted.
430 | Chapter 5 D Commands