How to Change an Excel File Name for a New Tax Year
Question details
The user wants to create a duplicate of an existing Excel tax file and update the file name to reflect the new tax year.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Preparing documentation for a new tax year by using the previous year's spreadsheet as a starting point.
- Observed behavior
- The user needs a method to save the current worksheet with a new name that includes the current year, without overwriting or altering the previous year's original file.
Before duplicating your spreadsheet, make sure you have fully completed and saved all final edits to your previous year's tax file so that your historical records remain accurate.
Use the 'Save a Copy' or 'Save As' Feature in Excel
This is the most direct and reliable method to create a duplicate file for the new year while keeping your original spreadsheet open and protected.
Using the built-in Save As function allows you to instantly generate a carbon copy of your spreadsheet under a new name. Once saved, Excel will automatically switch your active window to the newly named file, allowing you to start updating the data for the new tax year.
Launch Microsoft Excel and open the tax spreadsheet from the previous year.
Click on the 'File' tab in the top-left corner of the ribbon menu, then select 'Save a Copy' or 'Save As' from the left sidebar.
In the file name box, update the year (e.g., change 'Tax_2022.xlsx' to 'Tax_2023.xlsx'). Choose your desired save location.
Click the 'Save' button. Your original file is safely preserved, and you are now working in the new tax year's file.

Duplicate the File via File Explorer or Finder
You can also duplicate the file directly from your computer's folder system without opening Excel first.
Easily Manage Yearly Tax Spreadsheets with WPS Office
WPS Office offers a powerful and free Spreadsheet application that makes duplicating, managing, and organizing your yearly financial records effortless. With a familiar interface, you can manage your tax files quickly without steep learning curves.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your previous year's tax spreadsheet.
- 2. Click on 'Menu': Navigate to the top-left 'Menu' button and select 'Save As'.
- 3. Change the file name: Type in the new tax year in the File Name field.
- 4. Save the duplicate: Click 'Save' to securely preserve the original document and begin working on the new year's file.

Frequently Asked Questions
How do I clear out last year's data after saving the new tax file?
Once you have saved the file with the new year's name, highlight the specific cells containing last year's raw data (such as income or expenses) and press the Delete key. Be careful not to delete cells that contain formulas or structural formatting, as those will calculate your new totals automatically when you input new data.
Can I save my tax spreadsheet as a reusable template?
Yes. If you want to use the same layout every year without manually deleting old data, clear the raw input data from your sheet first. Then go to File > Save As, and choose 'Excel Template (*.xltx)' from the file format dropdown. Next year, opening this template will generate a fresh, blank worksheet.
What happens if I accidentally click 'Save' instead of 'Save As'?
If you hit 'Save', you will overwrite your old tax year's file. If the file is still open, immediately press Ctrl + Z (Windows) or Cmd + Z (Mac) repeatedly to undo your changes, then use 'Save As'. If you have already closed the file, check your cloud storage (like OneDrive or Google Drive) for 'Version History' to restore the previous version.




