Worksheet Column Context Menu

To access the commands available for a specific worksheet column, right-click (Windows) or Ctrl-click (Mac) while on the column letter.

Menu Item
Description

Format Cells

Opens the Format Cells dialog box, for setting the format and appearance of selected cells; see Formatting Worksheet Cells

Column Width

Opens the Column Width dialog box. Set the width value of selected cells in the specified units. Click Standard Width to use the default width. The width of multiple selected columns can be adjusted at one time.

Insert Columns

Inserts columns in the worksheet, left of the selected column. The number inserted depends on how many columns in the worksheet are highlighted at the time the command is selected.

Use caution when inserting columns. Depending on the type of cell references used in formulas, inserting columns could change the values returned by a formula.

To add columns to the right side of the worksheet, click and drag the bottom right corner of the worksheet.

Delete Columns

Deletes the selected columns from the worksheet.

Use caution when deleting a column. Deleting cells that are part of a formula may change the values returned by the formula.

Clear Column Contents

Deletes the contents of the selected cells

Cut

Removes the contents of selected cells, temporarily storing the contents in the clipboard

Copy

Copies the contents of selected cells to the clipboard, where they are temporarily stored; the original contents remain in the worksheet

Paste

Places cell contents stored in the clipboard into the current cell or range of cells

~~~~~~~~~~~~~~~~~~~~~~~~~

Worksheet Menu

Worksheet Cell Context Menu

Worksheet Row Context Menu

Was this page helpful?

vectorworks.net