Inserting columns or rows

You can insert columns to the left of the current selection, or a rows above the current selection. The following method is the quickest way to insert one or just a few columns or rows.

  1. Select a range spanning as many columns or rows as you want to insert.

    For example, if you want to insert three columns, select a range that spans three columns.

  2. To insert rows, click Insert row in the action bar.

  3. To insert columns, click Range in the action bar and in the pop-up menu, click Insert Column(s).



Inserting many columns or rows

Using the Insert Multiple command lets you specify the number of columns you want to the left of the current selection or the number of rows you want to insert above the current selection. This method is most convenient when you want to insert many columns or rows.

  1. In the action bar, click Range.

  2. In the pop-up menu, click Insert Multiple.

  3. Click the Columns or the Rows button and enter the number of columns or rows you want to insert.

  4. Click Insert.



Details



Style of inserted columns or rows

Inserted columns and rows have the same styles and formats as the column to the left of the inserted columns or the row above the inserted rows.



Width and height of inserted columns or rows

Inserted columns have the same width as the column to the left of the inserted columns. Inserted rows have the same height as the row above the inserted rows.



How inserting columns and rows affects formulas

When you insert columns or rows, the dimensions of named ranges are redefined and, if necessary, addresses in formulas adjust to the new dimensions.

For example, if you entered the formula +E6*100 and then inserted two columns to the left of column E, the address adjusts so that the formula becomes +G6*100.

If you insert columns or rows just under or next to a range that a formula refers to, the formula does not adjust automatically; you must adjust the formula if you want to include the inserted cells.



How inserting columns and rows affects named ranges

If you insert columns or rows into a named range, the named range expands by the number of columns or rows you inserted.



See also
Deleting columns or rows
Sizing columns
Sizing rows
Hiding columns or rows
More power with formulas