See all How-To Articles

How to Change the Author Property in Excel & Google Sheets

This tutorial demonstrates how to change the author property in Excel and Google Sheets.

 

change author 5

 

Change User Name

By default, the “author” metadata of a workbook is the person who created the workbook. To change the name that will be assigned to files you create, follow these steps:

  1. In the Ribbon, go to File, and in the drop-down menu, click on Options.

 

change author 1

 

  1. To change your Author name, click on General in the menu on the left side.
    Under Personalize your copy of the Microsoft Office section, in the User name box, type the name you want as the Author property on your files.
    Click OK.

 

change author 2

 

Note: You can also use VBA code to change the user name.

Add Workbook Author(s)

To change the author properties by adding other authors for the current workbook, follow these steps:

  1. In the Ribbon, go to File, and in the drop-down menu, click on Info.

 

change author 3

 

  1. Under the Related People section, there’s an Add an author box, and in it type the name of a new author. Then, press ENTER.

 

change author 4 new

 

As a result, the name of a new author is added.

 

change author 7

 

Change Author Name on Existing File

To change the author’s name on an existing file, follow these steps:

  1. In the Ribbon, go to File and (1) click on Info. On the right look for Author under Related people, (2) right-click on the author’s name, and (3) choose Edit Property.

 

change author 13

 

  1. In the Edit person dialog box enter the name of the new author and click OK.

 

change author 14

 

As a result, the name of the author is changed.

 

change author 15

 

Change the Owner in Google Sheets

In Google Sheets, you can’t change the author, but you can change the owner of the file.

  1. Click on the Share button, which is placed in the top, right corner of the spreadsheet.

 

change author 8

 

  1. In the Add people and groups box type the name of a new editor and, when done, click the Share button. A new editor is added.

 

change author 10

 

  1. To change the ownership of the file, click on the arrow next to the name of the new editor, and in the drop-down menu, check the Make owner option.

 

change author 11

 

  1. As a final step, the confirmation window will pop up, and if you are sure you want to change the owner click the Yes button.

 

change author 12