2012

Sort Columns Options
Displays the Sort Columns dialog box on page 439, where you can sort data
across multiple columns.
Full Preview
Displays a full preview of the final output, including linked external data, in
the text window. The preview is for viewing only.
Column Shortcut Menu
Sort Descending Sorts column data in a descending order.
Sort Ascending Sorts column data in an ascending order.
Sort Column Options Displays the Sort Columns dialog box on page 439,
where you can sort data across multiple columns.
Rename Column Allows in-place editing of the selected column name.
Hide Column Hides the selected column.
Show Hidden Columns Displays the hidden column. The flyout option
includes Display All Hidden Columns.
Set Column Data Format Displays the
Set Cell Format dialog box on page
441, where you can set a data type for cells in the selected column.
Insert Formula Column Displays the Insert Formula Column dialog box on
page 440, where you can specify the formula that is inserted into the table.
Inserts the formula column to the right of the selected column. An existing
formula column cannot be used as a value for another formula column.
Edit Formula Column Displays the
Edit Formula Column dialog box on page
444. This option is only available when a formula column is selected.
Remove Formula Column Removes the selected formula column. This option
is only available when a formula column is selected.
Combine Record Mode Displays numeric data in the selected column as
separate values or collapses identical property rows into one row and displays
the sum of all the numeric data in the selected column. This option is available
when the Combine Identical Rows is checked and the selected column contains
numerical data.
Show Count Column Displays a Count column that lists the quantity of each
property.
Show Name Column Displays a Name column that displays the name of
each property.
Data Extraction Wizard | 429