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 ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
