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

ID: Q104838

The information in this article applies to:

Microsoft Excel for Windows, version 5.0
Microsoft Excel for the Macintosh, 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:

Select the cell or range of cells.

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

From the shortcut menu, choose Clear Contents.

To clear the contents, notes, or formatting from a cell or range of cells, do the following:

Select the cell or range of cells.

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

Additional query words: 5.00


Keywords          : 
Version           : 5.00
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 7, 1999