Inserting and Deleting Cells

Inserting and Deleting Cells

You can insert new, blank cells anywhere on the worksheet so you can enter new data exactly where you want it. Inserting cells moves the remaining cells in the column or row to the right or down as you choose and adjusts any formulas so they refer to the correct cells. You can also delete cells if you find you don't need them; deleting cells shifts the remaining cells to the left or up a row ”just the opposite of inserting cells. Deleting a cell is different from clearing a cell. Deleting a cell removes the actual cell from the worksheet whereas clearing a cell erases the cell contents, the cell format, or both.

Insert One or More Cells

Select one or more cells where you want to insert new cell(s).

Click the Insert menu, and then click Cells.

To move the contents of the cells right, click the Shift Cells Right option; to move the contents of the cells down, click the Shift Cells Down option.

Click OK.

Delete One or More Cells

Select one or more cells you want to delete.

Click the Edit menu, and then click Delete.

To move the remaining cells left, click the Shift Cells Left option; to move the remaining cells up, click the Shift Cells Up option.

Click OK.