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 |
~~~~~~~~~~~~~~~~~~~~~~~~~