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

Deleting Data

To delete the data in a cell or range of cells, select it and press Delete. However, Excel offers additional options for deleting cells:

  • With the Edit, Clear command, you can delete just the formatting of a cell (or an attached comment), without deleting its contents. The formatting of a cell includes the cell's color, border style, numeric format, font size, and so on. You'll learn more about this option in a moment.

  • With the Edit, Delete command, you can remove cells and then shift surrounding cells over to take their place. This option is covered in Lesson 13.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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