DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Reset All Comment Positions in Excel Office 365!! – {with Example}

Reset All Comment Positions in Excel:

In this article, we are going to see how to Reset All Comment Positions in Excel Office 365 using Kutools with the example. Let’s get into this article!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Note: kutools for Excel 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.

Reset Comment Position in the Active Worksheet:

To reset comment positions in the active sheet, do as follows.

  • In the below screenshot, you can see the cell range C3:C7 contains comments, and we are going to reset its comment position.

Example data
Example data

  • Go to the Kutools Tab, select the More option, choose Reset Comment Position from the menu, and select the Active Sheet option.

Choose the Active Sheet option
Choose the Active Sheet option

  • Now, the comments in the active worksheet have been reset to their initial positions as shown in the below image.

Result
Result

Reset Comment Position in the Whole Workbook:

To reset the comment position in the whole workbook, you need to do the below steps.

  • Go to the Kutools Tab, select the More option, choose Reset Comment Position from the menu, and select the All Sheets option.

Choose All Sheets option
Choose All Sheets option

Before Reset the comment:

Example data
Example data

After Resetting the comment:

Result
Result

Closure:

In the above article, you can understand the steps to Reset All Comment Positions in Excel Office 365 using Kutools with the example. Share your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!

Top comments (0)