Excel® 2013 On Demand

Inserting a Column or Row

You can insert blank columns and rows between existing data, without disturbing your worksheet. Excel repositions existing cells to accommodate the new columns and rows and adjusts any existing formulas so that they refer to the correct cells. Formulas containing absolute cell references will need to be adjusted to the new columns or rows. When you insert one or more columns, they insert to the left. When you add one or more rows, they are inserted above the selected row.

Insert a Column or Row

Click to the right of the location of the new column you want to insert.

To insert a row, click the row immediately below the ...