Inserting Cells

You may find you want to add some extra space or more information into the middle of your worksheet. To do this, you must insert a new cell. This new cell can be left blank, or you can enter information into the cell. When you insert a new cell, you have the option to shift the existing data to the right or down, allowing you to place the new cell exactly where you want it.

To insert a cell:

1. Select Cells... from the Insert menu.
2. Click the Shift cells right or Shift cells down radio button.
3. Click OK.

Use this technique to insert an entire row or column as well.

To open the Insert dialog box, you can also right-click in a cell and select Insert... from the shortcut menu.