跳到主要內容

如何在Excel中更改所有評論的作者姓名?

當您將註釋插入工作表時,註釋作者的名稱會自動插入註釋中,並以冒號開頭。 有時,您可能想更改評論作者的名稱。 怎麼辦您可以通過以下方法在Excel中更改評論作者的名稱。

doc更改作者姓名1

透過配置 Excel 選項來變更所有新評論的預設作者姓名

使用Kutools for Excel快速更改活動或所有工作表中所有現有註釋的作者姓名

使用VBA代碼更改整個工作簿中所有現有註釋的作者姓名


透過配置 Excel 選項來變更所有新評論的預設作者姓名

您可以更改Excel用戶名,以更改將插入的所有新註釋的作者名。

1。 點擊 文件 > 選項 在Excel 2010/2013/2016中,也可以單擊 Office 按鍵 > Excel選項 > 熱門 在Excel 2007中。

2。 在 Excel選項 對話框中,單擊左側欄中的常規,然後滾動到 個性化您的Microsoft Office副本 右窗格中的“部分”,然後替換舊的 用戶名 與您需要的新產品。 最後點擊 OK 按鈕。 看截圖:

doc更改作者姓名1

現在開始,當您在工作表中插入新註釋時,作者名稱將是您上面指定的新名稱。 但是,舊評論的作者姓名仍然保留舊評論。


快速更改Excel中所有現有註釋的作者姓名

隨著 刪除/添加評論中的用戶名 的效用 Excel的Kutools,您可以快速更改所有現有評論的作者姓名,如下所示。 立即下載並試用! (30 天免費試用)


使用 Kutools for Excel 輕鬆找到所有現有評論的作者姓名並將其替換為新評論

除了上面的方法之外,這裡我給大家推薦一下 刪除/添加評論中的用戶名 的效用 Excel的Kutools。 使用此實用程序,您可以輕鬆地將所有現有註釋的作者名更改為不僅需要在活動工作表中而且在整個工作簿中都需要的新註釋。

申請前 Excel的Kutools首先下載並安裝.

1.轉到要在其中更改所有評論作者姓名的工作表,然後單擊 庫工具 > 更多 > 刪除/添加評論中的用戶名。 看截圖:

2。 在裡面 刪除/添加評論中的用戶名 對話框,需要進行如下配置:

首先,從指定範圍內的所有註釋中刪除作者姓名。
  • (1)在 範圍 下拉列表,如果您只想更改當前工作表中的作者姓名,請選擇 活動表 選項。 要在整個工作簿中更改作者姓名,請選擇 所有工作表 選項。
  • (2)選擇 從評論中刪除用戶名 選項。
  • (3)點擊 登記 按鈕。
  • (4)在彈出的對話框中,單擊 OK 按鍵
然後將新的作者名稱添加到指定範圍內的所有註釋中。
  • (1)將新的評論作者姓名輸入到 用戶名 框,然後選擇 在評論中添加用戶名 選項;
  • (2)點擊 登記 按鈕;
  • (3)在彈出的對話框中,單擊 OK 按鈕;
  • (4)點擊 關閉 按鈕關閉對話框。

尖端:要使用此功能,您應該安裝 Excel的Kutools 首先,請 點擊下載並獲得 30 天免費試用

使用VBA代碼將範圍內的所有負數轉換為正數

如果要更改整個工作簿中所有現有註釋的作者名,則以下VBA代碼將為您提供幫助:

1. 請同時按Alt + F11鍵以打開 Microsoft Visual Basic for Applications。 而在中 適用於應用程序的Microsoft Visual Basic 窗口中,單擊 插入 > 模塊,然後將以下代碼複製並粘貼到 窗口:

VBA代碼:更改整個工作簿中所有現有註釋的作者姓名

Sub ChangeCommentName()
'Updateby20140509
Dim xWs As Worksheet
Dim xComment As Comment
Dim oldName As String
Dim newName As String
xTitleId = "KutoolsforExcel"
oldName = InputBox("Old Name", xTitleId, Application.UserName)
newName = InputBox("New Name", xTitleId, "")
For Each xWs In Application.ActiveWorkbook.Worksheets
    For Each xComment In xWs.Comments
        xComment.Text (Replace(xComment.Text, oldName, newName))
    Next
