Spreadsheet Context Menu

Clear Range

Clears the selected cell range.

Clear Style

Removes style settings from the selected cells.

Clear Format

Removes format settings from the selected cells.

Remove Expression

Removes the formula or binding expression from the selected cells.

Remove Columns

Removes the selected columns. The command label includes the selected column range, for example Remove Columns A - A.

Remove Rows

Removes the selected rows. The command label includes the selected row range, for example Remove Rows 3 - 3.

Comment

Opens comment editing for the selected cells.

Conditional Formats

Opens conditional formatting settings for the selected cells. The same action is also available from the Spreadsheet Toolbar.

Special Paste

Opens additional paste options for Spreadsheet data. The following commands are available:

• Paste Value — Pastes only the cell value, without expression, style, or format.

• Paste Expression — Pastes only the cell expression.

• Paste Style — Pastes only the cell style.

• Paste Value And Format — Pastes the cell value together with its format.

• Paste Format — Pastes only the cell format.

Convert Cell

Opens a submenu for converting the selected cell type. The possible types are:

• String

• Integer

• Float

• Long

• Date/Time

• Boolean

• Color

• Bar

• HTML

• Reference

• Date

• Time

• Percent

• Currency

• Rounded Currency

Columns

Opens a submenu with column operations. Available when one or more columns are selected. The following commands are available:

• Insert Columns Before — Inserts a new column before the selected column. The command label includes the target column index, for example Insert Columns Before 2.

• Insert Columns After — Inserts a new column after the selected column. The command label includes the target column index, for example Insert Columns After 2.

• Group Columns — Groups the selected columns.

• Ungroup Columns — Ungroups the selected columns.

• Show Columns — Shows hidden columns within the selected range.

• Hide Columns — Hides the selected columns.