Microsoft Office Tutorials and References
In Depth Information
Insert a Row or Column
Working with Ranges
Insert a Column
1 Click any cell in the row to the
right of where you want to insert
the new column.
2 Click the Home tab.
3 Click the Insert .
4 Click Insert Sheet Columns .
C Excel inserts the new column.
D The columns to the right of the
new column are shifted to the
5 Click the Insert Options smart
tag ( ).
6 Select a formatting option for
the new column (
Can I insert more than one row or column at a time?
Yes. First, select the same number of rows or columns that you want to insert. For example, if
you want to insert four rows, select four existing rows. For rows, be sure to select existing rows
below where you want the new rows inserted, and then follow Steps to in the “Insert a 4
Row” subsection. For columns, be sure to select existing columns to the right of where you want
to insert the new columns, and then follow Steps to in the “Insert a Column” subsection. 4