• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3. Editing Worksheets > Deleting Cells

Deleting Cells

Select the cell (or cells) you want to delete.

Open the Edit menu and choose Delete to open the Delete dialog box.

Select what you want to happen to the rest of the cells when the selected cells are deleted; for example, Shift cells up, and click OK.

The selected cell(s) are deleted, and other cells are shifted.

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 to rectify the error, you can delete extraneous cells and shift other cells to their correct locations.


TIP

#REF! error

If the #REF! error appears in a cell after you delete a cell, it means you deleted a cell or cells that contained data that your worksheet needs to calculate a formula. To resolve the problem, undo the change (refer to the task “Undoing and Redoing Changes” earlier in this part to learn how).


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint