It’s no good if you want to change only some. So, this changes all comments to be by XYZ. Here is the suggested VBA code: Sub ChangeAllAuthorNamesInComments()įor Each objComment In ActiveDocument.Comments This entry was posted in office and tagged Excel.Let’s say you’ve got a document with tracked changes in it, and the reviewer changes and comments are supposed to be by a corporate name - say XYZ Editing (apologies if this business exists) but they have been put in as by Fred Smith, an employee of XYZ.Ĭhanging the author of comments is pretty straightforward.
#Change the comments author name in word 2016 for mac how to
Remove author name of existing comments in Excel:ġ. If you don’t want author name appear in any existing comment, just follow the steps to remove comment author name in Excel. Click Replace and OK button and all existing comments author name are changed to specified one. Replace with: enter new author name to replace old one in existing comments.Ĥ. If not, just select the Active sheets to do for the sheet you are inside.įind text in comments: enter old author name in existing comments. Scope: select All sheets if you plan to change author name for all the comments in this workbook. In the Find/Replace Comment Text dialog, set parameters like these. Click Kutools > More in Editing group, and select Find/Replace Comment Text.ģ. Open the workbook you want to change the existing comment owner name.Ģ.
If you want to change existing comments author name, Kutools for Excel would help you to do easily.ġ.
In Excel Options dialog, click General in the left pane, and then go to Personalize your copy of Microsoft Office in the right pane, change the User name to new one and click OK.įrom then on, you can add new comments with new author name.Ĭhange author name of all existing comments in workbook: Click File > Options in Excel 2016/2013/2010 or click Office button > Excel Options > Popular in Excel 2007.Ģ. If you don’t want to use the same author name in new comments, follow the steps to change new comment author name.ġ. Then you can edit the comment and change the comment author name.īut if you don’t like to change the author name every time when you add comment, how can you do? Now let’s learn to change author name of new or existing comments permanently. Click Review tab and choose Edit Comment option in Comments group.Select the cell you want to change comment author.When you edit the comment in Excel, author name also can be changed at the same time. Change/Remove author name of existing comments with KutoolsĬhange author name temporarily for specified comment:.Change author name for new comments by Excel Options.Change author name for one specified comment.Don’t like the user name set in Excel 2016/2013/2010 for comments? This post is intended to introduce how Excel users could change or remove author name of specified comment, or all new or existing comments.
0 kommentar(er)
