The Data | 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 Data | 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 Data | Edit | Insert command, or press CTRL+R on the keyboard, to open the Insert dialog.
When using 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.
Data Tab Commands