How to change all comments’ author name in Excel?


This tutorial will lead you through the steps necessary to update the Author name that is associated with the cell comments in Excel. How can I rapidly alter the author names for all of the comments in the currently open Worksheet? Let's imagine you want to change the author names in Excel for all of the comments that are already in the spreadsheet you're working on right now, and you want to modify the author names in Excel for all of the comments that are already there.

The Excel comments each have a single user name attached to them. This comment's name is the default user name for the Microsoft Office user account that was used to insert the comment in the Excel application. On the other hand, certain Excel users may require a modification to the default names for spreadsheet cell comments, or they may choose to delete them entirely. Check out the many options available in Excel for modifying or erasing the user names that are associated with cell comments if you are curious about the specifics of how this can be accomplished.

Changing All Comments' Author Name in Excel

You can alter the Excel user name to change the author’s name of any new comments you insert. This can be done by going to File, Options, and changing the user’s name.

Users of Excel who need to share their spreadsheets with other people will surely find the comment function of Excel to be quite useful. The Microsoft Excel software attracts attention to comments by placing tiny red arrows in the upper right corner of the cells that contain them. When you move your cursor over a cell's tiny red arrow, the cell's comment box will become visible.

Let’s understand step by step with an example.

Step 1

In the first step, you may see the default author name. Refer to the below screenshot for the same.

Step 2

Select options from the File Menu. This will bring up Excel's customization window. As shown in the below screenshot.

Step 3

Click the General menu on the left side of the Excel Options dialogue box, and then write a new user name into the User name text box in the Personalize your copy of Microsoft Office part of the dialog box. Simply select the Ok button. Please refer to the below screenshot for the same.

Step 4

Now, select any cell, in the below screenshot we have selected cell A6. Right click and choose insert comment option from the dropdown list.

Step 5

Whenever you add a new comment to your worksheet, the name of the newly added author will automatically be included. Please refer to the below screenshot for the same.

Conclusion

We hope this tutorial helped you understand how you can change the author names of all the comments in Excel.

Updated on: 06-Feb-2023

3K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements