Deleting Data

To delete the data in a cell or cells, you can just select them 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), instead of 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 everything in them. This option is covered in Lesson 13.

To use the Clear command to remove the formatting of a cell or a note, follow these steps:

  1. Select the cells you want to clear.

  2. Open the Edit menu and select Clear. The Clear submenu appears.

  3. Select ...

Get Ten Minute Guide to Excel 97 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.