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 differ slightly — but the core action is the same.

The file keeps its .xlsx or .xls extension automatically, so you only type the name itself. If you accidentally delete the extension, Windows and Mac will ask you to confirm the change, and you can undo it.

Key Takeaways

  • Right-click a file in File Explorer or Finder, choose Rename, type the new name, and press Enter — no need to type the file extension.
  • If the file is open in Excel, save and close it first, then rename it from your file manager rather than from inside the program.
  • Renaming a file does not change its contents or break any links to it, as long as you keep it in the same folder.
  • Batch renaming tools like Windows PowerToys or Mac Automator let you rename dozens of files at once using a pattern or numbering system.

Renaming a file from File Explorer or Finder

On Windows, open File Explorer, navigate to the folder where your Excel file lives, right-click the file name, and click "Rename". The file name will highlight and become editable. Type the new name — for example, "Q4 Budget 2024" instead of "Budget_Final_v3" — and press Enter. Windows keeps the .xlsx extension, so you do not type it.

On Mac, open Finder, navigate to the folder, right-click (or Control-click) the file, and select "Rename". Type the new name and press Enter. Mac also preserves the file extension automatically. If you want to see the extension before you rename, go to Finder > Preferences > Advanced and check "Show all filename extensions".

If you change your mind while typing, press Escape to cancel the rename. If you have already pressed Enter and want to undo the change, press Ctrl+Z (Windows) or Command+Z (Mac) when ready.

Renaming a file that is open in Excel

If the file is currently open in Excel, you have two choices: rename it from inside Excel using "Save As", or close it first and rename it from your file manager.

To rename from inside Excel, go to File > Save As. Choose the folder where the file already lives, type the new name in the "File name" field, and click Save. Excel will close the old version and open the renamed file. This method is useful if you want to keep the old version as a backup — just choose a different folder or type a different name, and you will have both files.

To rename from your file manager instead, save the file (Ctrl+S or Command+S), close Excel, then right-click the file in File Explorer or Finder and rename it. This is faster if you are only changing the name and do not need to keep a copy.

What happens to links and formulas when you rename a file

If your Excel file contains formulas that link to other files — for example, a summary sheet that pulls data from a details sheet — renaming the file does not break those links, as long as you keep the file in the same folder. Excel tracks files by their location, not by their name.

However, if another file contains a link to your Excel file (for example, a Word document with a table pulled from your spreadsheet), that link may break if you rename the file. The other file is looking for the old name. You will need to update the link in the other file by going to File > Info > Edit Links to Files (or the equivalent in that program) and pointing it to the renamed file.

To avoid this problem, rename files before you create links to them, or tell anyone who has linked to your file that you are about to rename it so they can update their links.

Renaming multiple Excel files at once

If you have dozens of files to rename — for example, changing "Report_Jan", "Report_Feb", "Report_Mar" to "January Sales", "February Sales", "March Sales" — doing it one at a time is slow. Windows and Mac both have built-in batch rename tools.

On Windows 10 and later, select all the files you want to rename in File Explorer, right-click the first one, and choose "Rename". Type the new name and press Enter. Windows will rename the first file to your new name, then automatically number the rest as "Name (2)", "Name (3)", and so on. If you want more control — for example, to add a date or remove part of the old name from all files — use Windows PowerToys, a free tool from Microsoft that includes a batch rename feature.

On Mac, select the files in Finder, right-click, and choose "Rename Items". A dialog will appear with options to find and replace text, add a number sequence, or change the order of words in the file name. This is more flexible than Windows' automatic numbering and lets you see a preview of the new names before you explore them.

Naming conventions that make files easier to find later

When you rename a file, think about how you will search for it in six months. File names that start with a date (2024-Q4-Budget) sort chronologically in File Explorer and Finder. File names that start with a category (Budget-2024-Q4 or Invoices-January) group related files together. Avoid names like "Final" or "v3" because they do not tell you what the file contains or when it was made.

Use hyphens or underscores to separate words, not spaces — "Q4-Budget-2024" instead of "Q4 Budget 2024". This makes the file name easier to type if you ever need to reference it in an email or a formula. Keep names short enough to read in a single line in File Explorer (roughly 40 to 50 characters), because longer names get cut off in some views.

Fixing a file name you cannot change

If you try to rename a file and get an error message saying the file is "in use" or "locked", the file is probably open in Excel or another program. Close Excel completely and try again. If the error persists, restart your computer — sometimes a file stays locked in the system even after you close the program.

If you get an error about an invalid character, you used a symbol that Windows or Mac does not allow in file names. The forbidden characters are: / \ : * ? " < > |. Remove these from the name and try again. Hyphens, underscores, and periods are safe.

If you cannot rename a file because you do not have permission, you may not own the file or it may be stored on a shared network drive. Right-click the file, select Properties (Windows) or Get Info (Mac), and check the permissions section. If you need to change permissions, ask the person who manages the shared drive.

Frequently Asked Questions

Can I rename a file while it is open in Excel?

Not from your file manager — the file will be locked. You can use File > Save As inside Excel to rename it, which closes the old version and opens the new one. Or close Excel first, then rename the file from File Explorer or Finder.

What if I rename a file and now a formula in another file cannot find it?

The other file has a link to the old file name. Open that file, go to File > Edit Links to Files, select the broken link, and click "Change Source" to point it to the renamed file. If you do not see an Edit Links option, the file may not have external links.

Do I need to type the .xlsx extension when I rename a file?

No. Windows and Mac add the extension automatically. If you type it yourself, you may end up with a name like "Budget.xlsx.xlsx". If this happens, rename the file again and leave off the extension.

Can I rename a file to something with spaces in it?

Yes, spaces are allowed. "Q4 Budget 2024" works fine. However, hyphens or underscores ("Q4-Budget-2024") are easier to type and sort more predictably in some systems.

What is the fastest way to rename 50 files at once?

On Windows, select all the files, right-click the first one, and choose Rename to add automatic numbering. For more control, read Windows PowerToys and use the batch rename feature. On Mac, select the files, right-click, choose Rename Items, and use the find-and-replace or numbering options.