Change Excel Author: Step-by-Step Guide
Ever received an Excel file that needs updating, but the author's name is not you? Changing the author of an Excel file might seem like a daunting task, but it's actually quite simple. In this article, we'll guide you through the process with clear, step-by-step instructions and useful tips.
Before we dive in, it's essential to understand why you might want to change the author's name. Maybe you're collaborating with a team, or perhaps you've inherited an old file that needs to be updated. Regardless of the reason, let's get started.
Understanding the Built-in Options
Excel doesn't have a direct feature to change the author's name in the file properties. However, it does allow you to modify certain properties that indirectly affect how your name is displayed. Let's explore these options.
Excel stores the author's name in the file's metadata. When you open a file, Excel fetches this information and displays the author's name in the document's 'Properties' section. But remember, these details aren't the official 'author' in the sense that Microsoft Word uses. They're just informative metadata.
Editing the Document Properties
To modify these properties, you can edit the document's metadata using the 'Edit Document Properties' feature. Here's how:
- Open your Excel file.
- Click on 'File' in the header ribbon.
- Select 'Info' from the left sidebar.
- Click on 'Properties' at the bottom of the page.
- In the 'Document Property' window, you can edit various fields like 'Title', 'Author', and 'Created By'.
- Click 'OK' to save your changes.
While this updates the display in the file's 'Properties' section, it doesn't truly replace the original author's name. The original author remains in the file's metadata but is no longer visible in the 'Properties' section.
Deleting and Re-solving the Author's Name
If you want to completely remove the original author's name and replace it with your own, you'll need to delete the metadata and re-save the file. Here's how:
First, follow the steps above to open the 'Document Property' window. Then:
- Click 'Remove Properties and Personal Information' at the bottom of the window.
- Choose 'Remove all' to delete all metadata, including the author's name.
- Click 'OK', then 'OK' again to close the windows.
- Save your file. Excel will now prompt you to enter the new author's name. Enter your name and click 'OK'.
The original author's name is now removed, and your name is displayed in the 'Properties' section. However, remember that this process also removes other metadata, like the file's creation date.
Changing the Metadata with an Elizabetta tool
If you want to retain the original metadata but change the author's name, you can use a third-party tool like 'Elizabetta'. This tool allows you to edit Microsoft Office file properties without opening the file.
To use Elizabetta:
- Download and install Elizabetta from a trusted source.
- Open Elizabetta and click on 'Add' to browse and select your Excel file.
- Click on the 'File' tab at the top of the list of properties.
- Scroll down to find the 'Author' field. Click on it and enter your name.
- Click 'Save' to apply the changes.
Elizabetta changes the file's metadata directly without opening it, preserving all original information while updating the author's name.
Why Not Use VBA?
Some power users might suggest using VBA (Visual Basic for Applications) to edit the file properties. However, unless you're comfortable with VBA, this method is not recommended for average users. Incorrect use of VBA can corrupt your file or make it incompatible with certain versions of Excel.
Moreover, VBA doesn't provide a user-friendly interface. It requires editing code line by line, which can be intimidating for beginners. For these reasons, we recommend using built-in features or tools like Elizabetta for changing the author's name in an Excel file.
In the vast world of Excel, changing the author's name might seem like a small task, but it's a crucial one for maintaining accurate file properties. Whether you're collaborating with a team, updating an old file, or just trying to keep your files organized, knowing how to change the author's name can save you time and confusion in the long run. Now that you're equipped with these tools and techniques, you're ready to tackle any metadata challenge that comes your way! Happy Excel-ing!