Insert and Delete Columns

Add a column exactly where it belongs and remove one you no longer need.

You will learn to

• Insert a column to the left of the selection
• Delete a column

How it works

Select a cell in the column to the right of where the new column should go, then choose Insert → Column left (in Excel: right-click the column letter → Insert). Existing columns shift right. To delete, select a cell in the column and choose Delete column.

Like rows, formulas that reference shifted cells update automatically.