Modifying Excel author name requires a situation: 1. Modifying file attributes can clear or replace the author information of an existing document, and manually fill in the new author name when deleting the owner information through "File → Information → Check Document" or "Save As"; 2. Changing the default author name can modify the user name and abbreviation through "File → Options → General", but it is only applicable to new files; 3. Batch processing of multiple files can be used to modify metadata uniformly. All operations need to choose appropriate methods according to specific needs, and note that the system may cache old account information and need to check the settings in a timely manner.

Changing the author's name in Excel is actually quite simple, but many people may not know where to start, especially when they encounter this situation for the first time. In fact, no matter whether you want to remove other people's names, replace them with your own, or sign the unified team's documents, you can do it through a few small steps.

Find the "File Properties" setting

The author information of an Excel document exists in the file attributes and is not directly modified in the table content. So you have to open the Excel file first, then click the "File" menu in the upper left corner, select "Information" on the left, and then click "Check Document" or "Show All Properties" under "Related Permissions" on the right.
If you are using a Windows system, you can also right-click the file → Properties → Details, and you can also see the author's name here. However, if you want to change, you have to go back to Excel to operate.

Modify the default author name (applicable to new files)

If you want the new Excel file you create in the future to be your own name by default, rather than the original person's, you have to change the "Options" setting of Excel.
Specific operations:

• Open Excel → File → Options
• Find "Personal User Information" under the "General" tab
• Modify the two items "user name" and "abbreviation"
• Click OK to save

In this way, the newly created file will display the new name you set. But note: This method only affects new files and will not change the information of the old documents that have been created.

Completely clear or replace the author information of existing documents

If the document has been created and you want to completely clear or replace the original author information with another name, you need a more direct method.
You can do this:

• Open the target Excel file
• File → Information → Check Document → Document Checker
• If the document inspector prompts the author information, click the option "Delete owner information" or other

Another way is to select "Tools" → "General Options" → manually fill in the new author name when "Save As". Although this function is not conspicuous, it does work.

Use batch processing tools (suitable for multi-file operations)

If you have a bunch of Excel files that need to be changed to the author name, it is too troublesome to open them one by one. At this time, you can use some third-party tools, such as the "Explorer Property Editing" function that comes with Office, or find some small software that supports batch modification of document properties.
The operations of this type of tool are generally very intuitive. After uploading the file, you can batch modify the author, title, topic and other metadata information.

In short, it is not difficult to understand the logic of Excel when changing the author's name. The key is to know where to start. Sometimes the system will automatically remember the account information you have logged in before, resulting in the new file still carrying someone else's name. Remember to go back and check the default settings. Basically these are the operations.

The above is the detailed content of how to change the author name in excel. For more information, please follow other related articles on the PHP Chinese website!