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.
Data Tab Commands
Selecting Worksheet Cells