Home > Articles

Editing Worksheets

  • Print
  • + Share This
This chapter is from the book

Deleting Cells

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.


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

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

3.gif 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.

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


  • + Share This
  • 🔖 Save To Your Account