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:
- 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.
- 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:
- Do the following to format the cell with the Hidden property:
a. from the Format menu, choose Cell Protection.
b. Select the Hidden option.
- 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
|