Rename a file in Excel using File > Save As

The most straightforward way to change a file name in Excel is through the Save As command. Open the file you want to rename, then click the File menu in the top left corner. Select Save As from the dropdown menu.

A dialog box will open showing your current file name in a text field. Clear the existing name and type the new name you want. Do not include the file extension (like .xlsx) — Excel adds that automatically. Once you have entered the new name, click the Save button. Excel will save the file with the new name and close the old version.

This method works in Excel 2016, Excel 2019, Excel for Microsoft 365, and Excel Online. The steps are identical across all versions.

Key Takeaways

  • Use File > Save As to rename a file directly within Excel without opening your file manager.
  • Type only the file name in the text field — do not include .xlsx or other extensions, as Excel adds them automatically.
  • You can change the folder location at the same time you rename the file by selecting a different folder in the Save As dialog.
  • The original file is replaced with the renamed version; Excel does not keep both copies unless you save it to a different folder.
  • If you want to keep the original file and create a copy with a new name, choose a different folder location before clicking Save.

Rename a file in Windows File Explorer or Mac Finder

You can also rename an Excel file without opening it by using your computer's file manager. In Windows, right-click the Excel file and select Rename from the context menu. The file name will become editable — type the new name and press Enter. On a Mac, click the file once to select it, press the spacebar to open Quick Look, then press Enter to edit the name directly. Alternatively, right-click and select Rename.

This method is faster if you only need to change the file name and do not need to open the spreadsheet. It also works for renaming multiple files at once — select several files, right-click, and rename them one by one.

Change the file name before saving a new Excel file

When you create a new spreadsheet and save it for the first time, Excel opens the Save As dialog automatically. The file name field will be empty or contain a default name like "Book1". Type your desired file name in this field and click Save. This approach lets you set the correct name from the start rather than renaming later.

If you want to save the file to a specific folder, use the folder navigation panel on the left side of the Save As dialog to browse to that location before typing the name. This is also where you can change the file format — the dropdown menu at the bottom shows options like .xlsx, .xls, .csv, and others.

What happens to formulas and links when you rename a file

Renaming an Excel file does not break formulas or links within the spreadsheet itself. Formulas that reference cells within the same file continue to work exactly as before. However, if you have another file that contains a formula linking to the renamed file, that link may break or require updating.

If you have external links pointing to the file you are renaming, open the file that contains those links and update the link references manually. In Excel, go to Data > Edit Links (or Queries & Connections in newer versions) to see and update any broken links. This step is only necessary if other files reference the one you renamed.

Avoid common mistakes when renaming Excel files

Do not include special characters like / \ : * ? " < > | in your file name, as Windows and Mac do not allow these in file names. Stick to letters, numbers, hyphens, and underscores. Also avoid leaving the file name blank or using only spaces — Excel will reject these and ask you to enter a valid name.

If you are renaming a file that is currently open in another program or shared on a network, close it first or make sure no one else has it open. Attempting to rename a file in use can cause errors or prevent the rename from completing. After renaming, verify that the file opens correctly and that all your data is intact.

Rename multiple Excel files at once

If you need to rename several Excel files with similar names, use your file manager rather than opening each one in Excel. In Windows File Explorer, select multiple files by holding Ctrl and clicking each one. Right-click and select Rename — Windows will rename the first file and add a number in parentheses to each subsequent file (for example, "Report (1)", "Report (2)"). You can then manually adjust each name if needed.

On a Mac, select multiple files in Finder, right-click, and choose Rename. A dialog box will appear with options to find and replace text in the selected file names. This is useful if you want to change part of the name across many files — for instance, replacing "2023" with "2024" in all file names at once.

Frequently Asked Questions

Can I undo a file rename in Excel?

No, the rename operation cannot be undone through Excel's undo function. However, if you renamed the file through File > Save As, the original file still exists with its old name in the same folder (unless you deleted it). Check your folder to see if the original is still there. If you renamed through your file manager, you can right-click the file and rename it back to the original name.

What file formats can I use when renaming an Excel file?

Excel supports many formats: .xlsx (the standard modern format), .xls (older Excel versions), .csv (comma-separated values for data only), .pdf, and others. When you use Save As, a dropdown menu shows all available formats. Changing the format can affect how the file looks and what features are preserved, so only change it if you have a specific reason to do so.

Will renaming an Excel file affect shared links or permissions?

If the file is shared through OneDrive, SharePoint, or Google Drive, renaming it through those platforms updates the link automatically for all users. If you renamed the file locally on your computer, you will need to re-share the new file name with others. Permissions and sharing settings do not transfer to the renamed file unless you explicitly share it again.

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

Yes, you can rename a file while it is open by using File > Save As. This is actually the safest method because Excel handles the rename operation and ensures no data is lost. Do not rename the file through your file manager while it is open in Excel, as this can cause errors or data loss.

What should I do if Excel says the file name is invalid?

Excel rejects file names that contain special characters (/ \ : * ? " < > |), are too long (over 255 characters), or are blank. Remove any special characters and keep the name under 255 characters. If you are copying a file name from another source, check for hidden characters or extra spaces at the beginning or end of the name.