Quickly modify and manager multiple cell comments in Excel

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:

Display or hide comments and their indicators

List all comments in a new workbook or worksheet

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

Find and replace the text within the comments

Add or remove the user name for the comments

Convert cell content to comment or convert comment to cell content

Click Kutools > More > Cell Comment Tools. See screenshots:

Display or hide comments and their indicators

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

2. Apply this tool by clicking Kutools > More > Cell Comment Tools, in the Cell Comment Tools dialog box click View, and then specify the operations. See screenshot:

None: if you check this option, all of the comment and their indicators in the workbook will be hidden. Indicator: if you choose this option, all of the comments in the workbook will be hidden and only display their indicators. Comment & Indicator: with this option, all of the comments and their indicators in the workbook will be displayed.

3. Then click Close. You will get the following results:

If you check None option, all of the comment and their indicators have be hidden. See screenshot:

If you choose Indicator option, all of the comments will be hidden and only display their indicators. See screenshot:

If you click Comment & Indicator option, all of the comments and their will be displayed. See screenshot:

List all comments in a new workbook or worksheet

If you want to get a list of all comments, this utility can help you quickly solve this problem.

1. Go to the Cell Comment Tools dialog box, and click View from the top menu. And then specify the scope: active sheet or all sheets which you want to list the comments.

2. Then choose to create the list in a new workbook or new worksheet. See screenshot:

A: If you choose Active sheet, all of the comments of current worksheet will be listed. And If you choose All sheets, all of the comments of the workbook will be listed. B: In a new workbook, It will list all comments in a new workbook. In a new sheet, All comments will be listed in a new worksheet.

3. Then click Create comment list button. The comments have been listed in a new worksheet or workbook. See screenshot:

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

Sometimes, you need to copy one cell comment formatting to all of other cell comments. Maybe, in Excel, it is somewhat difficult for you, but with this Cell Comment Tools, you can easily deal with it.

1. Go to the Cell Comment Tools dialog box, click Format tab, specify the scope which you want to format, Active sheet or All sheet. See screenshot:

A: If you choose Active sheet, all of the comments of current worksheet will be formatted. And if you choose All sheets, all of the comments of the workbook will be formatted. B: Force non-bold formatting: There will not be any content with bold font style in all comments. C: If you check Show summary, you will get a prompt box to remind you how many cell comments have been changed the formatting.

2. Then click Specify the comment cell button to select a cell that contains comment formatting you need, and the formatting of selected comment cell will be applied to all other comments. See screenshots:

Find and replace the text within the comments

When you need to replace the same information with other data within the comments, normally you can find and replace them manually, but it is a time-consuming job. With the Cell Comment Tools, you can quickly finish it.

1. In the Cell Comment Tools dialog box, click Find/Replace tab, specify the scope which you want to replace the comment contents, Active sheet or All sheets. And specify other operations. See screenshot:

A: If you choose Active sheet, all of the same text within comments of current worksheet will be found and replaced. And if you choose All sheets, all of the same text within comments of the workbook will be found and replaced. B: Input content in the Find text in comments box and input content in the Replaced with box. C: If you checked Show summary, there will be a prompt box to remind you how many cell comments have been changed.

2. Then click Replace button to find and replace the text in the comments. See screenshots:

Add or remove the user name for the comments

When you insert a comment into Excel, your user name is automatically inserted into the comment followed by a colon. Sometimes, you don’t want these user names, how do you remove them at once? But when you want to use them, how could you add them quickly?

Remove the username from the comments:

1. Go to the Cell Comment Tools dialog box, click Username, select the scope which you want to remove the user name. See screenshot:

A: If you choose Active sheet, all of the comment user name in current worksheet will be deleted. And if you choose All sheets, all of the comment user name in the workbook will be deleted. B: Input the user name you want to remove. C: Force non-bold formatting: There will not be any content with bold font style in all comments. D: If you checked Show summary, there will be a prompt box to remind you how many cell comments user name have been removed.

2. Then check Remove user name from comments, and click Apply button. All of the username in the comments of the selected scope have been removed. See screenshots:

Add the username for the comments:

1. In the Cell Comment Tools dialog box, click Username, select the scope which you want to add the username. See screenshot:

A: If you choose Active sheet, the username will be added into current worksheet comments. And if you choose All sheets, the username will be added into all worksheets comments. B: Input the username you want to insert. C: If you want to format the username bold, please check Make name bold. D: If you checked Show summary, there will be a prompt box to remind you how many cell comments username have been added.

2. Then check Add user name to comments, and click Apply button. The username have been inserted into the comments of the selected scope. See screenshots:

Convert cell content to comment or convert comment to cell content

With the Convert function of this Cell Comment Tools, you can quickly convert cell contents to comments, convert comments to cell contents, add the cell text to the comment or add the comment text to cell value.

Convert cell contents to comments:

1. Apply the Cell Comment Tools by clicking Kutools > More > Cell Comment Tools, in the Cell Comment Tools dialog box, click Convert tab.

2. Use button to select the range that you want to convert cell contents to comments. Then click Replace cell contents with comment text option. See screenshot:

3. And then click OK, the selected cell contents have been converted to comments. See screenshots:

Convert comments to cell contents

1. Go to the Cell Comment Tools dialog box, click Convert tab.

2. Use button to select the cells which contain comments, and then click Replace comment contents with cell text option.

3. Then click OK, the selected cell comments have been converted to cell contents. See screenshots:

Add the cell text to the comment

1. Select the range that you want to add the cell text to the comment.

2. Go to the Cell Comment Tools dialog box, click Convert tab. And then select Add cell text to the comment option. See screenshot:

3. Then click OK. And the selected cell text has been inserted after the comment content. See screenshots:

Add the comment text to cell value:

On the other hand, this function also can help you to add the comment text to the cell value.

1. Select the range that you want to add the comment content to the cell value.

2. Go to the Cell Comment Tools dialog box, click Convert tab. And then select Add comment text to the cell option. See screenshot:

3. Then click OK. All of the comments have been inserted before the cell contents. See screenshots:

This is only one feature of Kutools for Excel

It includes more than 120 functions and tools for Excel 2013, 2010, 2007 and Office 365.