Next
End Sub

2。 按 F5 鍵來運行代碼,然後 Kutoolsfor Excel 對話框彈出並在文本框中顯示舊的註釋作者名稱,請單擊 OK 按鈕。 看截圖:

doc更改作者姓名1

3。 然後另一個 Kutoolsfor Excel 對話框彈出,請在文本框中輸入所需的新評論的作者姓名,然後單擊 OK 按鈕。 看截圖:

doc更改作者姓名1

現在,現有註釋的所有作者名稱將立即在整個工作簿中更改為新名稱。

doc更改作者姓名1

備註:此方法不適用於您插入的新註釋。


示範:使用 Kutools for Excel 變更所有評論的作者姓名


Excel的Kutools:超過 300 個方便的工具觸手可及! 立即開始 30 天免費試用,沒有任何功能限制。 現在就下載!
Comments (22)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
You have got some great posts in your blog. Keep up with the good work.
This comment was minimized by the moderator on the site
I was very pleased to find this site. I wanted to thank you for this great read!! I definitely enjoyed every little bit of it and I have you bookmarked to check out the new stuff you post.
This comment was minimized by the moderator on the site
When I am using excel on my pc, this works cool on my version. After sometimes it creates reflection and disturbance too.Just visit the https://urbanclap.ae/cctv-installation/ and get the help from it.
This comment was minimized by the moderator on the site
this problem is accured when i m use online spreadsheet and its happens again n again.


url:https://tinyurl.com/yd3y47up
This comment was minimized by the moderator on the site
you may be using older version here ludo: https://play.google.com/store/apps/details?id=com.CRE8.LudoChat
This comment was minimized by the moderator on the site
When I am using excel on my pc, this works cool on my version. After sometimes it creates reflection and disturbance too. I thought that is a windows problem so I contact https://babasupport.org/microsoft/windows-customer-service/150 which hear my problem came and give me right solution about it. It is my version problem, hope it helps other too.
This comment was minimized by the moderator on the site
Good Day,
Thank you for sharing.
This comment was minimized by the moderator on the site
Google Chrome is totally free and trusted web browser for windows. It is the best choice when you want a multipurpose tool for web experience. Google chrome is a most popular web browser which is used today in terms of security, usability, privacy, and sign in features. While comparing with different browsers, google chrome is quicker. Google Customer Service Number
This comment was minimized by the moderator on the site
ist work on any version of excel?
This comment was minimized by the moderator on the site
The official?Replica watches?Series this is two separate series, but since they are called the?Rolex Daytona?series, so today we will they put it together. Explorer I and?Replica watches UK?Explorer II series have the old and the new series of the points, and now we buy in the market are mostly new series I watch explorers and the new Explorer II?Replica rolex. Probe I and Probe II What’s the difference, what is new and different from the old?Replica handbags, today will watch from home as we have explained in detail.
This comment was minimized by the moderator on the site
Mention Bamford rolex replica Department and you’ll get alloyed looks from watch lovers. Understandably, there are those who anticipate that customizing a Rolex is about sacrilegious. On the added hand, there are those who avert Bamford and assert that they accommodate a air-conditioned advantage for watch lovers who adulation replica watches but wish something a little different, for a array of reasons. I’m not a fan of all of their work, but I’m absolutely addicted of their new Heritage collection. Clearly, I’m not alone, because in just the abbreviate amount of a few months aback its introduction, Bamford is bolstering their Heritage accumulating with two added watches - the Bamford Heritage Explorer I and the replica watches uk Bamford Heritage Bicolor Paul Newman Daytona watch.
This comment was minimized by the moderator on the site
It is with abundant pride replica watches that we both advertise and congratulate the breitling replica newest winners of the 2015 TYLENOL? Future Care Scholarship. These 40 acceptance accept displayed bookish excellence, admirable leadership, association involvement, and rolex replica adherence to a career of caring for others.
There are no comments posted here yet
Load More
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations