Modify Multiple Cell Comments in Excel 2007/2010

Excel is not able to deal with multiple cell comments at a time, you may have to modify or edit each of them separately. The utility Cell Comment Tools in Kutools for Excel can help you work with comments in the following ways:

1. Easy to display or hide comments and their indicators.
2. List all Excel comments in a new workbook or worksheet.
3. Change the formatting of all comments based on the formatting of specified comment cell.
4. Find and replace the text in all comments.
5. Add or remove the user name in all comments.
6. Convert contents of cells into comments or convert comments into contents of cells

Usage:

1. Active the worksheets you want to use the Cell Comment Tools. Before using the tool, make sure that worksheet contains at least one comment.

2. Click "Kutools">>"Utilities" >>"Cell Comment Tools". See screenshot (Fig.1 ).

Fig. 1 Cell Comment Tools

3. Choose the operations in the Cell Comment Tools dialog box.

Note: You can select the scope for the operation: Choose Active sheet to work with comments on the active sheet only. Choose All sheets to work with all comments in the active workbook.

Change the comments appearance or list all comments in a workbook or worksheet:

1. Click the View/List tab in the Cell Comment Tools dialog box.
2. You can configure to display or hide comments and their indicators, or only display the indicator.
3. If you want to get a list of all comments, just click the Create comment list button. And you can choose to create the list in a new workbook or new worksheet. See screenshot (Fig.2).    

Fig. 2 View or List the comments

Change the formatting of all comments based on the formatting of specified comment cell:

1. Click the Format tab in the Cell Comment Tools dialog box.
2. Click Specify the comment cell button to select a cell that contains a comment, and the formatting of selected comment cell will be applied to all other comments. Select a comment cell and click OK. See screenshot (Fig.3. 4).

Note: Copying the formatting will make the entire comment bold. To ensure that bold formatting is not applied to the entire comment text, choose the Force non-bold formatting option.

Fig.3 Change the formatting of all comments		Fig.4 Range selection dialog box

Find and replace the text in all comments:

1. Click the Find/Replace tab in the Cell Comment Tools dialog box.
2. Input the text to be found and replaced in the Find text in the comment box.
3. Input the replaced text in the Replaced with box.
4. Click Replace to find and replace the text in the comments. See screenshot (Fig.5).

Fig. 5 Find and replace the text in the comments

Add or remove user name in all comments:

1. Click the User Name tab in the Cell Comment Tools dialog box.
2. Input or edit the user name in the User Name box.
3. Choose the operation as removing or adding the user name in the comment, and click Apply. See screenshot (Fig.6).

Note: If you are removing a user name and you don't want the remaining text of the comment to be bold, choose Force non-bold formatting option.

Fig. 6 Add or remove the user name in the comments

Convert contents of cells into comments or convert comments into contents of cells

1. Click Convert in the Cell Comment Tools dialog box.
2. Check the Convert contents of cells into comments option from Convert.
3. Click the left button to select the source range which you want to convert them to comments, and click the right button to select a cell where you will put the comments in.
4. Click OK. See screenshot(Fig.7):

Note: 1. If you would like to convert contents of cells into comments in the same range, you can choose Convert source range. 2. When you convert contents of cells into comments, you can click Add user name to comments to add the user name.

Fig.7

This is only one feature of Kutools for Excel

It includes more than 100 functions and tools for Excel 2007 and 2010.