Removing Columns

The Remove Column option is used to remove Extra Columns from the spreadsheet. Remove Column is available in the toolbar or the Edit menu when the Grid Data view is the active view.

To remove Extra Columns:

1. Click the mouse on the title (header) of the Extra Column that you wish to remove.
2. Select the Remove Column option from the toolbar or the Edit menu.
3. A warning dialog will appear. Select Yes to remove the column.

To remove multiple Extra Columns at once:

1. Click and drag across multiple column titles (headers) with the mouse to highlight the Extra Columns you wish to remove.
2. Select the Remove Column option from the toolbar or the Edit menu.
3. A warning dialog will appear. Select Yes to remove the column.

NOTES:

• The Remove Column option is only enabled when you click on the title of an Extra Column.
• Remove Column cannot be used to delete the Orientation, Quantity, Traverse or Set columns.
• Remove Column is also available by right-clicking on the header of any Extra Column.

Filtered Data

Filters will be re-queried whenever Grid Data changes. If any filters (i.e., Filter Data dialog) are defined in the document, removing columns may result in filters being deleted from the data query if no data matches are found for the filter