The Data | 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. Click either the Shift
Cells Down or Shift Cells Right
option button and then click the OK
button. 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.
See Also