Microsoft KB Archive/104838

{|
 * width="100%"|

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

 * }

-

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:


 * 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.

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. 