How to Change the Author Property in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on December 12, 2022

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

 

change author 5

 

Whenever you open up a blank workbook, some document properties are created. Document properties, also known as metadata, are bits of information that describe and identify a workbook.

Change User Name

By default, the author metadata of a workbook is the name of the person who created the workbook. To change the name 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 click on Info. On the right look for Author under Related people, right-click on the author’s name, and 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 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 pops up, and if you are sure you want to change the owner click the Yes button.

 

change author 12

AI Formula Generator

Try for Free

See all How-To Articles