Excel 2010 Bible

Part I: Getting Started with Excel

96

Changing a comment’s shape ....................................................................................

Normally, a cell comment is rectangular, but they don’t have to be. To change the shape of a cell

comment, add a command to your Quick Access toolbar:

1. Right-click the Quick Access toolbar and choose Customize Quick Access Toolbar.
   The Quick Access Toolbar section of the Excel Options dialog box appears.


2. From the Choose Commands From drop-down list, select Drawing Tools | Format
   Tab.


3. From the list on the left, select Change Shape and then click Add.


4. Click OK to close the Excel Options dialog box.

After performing these steps, your Quick Access toolbar has a new Change Shape icon.

To change the shape of a comment, make sure that it’s visible (right-click the cell and select Show/

Hide Comments). Then click the comment’s border to select it as a Shape (or, Ctrl-click the comment

to select it as a Shape). Click the Change Shape button on the Quick Access toolbar and choose a

new shape for the comment. Figure 4.18 shows a cell comment with a nonstandard shape.

FIGURE 4.18

Cell comments don’t have to be rectangles.

Reading comments ....................................................................................................

To read all comments in a workbook, choose Review ➪ Comments ➪ Next. Keep clicking Next

to cycle through all the comments in a workbook. Choose Review ➪ Comments ➪ Previous to

view the comments in reverse order.

Printing comments ....................................................................................................

Normally, when you print a worksheet that contains cell comments, the comments are not printed.

If you would like to print the comments, though, here’s how: