Excel Tip of the Day
Create eye-catching cell comments (Excel 97/2000/2001/2002)
When you create a cell comment in Excel by choosing Insert | Comment from the menu bar, Excel automatically formats the comment as a yellow rectangle. You may not know it, but you can change the way the cell comment appears. Although you can't change the default style that's used, you can apply many different formatting effects to a comment after the fact. While your insertion point is in a comment, you can change typical font attributes, such as font name or size, text color, or underline formatting.
You can also change attributes affecting the comment box itself. First, if necessary, choose View | Comments from the menu bar to display your comments. Then, click on a comment box, being sure to click on the edge of the box and not within it. Next, choose Format | Comment from the menu bar to reveal the formatting options that are available.
If you want, you can even use a different shape for your comments by substituting one of Excel's AutoShapes in place of the default box. To do so, select the comment box. Then, choose View | Toolbars | Drawing if the Drawing toolbar isn't already visible. Finally, choose Draw | Change AutoShape from the Drawing toolbar and select the AutoShape you want to use. (On the Mac, click the arrow on the bottom of the Drawing toolbar to reveal the Change AutoShape command.)
(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 - 2026 MJ Technologies, LLC. All rights reserved.