2012

4 In the column label field, enter a new name. Press ENTER.
To sort extracted data in a column
1 Click Insert tab ➤ Linking & Extraction panel ➤ Extract Data.
2 In the Data Extraction wizard on the Refine Data page, click Sort Columns
Options.
3 In the Sort Columns dialog box, select a column name from the
drop-down list.
4 In the Order column, click Ascending or Descending. Click OK.
The order of the data in the column is changed.
5 (Optional) To sort additional columns, click Add.
6 Repeat steps 2 and 3.
7 Click Insert tab ➤ Linking & Extraction panel ➤ Extract Data.
To filter extracted data in columns
1 Click Insert tab ➤ Linking & Extraction panel ➤ Extract Data.
2 In the Data Extraction wizard on the Refine Data page, right-click a
column label. Click Filter Options.
3 In the Filter dialog box, select a predefined filter from the drop-down list.
4 From the drop-down list on the left, select a value.
5 In the Filter Across These Values field, clear any values so that they are
not included.
Organize and Refine the Extracted Data | 1983