Worksheet ribbon

Icon

Name

Shortcut

Function

Customize Columns

Opens the Worksheet properties dialog to adjust column setting.

Resize Columns

Resize all columns automatically so all contents are displayed.

Multi Sort

Sorts multiple columns.

Sort Settings

Opens a drop-down menu to access the Manage Sort Settings function and all available saved Sort Settings that can be applied.

Assign

Assigns a value to a column, option or attribute.

Block Assign

Copies the options or attributes from one item to others.

Column Copy

Copies the contents of one column to another column.

Select All

Ctrl+A

Selects all items in the Worksheet.

Clear Selection

Esc

Deselects all items in the Worksheet.

Consolidate

Merges like items in the Worksheet.

Update Against Catalog

Ctrl+U

Updates all or selected items against the Manufacturer or Custom Catalog.

Update Against Worksheet

Updates items against a selected Worksheet by product number or tag.

Update Preview Images

Updates preview images of items in the Worksheet.

Apply Discount

Ctrl+D

Opens the Discount dialog box.

Show Associated Drawing

If the current worksheet is associated to a drawing, opens AutoCAD and loads the associated drawing.