Context Menu

On Right-click, the following options will show up.

Title

Description

Requirements

Cut

Cuts the selected cell or data.

Always available

Copy

Copies the selected cell or data.

Always available

Paste

Pastes the copied or cut cell or data to the selected cell or spot.

Always available

Paste Special

Pastes the copied or cut cell or data to the selected cell or spot in a special way depending on the selection

Four options

  • Values only

  • Format only

  • Formula only

  • All except borders

Always available

Merge

Merges the selected cell(s), column(s), or row(s) together.

Always available

Note

Adds a note to the selected cell(s).

Always available

Protect

Protects the selected cell(s), column(s), or row(s) from editing.

Always available

Hide Columns

Hides the selected column(s) from view.

When selecting a column

Insert Column(s)

Inserts a column, or columns, to the right of the selected column(s).

When selecting a column(s)

Delete Column(s)

Deletes the selected column(s).

When selecting a column(s)

Hide Rows

Hides the selected row(s) from view.

When selecting a row(s)

Insert Row

Inserts a row, or rows, below the selected row(s).

When selecting a row(s)

Delete Row

Deletes the selected row(s).

When selecting a row(s)

Insert Link

Inserts a link into the selected cell.

When selecting a cell without a link

Remove Link

Removes a link from the selected cell(s) that has a link in it.

When selecting a cell with a link

Clear Formatting

Clears all formatting from the selected cell(s).

When selecting a cell with formatting

Sort A-Z

Sorts the selected column from A-Z.

When a column(s) is selected

Sort Z-A

Sorts the selected column from Z-A.

When a column(s) is selected

Sort Range

Sorts the selected range.

When a range of data is selected

Group Columns

Groups selected columns together.

When several columns are selected

Group Rows

Groups selected rows together.

When several rows are selected