{"id":4654,"date":"2017-01-04T01:04:17","date_gmt":"2017-01-04T01:04:17","guid":{"rendered":"http:\/\/www.isunshare.com\/blog\/?p=4654"},"modified":"2023-04-13T08:28:08","modified_gmt":"2023-04-13T08:28:08","slug":"remove-or-change-comment-author-name-in-excel","status":"publish","type":"post","link":"https:\/\/www.isunshare.com\/blog\/remove-or-change-comment-author-name-in-excel\/","title":{"rendered":"How to Remove or Change Comment Author Name in Excel 2016\/2013\/2010"},"content":{"rendered":"<p>Don\u2019t like the user name set in Excel 2016\/2013\/2010 for comments? This post is intended to introduce how Excel users could <strong>change or remove author name<\/strong> of specified comment, or all new or existing comments.<\/p>\n<ul>\n<li><a href=\"#section1\">Change author name for one specified comment<\/a><\/li>\n<li><a href=\"#section2\">Change author name for new comments by Excel Options<\/a><\/li>\n<li><a href=\"#section3\">Change\/Remove author name of existing comments with Kutools<\/a><\/li>\n<\/ul>\n<h2 id=\"section1\">Change author name temporarily for specified comment:<\/h2>\n<p>When you edit the comment in Excel, author name also can be changed at the same time.<\/p>\n<ol>\n<li>Select the cell you want to change comment author.<\/li>\n<li>Click <strong>Review<\/strong> tab and choose <strong>Edit Comment<\/strong> option in <strong>Comments<\/strong> group.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/change-author-name-by-editing-comment.png\" rel=\"attachment wp-att-4660\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"309\" class=\"alignnone wp-image-4660 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/change-author-name-by-editing-comment.png\" alt=\"change author name by editing comment\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/change-author-name-by-editing-comment.png 700w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/change-author-name-by-editing-comment-300x132.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>Then you can edit the comment and change the comment author name.<\/p>\n<p>But if you don\u2019t like to change the author name every time when you add comment, how can you do? Now let\u2019s learn to <strong>change author name of new or existing comments<\/strong> permanently.<\/p>\n<p>&nbsp;<\/p>\n<h2 id=\"section2\">Change author name of new comments:<\/h2>\n<p>If you don\u2019t want to use the same author name in new comments, follow the steps to change new comment author name.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/old-comment-user-name-in-excel.png\" rel=\"attachment wp-att-4663\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"330\" class=\"alignnone wp-image-4663 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/old-comment-user-name-in-excel.png\" alt=\"old comment user name in excel\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/old-comment-user-name-in-excel.png 700w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/old-comment-user-name-in-excel-300x141.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p><strong>1.<\/strong> Click <strong>File &gt; Options<\/strong> in Excel 2016\/2013\/2010 or click <strong>Office button &gt; Excel Options &gt; Popular<\/strong> in Excel 2007.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/navigate-to-excel-options.png\" rel=\"attachment wp-att-4665\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"334\" class=\"alignnone wp-image-4665 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/navigate-to-excel-options.png\" alt=\"navigate to change excel options\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/navigate-to-excel-options.png 500w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/navigate-to-excel-options-300x200.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p><strong>2.<\/strong> In <strong>Excel Options<\/strong> dialog, click <strong>General<\/strong> in the left pane, and then go to <strong>Personalize your copy of Microsoft Office<\/strong>\u00a0in the right pane, change the <strong>User name<\/strong>\u00a0to new one and click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/change-user-name-for-new-comments.png\" rel=\"attachment wp-att-4666\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"353\" class=\"alignnone wp-image-4666 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/change-user-name-for-new-comments.png\" alt=\"change user name for new comments in excel options\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/change-user-name-for-new-comments.png 500w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/change-user-name-for-new-comments-300x212.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p>From then on, you can add new comments with new author name.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/add-new-comment-with-new-author-name.png\" rel=\"attachment wp-att-4668\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"322\" class=\"alignnone wp-image-4668 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/add-new-comment-with-new-author-name.png\" alt=\"add new comment to cell with new author name\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/add-new-comment-with-new-author-name.png 700w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/add-new-comment-with-new-author-name-300x138.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2 id=\"section3\">Change author name of all existing comments in workbook:<\/h2>\n<p>If you want to change existing comments author name, Kutools for Excel would help you to do easily.<\/p>\n<p><strong>1.<\/strong> Open the workbook you want to change the existing comment owner name.<\/p>\n<p><strong>2.<\/strong> Click <strong>Kutools &gt; More<\/strong> in <strong>Editing<\/strong> group, and select <strong>Find\/Replace Comment Text<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/select-replace-comment-text-option.png\" rel=\"attachment wp-att-4670\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"315\" class=\"alignnone wp-image-4670 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/select-replace-comment-text-option.png\" alt=\"choose to find and replace comment text in Kutools\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/select-replace-comment-text-option.png 700w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/select-replace-comment-text-option-300x135.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p><strong>3.<\/strong> In the <strong>Find\/Replace Comment Text<\/strong> dialog, set parameters like these.<\/p>\n<p><strong>Scope:<\/strong> select <strong>All sheets<\/strong> if you plan to change author name for all the comments in this workbook. If not, just select the <strong>Active sheets<\/strong> to do for the sheet you are inside.<\/p>\n<p><strong>Find text in comments:<\/strong> enter old author name in existing comments.<\/p>\n<p><strong>Replace with:<\/strong> enter new author name to replace old one in existing comments.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/set-parameters-to-find-and-replace-comment-user-name.png\" rel=\"attachment wp-att-4671\"><img loading=\"lazy\" decoding=\"async\" width=\"385\" height=\"304\" class=\"alignnone wp-image-4671 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/set-parameters-to-find-and-replace-comment-user-name.png\" alt=\"set parameters to find and replace comment user name\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/set-parameters-to-find-and-replace-comment-user-name.png 385w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/set-parameters-to-find-and-replace-comment-user-name-300x237.png 300w\" sizes=\"auto, (max-width: 385px) 100vw, 385px\" \/><\/a><\/p>\n<p><strong>4.<\/strong> Click <strong>Replace<\/strong> and <strong>OK<\/strong> button and all existing comments author name are changed to specified one.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/confirm-comment-user-name-change-with-kutools.png\" rel=\"attachment wp-att-4672\"><img loading=\"lazy\" decoding=\"async\" width=\"280\" height=\"154\" class=\"alignnone wp-image-4672 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/confirm-comment-user-name-change-with-kutools.png\" alt=\"confirm comment user name change with kutools\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/successfully-change-existing-comment-author-name.png\" rel=\"attachment wp-att-4673\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"342\" class=\"alignnone wp-image-4673 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/successfully-change-existing-comment-author-name.png\" alt=\"successfully change existing comments author name\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/successfully-change-existing-comment-author-name.png 700w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/successfully-change-existing-comment-author-name-300x147.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>If you don\u2019t want author name appear in any existing comment, just follow the steps to remove comment author name in Excel.<\/p>\n<h3>Remove author name of existing comments in Excel:<\/h3>\n<p><strong>1.<\/strong> In opening workbook, click <strong>Kutools &gt; More &gt; Remove\/Add User Name in Comment<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/choose-to-remove-user-name-in-comment.png\" rel=\"attachment wp-att-4675\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"315\" class=\"alignnone wp-image-4675 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/choose-to-remove-user-name-in-comment.png\" alt=\"choose to remove user name in existing comments\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/choose-to-remove-user-name-in-comment.png 700w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/choose-to-remove-user-name-in-comment-300x135.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p><strong>2.<\/strong> In the <strong>Remove\/Add User Name in Comment<\/strong> dialog, set some parameters.<\/p>\n<p><strong>Scope:<\/strong> select <strong>All sheets<\/strong> from drop-down list for all the comments in this workbook, or choose <strong>Active sheets<\/strong> for the current sheet.<\/p>\n<p><strong>User Name:<\/strong> enter the user name that you want to remove from existing comments.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/set-parameters-to-remove-user-name-from-comments.png\" rel=\"attachment wp-att-4676\"><img loading=\"lazy\" decoding=\"async\" width=\"385\" height=\"304\" class=\"alignnone wp-image-4676 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/set-parameters-to-remove-user-name-from-comments.png\" alt=\"set parameters to remove user name from existing comments\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/set-parameters-to-remove-user-name-from-comments.png 385w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/set-parameters-to-remove-user-name-from-comments-300x237.png 300w\" sizes=\"auto, (max-width: 385px) 100vw, 385px\" \/><\/a><\/p>\n<p><strong>3.<\/strong> Click <strong>Apply<\/strong> and <strong>OK<\/strong> button on pop-up dialog, and existing comment user name are removed.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/confirm-comment-user-name-remove.png\" rel=\"attachment wp-att-4677\"><img loading=\"lazy\" decoding=\"async\" width=\"280\" height=\"154\" class=\"alignnone wp-image-4677 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/confirm-comment-user-name-remove.png\" alt=\"confirm comment user name remove\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/successfully-remove-comment-user-name.png\" rel=\"attachment wp-att-4678\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"342\" class=\"alignnone wp-image-4678 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/successfully-remove-comment-user-name.png\" alt=\"successfully remove existing comments user name\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/successfully-remove-comment-user-name.png 700w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2017\/01\/successfully-remove-comment-user-name-300x147.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Related Articles:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.isunshare.com\/excel-password\/remove-forgotten-password-from-excel-files.html#part1\" target=\"_blank\" rel=\"noopener noreferrer\">How to Remove Excel 97-2013 (XLS) File Open Password<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/excel-password\/remove-restrict-editing-in-excel-without-password.html\" target=\"_blank\" rel=\"noopener noreferrer\">How to Remove Restrict Editing in Excel 2007-2016 without Password<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/excel-password\/remove-and-bypass-excel-sheet-protection-password.html\" target=\"_blank\" rel=\"noopener noreferrer\">Remove and Bypass Excel Sheet Protection Password on Workbook <\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/windows-password\/change-or-remove-built-in-administrator-password-without-admin-rights.html\" target=\"_blank\" rel=\"noopener noreferrer\">How to Change or Remove Built-in Administrator Password without Admin Rights<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Don\u2019t like the user name set in Excel 2016\/2013\/2010 for comments? This post is intended to introduce how&#8230;<\/p>\n","protected":false},"author":1,"featured_media":126194,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[230],"class_list":["post-4654","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-documents","tag-excel"],"_links":{"self":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/4654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/comments?post=4654"}],"version-history":[{"count":5,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/4654\/revisions"}],"predecessor-version":[{"id":6449,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/4654\/revisions\/6449"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media\/126194"}],"wp:attachment":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media?parent=4654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/categories?post=4654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/tags?post=4654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}