Excel Tip of the Day
Configure Excel so comments are always visible (97/2000/2001/2002)
You may already know that comments are a great way to provide user instructions or background information about data in specific cell. To create a cell comment, click in the desired cell and choose Insert | Comment. Then, type your message and click outside of the comment box.
By default, Excel indicates that a cell contains a comment by inserting a small red triangle in the upper-right corner of the cell. To view the comment, you ordinarily have to hover the mouse pointer over the triangle.
However, you can configure Excel to always display comments. To do so, select Tools | Options from the menu bar (or Edit | Preferences on the Mac) and click on the View tab. Then, choose the Comment And Indicator option in the Comments panel and click OK. If you find that a comment box gets in the way of a particular bit of data, just drag the comment box to a new position. An arrow will continue to anchor the comment to the appropriate cell.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.