Log in
x
or
x
x
Register
x

or

Quickly change/remove/add author name in comments in Excel

In Excel, when you insert or create comments into cells, in default, your user name automatically is inserted with a colon into the comments at the same time. Sometimes, you do not want others view your user name in the comments, so you need to remove them one by one. But if there are hundreds of comments in your worksheet or workbook, you can use Kutools for Excel's Remove/Add User Name in Comment function to remove or add the user name of all comments at once.

Remove user name from comments in active worksheet/workbook

Add user name to comments in active worksheet/workbook


Click Kutools >> More >> Remove/Add User Name in Comment. See screenshots:


Remove user name in comments in active worksheet/workbook

With Remove/Add User Name in Comment, you can quickly remove the user names from all comments.

1. Active the worksheet or workbook which contains some comments that you want to remove the comment user names.

2. Click Kutools > More > Remove/Add User Name in Comment to display the Remove/Add User Name in Comment dialog. And In the Remove/Add User Name in Comment dialog, specify the settings you need. See screenshot:

A: In the Scope drop-down list, you can choose the active worksheet
or active workbook which you want to remove the comment user name.

B: In the User Name text box, type the user name you want to remove.
In default, it shows your default user name in the text box, you can
change it.

C: Check Remove user name from comments.

3. Click Apply, and another dialog displays to tell you how many comment user names have been removed. See screenshot:


4. Click OK and Cancel to close the dialogs, and the comment user names in the specified scope have been removed. See screenshot:

shot-change-author-name-5 -2 shot-change-author-name-6

Note: If you check Force non-bold formatting in the Remove/Add User Name in Comment dialog, the result shown as below:



Add user name to comments in active worksheet/workbook

If you want to add the user name to comments again, also you can quickly add them to the comments with the Remove/Add User Name in Comment function.

1. Active the worksheet or workbook you want to add the comment user names. Before you apply Remove/Add User Name in Comment, please make sure that there are comments in your active worksheet or workbook.

2. Click Kutools > More > Remove/Add User Name in Comment to display the Remove/Add User Name in Comment dialog. And in the Remove/Add User Name in Comment dialog, specify the setting you need. See screenshot:

A: In the Scope drop-down list, you can choose the active worksheet
or active workbook to add the comment user name.

B: In the User Name text box, type the user name you want to add.
In default, it shows your default user name in the text box, you can
change it.

C: Check Add user name to comments option.

3. Click Apply, and another dialog displays to tell you how many comment user names have been added. See screenshot:


4. Click OK and Cancel to close the dialogs, and your specific user names have been added to the comments of the selected scope. See screenshots:

shot-change-author-name-7 -2 shot-change-author-name-9

Note: If you uncheck Make name bold in the Remove/Add User Name in Comment dialog, the result shown as below:



Demo: Quickly change/remove/add author name in comments in Excel

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 200 Advanced Functions for Excel 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 200 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more     btn download     btn purchase

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.