Microsoft KB Archive/104838

From BetaArchive Wiki

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:


  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

Additional query words: 5.00

Keywords :
Version : 5.00
Platform : WINDOWS
Issue type :
Technology :


Last Reviewed: April 7, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.