With the Remove/Add User Name in Comment utility of Kutools for Excel, you can quickly change the author name of all existing comments as the below demo shown. Quickly change the author name of all existing comments in Excel However, the author name of the old comments still kept the old one.

See screenshot:įorm now on, when you inserting new comments into your worksheet, the author name will be the new one as you specified above. In the Excel Options dialog box, click General in the left bar, then scroll to the Personalize your copy of Microsoft Office section in the right pane, then replace the old User name with the new one you need. Click File > Options in Excel 2010/2013/2016, or you can click the Office button > Excel Options > Popular in Excel 2007.Ģ. You can change the Excel user name in order to change the auther name of all new comments you will insert.ġ. Quickly change the author name of all existing comments in active or all sheets with Kutools for Excel How can you do? You can change the name of comment author in Excel as the following methods.Ĭhange the default author name of all new comments with configuring Excel OptionsĬhange the author name of all existing comments in the whole workbook with VBA code Sometimes, you may want to change the name of comment author. When you insert the comments into a worksheet, the name of the comment author is automatically inserted into the comment followed by a colon. How to change all comments’ author name in Excel?

Change reviewer name word 2016