How to Modify and Manage Multiple Cell Comments in Excel Office 365?
Tags: kutoolsexceltutorial, modifymultiplecellco, kutools
Published: 2020-11-20 09:53:24

---
title: How to Modify and Manage Multiple Cell Comments in Excel Office 365?
published: true
date: 2020-11-20 07:16:34 UTC
tags: KutoolsExcelTutorial,ModifyMultipleCellCo,Kutools
canonical_url: https://geekexcel.com/how-to-modify-and-manage-multiple-cell-comments-in-excel-office-365/
---

Here we come up with simple methods to **Modify and Manage Multiple Cell Comments in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## List All Comments in a New Workbook/Worksheet:

To get the list of all comments in the worksheet, do as below steps.

- First, you need to **activate the worksheet** or workbook which contains a lot of comments.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-11.png)<figcaption id="caption-attachment-16810">Example</figcaption>

- Go to the **Kutools Tab, select** the **More** option, then **choose** the **Create Comment List** option from the menu.

![Select the Create Comment List option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Create-Comment-List-option.png)<figcaption id="caption-attachment-16811">Select the Create Comment List option</figcaption>

- It will display the **Create Comment List Dialog Box**.
- **Scope –** In this drop-down list, you need to **select** the **active sheet** (all the comments in the current worksheet will be listed)or **all sheets** (all the comments in the workbook will be listed) option.
- **Comment listing –** You need to **choose** the I **n a new workbook** or **In a new sheet** option as you need.

![Click the Create button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-the-Create-button.png)<figcaption id="caption-attachment-16812">Click the Create button</figcaption>

- Then, **click** the **Create button** to view the list as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-5.png)<figcaption id="caption-attachment-16813">Result</figcaption>

## Steps to Change the Formatting of All Comments:

If you want to change the formatting of all comments in the worksheet, follow the below instructions.

- First, you need to **activate the worksheet** that you want to format all the comments with the same formatting.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-8.png)<figcaption id="caption-attachment-16769">Example</figcaption>

- On the **Kutools Tab, select** the **More** option, **choose** the **Format Comment** option from the menu.

![Select the Format Comment option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Format-Comment-option.png)<figcaption id="caption-attachment-16770">Select the Format Comment option</figcaption>

- It will open the **Format Comment Dialog box**.
- **Scope –**  In this drop-down list, you need to **select** the **active sheet** (all the comments in the current worksheet will be formatted)or **all sheets** (all the comments in the workbook will be formatted) option.
- **Force non-bold formatting [optional] –** It will non-bold any content with bold font style in all comments.

![Format Comment Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Format-Comment-Dialog-Box.png)<figcaption id="caption-attachment-16771">Format Comment Dialog Box</figcaption>

- Then, you need to **click** the **Specify the comment cell** button to select a cell that contains the comment formatting you need.

![Select the cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-cell.png)<figcaption id="caption-attachment-16772">Select the cell</figcaption>

- Then, the selected formatting will be applied to all other comments as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-3.png)<figcaption id="caption-attachment-16774">Result</figcaption>

## Find & Replace Text within the Comments:

To modify cell comments by replacing the same data with other data in the comments, follow the below steps.

- You need to **activate the worksheet** that contains the comments.

![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-33.png)<figcaption id="caption-attachment-17717">Example data</figcaption>

- Go to the **Kutools Tab, select** the **More** option, **choose** the **Find/Replace Comment Text** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-32.png)<figcaption id="caption-attachment-17718">Kutools Tab</figcaption>

- It will open the **Find/Replace Comment Text Dialog Box.**
- **Scope –** In this drop-down list, you need to **select** the **active sheet** or **all sheets** option.
- **Find text in comments –** You need to **enter** the **data** that you want to find.
- **Replace with –** Here, **type** the **data** which you want to replace with other content.

![Find/Replace Comment Text Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-31.png)<figcaption id="caption-attachment-17719">Find/Replace Comment Text Dialog Box</figcaption>

- Finally, **click** the **Replace** option to find and replace the text in the comments.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-27.png)<figcaption id="caption-attachment-17720">Output</figcaption>

## Add or Remove the Username for the Comments:

To modify multiple cell comments by adding or removing usernames in the comments, follow the below ways.

### Remove the Username from comments:

If you insert a comment in the Excel spreadsheet, the username will insert into the comments automatically. To remove the username, do as follows.

- Firstly, you need to **activate the worksheet** that contains some comments.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-15.png)<figcaption id="caption-attachment-17167">Example</figcaption>

