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:
- 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 :
Technology :
Last Reviewed: April 7, 1999 |