10 October 2011

Tip of the week - Excel 2010 - Formatting comments

When most people create a comment (Review tab, New Comment, or Shift/F2), they accept the shape and colour and just enter the information they want. How about a change?

Here's how you can do it:
1. When you first create a comment, the cursor is right after whatever you typed. You need to select the comment itself, not the text inside. So, put in the border of the comment.
2. Then you need the Change Shape tool. This can be placed on the Quick Access toolbar. When the comment is selected by the border, click the new Change Shape tool.
3. From that, you can select basic shapes, block arrows, flowcharts, stars and banners, or callouts, each of which has yet another set of shapes to choose from. Shown here is the Cloud callout.
4. Once you have the new shape, right-click the border once again, and choose Format comment as shown.

No comments:

Post a Comment