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.