The quickest way to rename an Excel file
Right-click the file in File Explorer (Windows) or Finder (Mac), select "Rename", type the new name, and press Enter. That is the fastest method for a single file. If you are renaming many files at once, or if you want to rename a file that is currently open in Excel, the steps change slightly — and knowing the difference saves you from accidentally creating duplicate files or losing track of which version you are working in.
The method you choose depends on whether the file is open in Excel right now. If it is closed, use the file manager. If it is open, use Save As inside Excel instead. This keeps Excel aware of what you are doing and prevents the file from saving under the wrong name.
Key Takeaways
- The simplest rename happens outside Excel: right-click the file in your file manager, choose Rename, type the new name, and press Enter.
- If the file is open in Excel, use File > Save As instead of renaming it in the file manager, or you risk saving over the wrong version.
- Excel file names can include spaces, hyphens, and underscores, but avoid special characters like asterisks, question marks, and forward slashes.
- Renaming a file does not change its contents or break any links to it, as long as you do not move it to a different folder at the same time.
Renaming a file that is not open in Excel
This is the method to use when the file is sitting in your folder and you are not currently working inside it. On Windows, open File Explorer, find the file, right-click it, and click "Rename". The file name will become editable — the text will highlight. Type the new name and press Enter. On Mac, open Finder, locate the file, right-click it (or Control-click if you have a single-button mouse), and select "Rename". Type the new name and press Return.
The file extension — the .xlsx or .xls at the end — usually stays hidden in both Windows and Mac. If you see it and want to keep it, do not delete it when you type the new name. If you accidentally delete the extension, the file may not open in Excel anymore. Windows will usually warn you before you press Enter if you have removed the extension; Mac will not.
One common mistake: renaming a file in the file manager while it is open in Excel. If you do this, Excel may not know the file has been renamed, and the next time you save, it might save under the old name or ask you which version you want to keep. Avoid this by closing the file in Excel first, renaming it, then opening the renamed version.
Renaming a file that is currently open in Excel
If you are working inside the file and want to change its name, use File > Save As instead of renaming it in the file manager. This tells Excel that you are intentionally creating a new file with a different name, rather than renaming the existing one behind its back. Click File in the top menu, then click "Save As". A dialog box will open showing the current file name.
Type the new name in the "File name" field. Make sure the folder location has not changed — it should still show the folder where you want the file to live. Check the "Save as type" field to confirm it still says "Excel Workbook (.xlsx)" or whatever format you started with. Then click "Save". Excel will close the old version and open the newly named file. The old file will still exist in the same folder unless you delete it manually.
This method is safer than closing the file, renaming it outside Excel, and reopening it, because it keeps Excel in control of the process. It also means you can see exactly where the file is being saved before you commit to the new name.
What characters are safe to use in an Excel file name
Excel file names can include letters, numbers, spaces, hyphens, and underscores without any problem. A name like "2024 Budget - Final Version" or "Client_List_Updated" works fine. Avoid these characters: asterisk (*), question mark (?), forward slash (/), backslash (\), colon (:), pipe (|), and quotation marks ("). Windows and Mac will not let you type these into a file name, or they will strip them out automatically.
File names are also case-insensitive on both Windows and Mac, meaning "Budget.xlsx" and "budget.xlsx" are treated as the same file. If you rename a file and only change the capitalization, the system may not recognize it as a new name. Keep file names reasonably short — under 200 characters is safe on both systems, though shorter names are easier to read and type.
Renaming multiple Excel files at once
If you need to rename several files, doing them one at a time is tedious. Windows File Explorer has a built-in batch rename feature: select multiple files by clicking the first one, then holding Ctrl and clicking the others. Right-click any selected file and choose "Rename". Type a new name and press Enter. Windows will rename the first file to your new name, then automatically number the rest (for example, "Budget (2)", "Budget (3)"). You can then rename each one individually if you want different names.
Mac Finder does not have a built-in batch rename, but you can select multiple files and right-click to choose "Rename [number] items". A dialog will appear where you can choose to replace text in the names, add text before or after the existing names, or use a custom format. This is useful if all your files follow a pattern — for example, if you want to change "Report_Jan" and "Report_Feb" to "2024_Report_Jan" and "2024_Report_Feb" in one step.
What happens to links and formulas when you rename a file
Renaming a file does not break formulas or links inside it. If you have a spreadsheet with formulas that reference cells in the same file, those formulas keep working after you rename the file. However, if another Excel file contains a link to the file you are renaming — for example, a formula that pulls data from it — that link may break. Excel will usually ask you to update the link the next time you open the file that contains it.
To avoid broken links, rename files before other files start linking to them, or use relative links instead of absolute file paths if your version of Excel supports it. If you have already created links and then renamed a file, open the file that contains the link, and Excel will prompt you to find the renamed file and re-establish the connection.
Renaming files in OneDrive or SharePoint
If your Excel file is stored in OneDrive or SharePoint instead of your local computer, the rename process is slightly different. Open OneDrive or SharePoint in your web browser, find the file, right-click it, and select "Rename". Type the new name and press Enter. If you are working in the Excel web app or Excel desktop app with the file synced to OneDrive, you can also use File > Save As as described above, and the renamed file will sync to OneDrive automatically.
One advantage of cloud storage: if you rename a file in OneDrive or SharePoint, any links to it from other files usually update automatically, because the link is based on the file's ID rather than its name. This is different from files on your local computer, where links are based on the file path and name.
Frequently Asked Questions
Can I undo a rename if I made a mistake?
Yes. If you renamed the file in File Explorer or Finder, press Ctrl+Z (Windows) or Command+Z (Mac) when ready to undo the rename. If you used Save As in Excel and want to go back to the original file, close the newly named file without saving changes, then open the original file from your file manager.
What if I rename a file and it stops opening in Excel?
This usually means the file extension was accidentally deleted. Right-click the file, select Rename, and add the extension back — type .xlsx at the end of the name. If you are not sure what extension to use, look at other Excel files in the same folder to see what they end with.
Does renaming a file change the data inside it?
No. Renaming only changes the file's name in the file manager. All the data, formulas, and formatting inside the spreadsheet stay exactly the same. The file contents are not touched.
Can I rename a file while it is syncing to OneDrive or the cloud?
It is safer to wait until the sync is complete before renaming. If you rename a file while it is still syncing, you may end up with two copies — the old name and the new name — in your cloud storage. Check the sync status in your system tray (Windows) or menu bar (Mac) before renaming.