Microsoft Office Tutorials and References
In Depth Information
Tip 99: Changing the Look of Cell Comments
Changing the Look of Cell Comments
Cell comments are useful for a variety of purposes. But sometimes you just get tired of looking at the
same old yellow rectangle. This tip describes three tricks that you can use to make your comments
➤ Format a comment.
➤ Change the shape of a comment.
➤ Add an image to a comment.
All of these changes require that the cell comment is visible. If the comment isn’t visible,
right-click the cell and choose Show/Hide Comments from the shortcut menu.
Setting up your Quick Access toolbar
The operations described in this tip require commands that aren’t normally available in the Ribbon
when a comment is selected. So the first step is to add three commands to your Quick Access toolbar:
1. Right-click the Quick Access toolbar and choose Customize Quick Access Toolbar.
The Customization section of the Excel Options dialog box appears.
2. From the Choose Commands From drop-down list, select All Commands.
3. In the list on the left, select Format Shape and then click the Add button.
4. In the list on the left, select Change Shape and then click the Add button.
5. In the list on the left, select Picture Fill and then click the Add button.
6. Click OK to close the Excel Options dialog box.
After you complete these steps, your Quick Access toolbar has three new icons.
Formatting a comment
To change the formatting of a comment, Ctrl+click the comment (to select it as a shape) and then
click the Format Shape icon in your Quick Access toolbar, or you can press Ctrl+1. Either of these
actions displays the Format Comment dialog box. This dialog box has eight tabs that enable you to
change just about any aspect of the comment.