Others

How to Change an Excel File Name for a New Tax Year

Jason MillerJason Miller Nov 3, 2026 869 views

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.

How to Change an Excel File Name for a 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 you start

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.

Solution 1Recommended

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.

1
Open the original tax file

Launch Microsoft Excel and open the tax spreadsheet from the previous year.

2
Access the Save options

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.

3
Rename the file for the new year

In the file name box, update the year (e.g., change 'Tax_2022.xlsx' to 'Tax_2023.xlsx'). Choose your desired save location.

4
Save the new file

Click the 'Save' button. Your original file is safely preserved, and you are now working in the new tax year's file.

Use the 'Save a Copy' or 'Save As' Feature in Excel
Data Preservation: Any changes you make moving forward will only apply to the newly named file. Your previous year's data is completely safe from accidental overwrites.
Seamless Spreadsheet Management

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. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your previous year's tax spreadsheet.
  2. 2. Click on 'Menu': Navigate to the top-left 'Menu' button and select 'Save As'.
  3. 3. Change the file name: Type in the new tax year in the File Name field.
  4. 4. Save the duplicate: Click 'Save' to securely preserve the original document and begin working on the new year's file.
Fully compatible with Microsoft Excel (.xlsx, .xls) formatsEasily duplicate and rename spreadsheets with the Save As functionFree to use, lightweight, and fast to launch on any deviceBuilt-in templates to help you start your tax planning faster
microsoft office alternative - wps office

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.