If you need to add new data within an existing Microsoft Office Excel 2007 worksheet, you can insert new cells, columns, or rows rather than going through all the trouble of moving and rearranging several individual cell ranges.
To insert new cells, rows, or columns in an Excel worksheet, follow these steps:
Select the cells, rows, or columns where you want the new, blank cells to appear.
Click the drop-down button attached to the Insert command button in the Cells group of the Home tab.
Click Insert Cells on the drop-down menu.
The Insert dialog box opens with the following option buttons:
Shift Cells Right: Select this option to shift existing cells to the right to make room for the blank cells you want to insert.
Shift Cells Down: Use this default option to instruct the program to shift existing cells.
Entire Row: Select this option to insert complete rows in the cell range. You can also select the row number on the frame before you choose the Insert command.
Entire Column: Select this option to insert complete columns in the cell range. You can also select the column letter on the frame before you choose the Insert command.
You can find options for inserting cell's on the Home tab of Excel 2007's Ribbon.
To quickly insert an entire column or row into the worksheet, you can right-click the column letter or row number on the worksheet window frame and then select Insert from the shortcut menu (or choose Insert Sheet Rows or Insert Sheet Columns from the Insert button’s menu).
Keep in mind that inserting entire columns and rows affects the entire worksheet, not just the part you see. If you don’t know what’s out in the hinterlands of the worksheet, you can’t be sure how the insertion will impact stuff (especially formulas) in the other unseen areas.