Insert - Worksheet
The Data Tools | Edit | Insert command inserts a single blank cell or a block of blank cells in the worksheet. Select cells in the area to insert cells. In the Insert dialog, click either the Shift Cells Down or Shift Cells Right option button and then click OK. The blank cells are inserted and the original contents of those cells are moved accordingly to make room for the new empty cells. Click Entire Row or Entire Column to insert an entire row or column in the area that contains highlighted cells.
When using Home | Edit | Insert, you can
shift cells to the right or down to make
room for the new cells.
Shift Cells Right or Shift Cells Down
Click the Shift Cells Down or Shift Cells Right option to insert blank cells and displace the original contents either down or to the right.
Entire Row or Entire Column
Click the Entire Row or Entire Column option to insert an entire row or column in the area that contains highlighted cells.