跳到主要内容

如何在Excel中更改所有评论的作者姓名?

作者:技术支持 最后修改时间:2024-01-23

当您将注释插入工作表时,注释作者的名称会自动插入注释中,并以冒号开头。 有时,您可能想更改评论作者的名称。 怎么办您可以通过以下方法在Excel中更改评论作者的名称。

doc更改作者姓名1

通过配置 Excel 选项更改所有新评论的默认作者姓名

使用 Kutools for Excel 快速更改活动或所有工作表中所有现有评论的作者姓名

使用VBA代码更改整个工作簿中所有现有注释的作者姓名


通过配置 Excel 选项更改所有新评论的默认作者姓名

您可以更改Excel用户名,以更改将插入的所有新注释的作者名。

1。 点击 文件 > 附加选项 在Excel 2010/2013/2016中,也可以单击 办公 按键 > Excel选项 > 热门服务 在Excel 2007中。

2。 在 Excel选项 对话框中,单击左侧栏中的常规,然后滚动到 个性化您的Microsoft Office副本 右窗格中的“部分”,然后替换旧的 用户名 与您需要的新产品。 最后点击 OK 按钮。 看截图:

doc更改作者姓名1

现在开始,当您在工作表中插入新注释时,作者名称将是您上面指定的新名称。 但是,旧评论的作者姓名仍然保留旧评论。


快速更改Excel中所有现有注释的作者姓名

随着 删除/添加评论中的用户名 实用程序 Kutools for Excel,您可以快速更改所有现有注释的作者姓名,如下所示。 立即下载并试用! (30 天免费试用)


使用 Kutools for Excel 轻松查找所有现有评论的作者姓名并将其替换为新评论

除了上面的方法之外,这里我给大家推荐一下 删除/添加评论中的用户名 实用程序 Kutools for Excel。 使用此实用程序,您可以轻松地将所有现有注释的作者名更改为不仅需要在活动工作表中而且在整个工作簿中都需要的新注释。

申请前 Kutools for Excel首先下载并安装.

1.转到要在其中更改所有评论作者姓名的工作表,然后单击 库工具 > 更多 > 删除/添加评论中的用户名。 看截图:

2.在 删除/添加评论中的用户名 对话框,需要进行如下配置:

首先,从指定范围内的所有注释中删除作者名称。
  • (1)在 范围 下拉列表,如果您只想更改当前工作表中的作者姓名,请选择 活动表 选项。 要在整个工作簿中更改作者姓名,请选择 所有工作表 选项。
  • (2)选择 从评论中删除用户名 选项。
  • (3)点击 申请 按钮。
  • (4)在弹出的对话框中,单击 OK 按键
然后将新的作者名称添加到指定范围内的所有注释中。
  • (1)将新的评论作者姓名输入到 用户名 框,然后选择 在评论中添加用户名 选项;
  • (2)点击 申请 按钮;
  • (3)在弹出的对话框中,单击 OK 按钮;
  • (4)点击 关闭 按钮关闭对话框。

Tips::要使用此功能,您应该安装 Kutools for Excel 首先,请 点击下载并享受 30 天免费试用 现在。

使用VBA代码将范围内的所有负数转换为正数

如果要更改整个工作簿中所有现有注释的作者名,则以下VBA代码将为您提供帮助:

1. 请同时按Alt + F11键以打开 Microsoft Visual Basic应用程序. 而在 适用于应用程序的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 键来运行代码,然后 KutoolsForexcel. 对话框弹出,并在文本框中显示旧的评论作者名称,请单击 OK 按钮。 看截图:

doc更改作者姓名1

3。 然后另一个 KutoolsForexcel. 对话框弹出,请在文本框中输入所需的新评论的作者姓名,然后单击 OK 按钮。 看截图:

doc更改作者姓名1

现在,现有注释的所有作者名称将立即在整个工作簿中更改为新名称。

doc更改作者姓名1

备注:此方法不适用于您插入的新注释。


演示:使用 Kutools for Excel 更改所有评论的作者姓名


Kutools for Excel:超过 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
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations