How to insert multiple cells at the same time in Excel 2007?

In the picture to the right, you may notice that in the Month Name column, February is missing and in the Month No column, 2 is missing. All you have to do is move the cells A3 to A12 one row down as well as cells C3 to C12 one row down. You can do this inserting blank cells in position A3 and C3. Doing this, cells A3 to A12 and C3 to C12 gets shifted down.
Perform the following to do so:
1. Click cell A3. Press the CTRL key from the keyboard and click cell B3.
2. On the Home tab, in the Cells group, click the down arrow below Insert. Click Insert Cells...
3. The Insert dialog box appears with the Shift cells down option selected by default.
4. Click OK.

How to insert a cell in Excel 2007?

In your worksheet, if you had accidentally missed some data as shown in the figure then you can insert a cell to add the missing data. Note that in cell B3, you must have February but that entry has been accidentally left out. In order to add the entry February, you have to shift the cells from B3 to B12 down. You can do this by performing the following:
1. Click cell B3.
2. On the Home tab, in the Cells group, click Insert and click Insert Cells.
3. The Insert dialog box appears. The Shift cells down option is selected by default.
4. Click OK.

You can also perform the same by right-clicking on the cell B3 and clicking Insert to make the Insert dialog box appear. Click OK to shift all the cells in that column down.

Note:
You have shifted all the cells in a single column downwards. If you need to shift all the cells in a row towards right then you have to click on the Shift cells right option in the Insert dialog box.