Microsoft KB Archive/121636

Microsoft Knowledge Base

Excel: How to Disable the Display of Cell Notes

Last reviewed: September 12, 1996
Article ID: Q121636

The information in this article applies to:

• Microsoft Excel for Windows, versions 2.x, 3.x, 4.0, 4.0a, 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 1.5, 2.2, 3.0, 4.0, 5.0
• Microsoft Excel for OS/2, versions 2.x, 3.0
• Microsoft Excel for Windows NT, version 5.0

SUMMARY

In Microsoft Excel, you can disable the display of cell notes for individual cells on a worksheet.

To disable cell notes for individual cells

Microsoft Excel Version 5.0:

1. Do the following to format the cell with the Hidden property:

   a. Choose Cells from the Format menu.

   b. Select the Protection tab.

   c. On the Protection tab, select the Hidden check box.

2. from the Tools menu, choose Protection, and then choose Protect Sheet. Select the Contents check box. (You may also need to supply a password at this time.)

   NOTE: If you do not enable the Locked protection property, you will be able to make changes to the cell notes. These changes, however, will not be displayed while the worksheet is protected.

Microsoft Excel Versions 2.0, 3.0 and 4.0:

1. Do the following to format the cell with the Hidden property:

   a. from the Format menu, choose Cell Protection.

   b. Select the Hidden option.

2. From the Options menu, choose Protection, and select the Cells check box. (You may also need to supply a password at this time.)

   NOTE: If you do not enable the Locked property, you will be able to make changes to the cell notes. These changes, however, will not be displayed while the worksheet is protected.

MORE INFORMATION

Microsoft Excel cell notes enable you to attach notes to a cell without having that information displayed on the worksheet. A cell containing a cell note can be identified by a small square in the upper-right corner of the cell (the square will be red if you are using a color monitor).

To access cell notes

Microsoft Excel version 5.0:

• Double-click the cell containing the cell note.

  NOTE: To use this method you must disable the Edit Directly In Cell option. To do this, choose Options from the Tools menu, select the Edit tab, and then clear the Edit Directly In Cell check box.

  -or-

• Select the cell containing the cell note, then choose Note from the Insert menu.

Microsoft Excel version 2.0, 3.0, and 4.0:

• Double-Click the cell containing the cell note. -or-
• Select the cell containing the cell note, and choose Notes from the Formula menu.

REFERENCES

"User's Guide," version 5.0, pages 675-676 "User's Guide 1," version 4.0, pages 283-286 "User's Guide," version 3.0, page 242-250 "Microsoft Excel Reference Guide," version 2.1, pages 377-378

KBCategory: kbusage KBSubcategory: Additional reference words: 2.00 2.10 3.00 4.00 5.00 1.50 2.20 THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Last reviewed: September 12, 1996 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.