How to Change the Shape of Comment Box in Excel Office 365?
Tags: changeshapeofcomment, kutoolsexceltutorial, kutools
Published: 2020-11-18 10:43:05

---
title: How to Change the Shape of Comment Box in Excel Office 365?
published: true
date: 2020-11-18 07:18:29 UTC
tags: ChangeShapeofComment,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-change-the-shape-of-comment-box-in-excel-office-365/
---

In this article, we are going to see how to **Change the Shape of the Comment Box 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.
## Change All Comment Boxes with Single Click:

You can change the shape of all comment boxes with one click by doing the below steps.

- Let’s consider the below example where you can see the comments. We are going to change the shape of all comments shown below.

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

- On the **Kutools Tab, select** the **More** option, then **choose** the **Change Comment Shape** option.

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

- It will open the **Change Comment Shape Dialog Box**.
- **Select shape –** You need to **select any one shape** that you like and **click** the **Apply All** button.

![Click the Apply All option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-26.png)<figcaption id="caption-attachment-17554">Click the Apply All option</figcaption>

- Now, all the comment boxes have been changed as shown in the below image.

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

### Note:

- **Apply All –** This will apply the shape that you have selected for all comment boxes of the whole workbook.

## Batch Change Shapes for Selected Comment Boxes:

You can also batch change shapes for selected comment boxes in the Excel spreadsheet, to do that, follow the below steps.

- In the below screenshot, you can see the comments with the same shape, we are going to change the shape for the selected cells with a single click.

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

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

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

- It will display the **Change Comment Shape Dialog Box**.
- **Comments list –** Here, you need to select the comments that you want to batch change the shapes of comment boxes.

- If you want to **select multiple adjacent comments** in the worksheet, you need to use the **SHIFT key** to select them all.
- To **select non-adjacent comments** from the worksheet you need to hold down the **CTRL** Key.

- **Select shape box –** You need to select the shape that you want to apply.

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

- Next, **click** the **Apply** button.
- Now, you will see that all the selected comment boxes are batch changed to the selected shape as shown in the below image.

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

## Apply Different Shapes for Different Comment Boxes:

To apply different shapes for different comment boxes in Excel, follow the below steps.

- In the below image, you can see the comments with the same shape. We are going to change the shape for every comment in the worksheet.

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

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

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

- It will display the **Change Comment Shape Dialog Box**.
- **Comments list – ** To apply the different shapes, you need to **select** the **comment** and **choose** the **shape** that you want to apply from the **Select shape** option. **Repeat** the **same step** to apply different shapes.

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

- After that, you need to **click** the **Close** option to view the results.

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

This is how you can change the shape of the comments in the worksheet.

## Closure:

In the above article, you can easily understand the steps to **Change the Shape of the Comment Box in Excel Office 365** Using **Kutools. ** Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Calculate Cell Values Based on Font, Background, or Conditional Color in Excel 365!!](https://geekexcel.com/wp-admin/post.php?post=17430&action=edit)
- [Remove Spaces Before/After Text or Remove Extra Spaces from Text in Excel!!](https://geekexcel.com/wp-admin/post.php?post=17481&action=edit)