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.
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.
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.
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.
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.
If you insert columns or rows into a named range, the named range expands by the number of columns or rows you inserted.