Click the cell you want to delete (in this example, cell B4).
Open the Edit menu and select Delete to open the Delete dialog box.
Choose how you want the surrounding cells shifted when the selected cell is deleted for example, Shift Cells Up and click OK.
The selected cell is deleted, and other existing cells are shifted up.
INTRODUCTION
As you work with worksheets, you might find that data needs to be eliminated to keep the worksheet up-to-date. Or you might accidentally add an extraneous cell of data in a row or column. To avoid typing all your data again, you can delete extraneous cells and shift other cells to their correct locations.
TIP
#REF! Error
If the #REF! error appears after you delete a cell, it means you deleted a cell or cells that contained data your worksheet needs to calculate a formula. To resolve the problem, undo the change; the task "Undoing and Redoing Changes" later in this part tells you how.