How to Change Author Name in Excel Comments (3 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

In every Microsoft Excel Worksheet, there is the name of the author of that file. However, we can change the author’s name. It’s not a tough task at all. You will agree with me after reading the following article where I am going to explain 3 simple ways on the topic how to change author name in Excel Comments.

Table of Contents hide

Download Practice Workbook

3 Simple Ways to Change Author Name in Excel Comments

1. Changing Author Name from User Name Box

2. Use of Info Option Under File Tab to Change Author Name in Comments in Excel

3. Insertion VBA Code to Change Author Name in Comments

Conclusion

Download Practice Workbook

Change Author Name.xlsm

3 Simple Ways to Change Author Name in Excel Comments

In this article, I am going to explain step-by-step procedures on changing the author name in Excel comments.

1. Changing Author Name from User Name Box

There is a very simple way to change author name in excel comments. In this way, we just need to change the author name from the User Name box. The details have been described below.

Steps:

Go to the File tab first.

After that, click on Options.

An Excel Options wizard will appear.

Next, go to the User Name section under Personalize your copy of Microsoft Office.
Write the new name that you want to add.
Finally, press the OK button to complete the process.

Thus, we can simply change the author name in Excel comments.

2. Use of Info Option Under File Tab to Change Author Name in Comments in Excel

There is another easy and effective way to change the author name from the File tab. The whole procedure is described below.

Steps:

First of all, click on the File tab.
Then, click on the Info option.

We can see the author name under the Related People section.

Now, put the cursor on the author name and right-click on the mouse.
From the available option, pick the Edit Property option.

A box named Edit person will appear.

Input the new name in the Enter names or e-mail addresses section.
Finally, press ENTER and we will have the changed author name in Excel comments.

Similar Readings

3. Insertion VBA Code to Change Author Name in Comments

Visual Basic Analysis (VBA) is the most advanced way to execute any program in Excel. You just need to follow the following procedure to execute the code.

Steps:

At first, go to the Developer tab.
From the ribbon, click on Visual Basic.

Now, double-click on the sheet name.

Then, a space for code writing will appear.

Now, input the following code.

Sub ChangeAuthorName()
Dim Wrksht As Worksheet
Dim Cmnt As Comment
Dim PreviousName As String
Dim NewName As String
xTitleId = "Change Author Name"
PreviousName = InputBox("Old Name", xTitleId, Application.UserName)
NewName = InputBox("New Name", xTitleId, "")
For Each Wrksht In Application.ActiveWorkbook.Worksheets
    For Each Cmnt In Wrksht.Comments
        Cmnt.Text (Replace(Cmnt.Text, PreviousName, NewName))
    Next
Next
End Sub

Afterward, click on the Run button.

Then, a wizard will appear with the previous name on it.

Click on OK.

Finally, input the new name in the next wizard and press OK.

Thus, we can change simply the author name.

Conclusion

At the end of this article, I like to add that I have tried to explain 3 simple ways on the topic how to change author name in Excel Comments. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our site for more articles about using Excel.