XL5: Can't Clear Entire Contents of Cell with Shortcut Menu

- Microsoft Excel for Windows, version 5.0

In Microsoft Excel version 5.0, there is no shortcut menu available to simultaneously clear a cell's contents, notes, and formatting.

NOTE: In earlier versions of Microsoft Excel, you can use the shortcut menu to clear all of a cell's contents.

To use the shortcut menu to clear the contents of a cell:

1. Select the cell or range of cells.

2. With the insertion point positioned on top of the selected cell or cells, click the right mouse button to bring up the shortcut menu.

3. From the shortcut menu, choose Clear Contents.

1. Select the cell or range of cells.

2. From the Edit menu, choose Clear and then choose the appropriate command:

      Use this command        To do this
      ------------------------------------------------
   
      All                     Clear everything from the selected
                              cell or cells.
   
      Formats                 Clear formatting, such as borders and
                              patterns, from the selected cell or
                              cells. Note that font settings for
                              each affected cell will revert to the
                              font defined in the Normal style.
   
      Contents                Clear the contents of the selected
                              cell or cells.
   
      Notes                   Delete any notes attached to the
                              selected cell or cells.
   
   

REFERENCES

"User's Guide," version 5.0, "Selecting Cells and Choosing Commands," in Chapter 8, and "Inserting, Deleting, and Clearing Cells, Rows, and Columns" in Chapter 11