When using Edit | Insert, you can shift
cells to the right or down to make
room for the new cells.
The Edit | Insert command inserts a single blank cell or a block of blank cells in the worksheet. Select cells in the area in which you wish to insert cells and then click Edit | Insert, or right-click and select Insert from the context menu. The Insert dialog appears. Specify how you want the original displaced contents moved when the blank cells are inserted.
Click the Edit | Insert command, or press CTRL+R on the keyboard, to open the Insert dialog.
When using Edit | Insert,
you can shift
cells to the right or down to make
room for the new cells.
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.
Click the Entire Row or Entire Column option to insert an entire row or column in the area that contains highlighted cells.
See Also