- On the **Kutools Tab, select** the **More** option, **choose** the **Remove/Add User Name in Comment** option from the menu list.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-14.png)<figcaption id="caption-attachment-17168">Kutools Tab</figcaption>

- It will open the **Remove/Add User Name in Comment Dialog Box.**
- **Scope –**  In this drop-down list, you need to **select** the **active sheet** (all the usernames in the comments will be removed)or **all sheets** (all the usernames in the comments in the workbook will be deleted) option.
- **User Name box –** Here, you need to **enter** the **user name** that you want to remove.
- Then, you need to **check** the **Remove user name from comment** option.
- **Force non-bold formatting [optional] –** It will non-bold any content with bold font style in all comments.

![Remove/Add User Name in Comment Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-11.png)<figcaption id="caption-attachment-17169">Remove/Add User Name in Comment Dialog Box</figcaption>

- At last, you need to **click** the **Apply** option. You will see all the user name in the comments have been removed as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-9.png)<figcaption id="caption-attachment-17171">Result</figcaption>

### Add the username to the comments:

To insert the username into the comments, follow the below steps.

- You need to **activate the worksheet**.

![Input](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-5.png)<figcaption id="caption-attachment-17175">Input</figcaption>

- On the **Kutools Tab, select** the **More** option, **choose** the **Remove/Add User Name in Comment** option from the menu list.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-14.png)<figcaption id="caption-attachment-17168">Kutools Tab</figcaption>

- It will open the **Remove/Add User Name in Comment Dialog Box**.
- **Scope –** You need to **choose** the **active worksheet** or **active workbook** option that you want to add the username from the comments.
- **User Name –** In this box, you need to **type the user name** that you want to add in the comments. By default, it will show the default user name, you can change it.
- Then, you need to **check** the **Add user name to comments** option.

![Click Apply button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-5.png)<figcaption id="caption-attachment-17174">Click Apply button</figcaption>

- After that, you need to **click** the **Apply** button.
- At last, you can see that the specific user names have been added to the comments as shown in the below screenshot.

![Input Comments](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-7.png)<figcaption id="caption-attachment-17173">Input Comments</figcaption>

## Convert Cell Content to Comment or Convert Comment to Cell Content:

### Convert Cell Content to Comment:

- First, you need to **activate the worksheet** and **select the range** that you want to convert the cell contents to comments.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-19.png)<figcaption id="caption-attachment-16915">Example</figcaption>

- Go to the **Kutools Tab, select** the **More** option, then **choose** the **Convert Comment and Cell** option from the drop-down list.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-4.png)<figcaption id="caption-attachment-16916">Kutools Tab</figcaption>

- It will open **Convert Comment and Cell Dialog box.**
- Then, you need to **choose** the **Convert Content of cells into comments** option from the dialog box.
- Now, **hit** the **OK** button to see the result.

![Convert Comment and Cell Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Convert-Comment-and-Cell-Dialog-Box.png)<figcaption id="caption-attachment-16917">Convert Comment and Cell Dialog Box</figcaption>

- You can see that all the selected cell contents have been converted to their comments as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-9.png)<figcaption id="caption-attachment-16918">Result</figcaption>

### Convert Comment to Cell Content:

- You need to **activate the worksheet** that contains comments.
- Then, **select** the **input range** that you want to convert comments to cell contents.

![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-6.png)<figcaption id="caption-attachment-16920">Example data</figcaption>

- On the **Kutools Tab, select** the **More** option, then **choose** the **Convert Comment and Cell** option from the drop-down list.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-4.png)<figcaption id="caption-attachment-16916">Kutools Tab</figcaption>

- It will open **Convert Comment and Cell Dialog box.**
- In that dialog box, you need to **select** the **Convert comments into contents of cells** option.
- At last, **click** the **OK** button to get the result.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-5.png)<figcaption id="caption-attachment-16921">Click the OK button</figcaption>

- Now, you can see that all comments will convert to their cell contents as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-5.png)<figcaption id="caption-attachment-16923">Output</figcaption>

## End of the Article:

In this tutorial, we guided you to know the simple methods to **Modify and Manage Multiple Cell Comments in Excel Office 365** using **Kutools ** with clear-cut examples. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Summarize/Calculate Data From Multiple Worksheets in Excel!!](https://geekexcel.com/summarize-calculate-data-from-multiple-worksheets-in-excel/)
- [Add the Same Text or Characters in a Range of Cells in Excel 365](https://geekexcel.com/how-to-add-the-same-text-or-characters-in-a-range-of-cells-in-excel-365/)