Clearing cells

To clear cells, totally removing their contents but leaving the cell and style/formatting information intact:

  1. Select the cells you want to clear.
  2. Choose Make Blank from the Make sub-menu, on the Edit menu.
  3. The cells will be cleared, but remain in the worksheet so that you can enter new data.

You can also simply select the information on the formula line and type over it.