Tutorial2026-11-088 min read

How to Rename an Excel File (and How to Rename a Sheet Tab)

To rename an Excel file, close the workbook, then rename it in File Explorer (select it and press F2) or Finder (select it and press Return), keeping the .xlsx extension. If the workbook is saved to OneDrive or SharePoint and you use Excel for Microsoft 365, you can rename it while it is open: click the file name in the title bar, edit the File Name box and press Enter.

If you actually want to rename one of the sheets inside the workbook (the tabs along the bottom, such as "Sheet1"), double-click the tab and type a new name. Both are covered below.

File Name or Sheet Name: Which One Do You Need?

"Renaming a file in Excel" can mean two different things:

  • The workbook file name: what you see in File Explorer, Finder and email attachments, such as Book1.xlsx or Q3 budget.xlsx. Renaming it changes the file on disk.
  • A worksheet name: the label on a tab at the bottom of the Excel window, such as Sheet1. Renaming it changes nothing outside the workbook, and formulas that refer to the sheet update automatically.

If a tab is what you need, skip down to the "Rename a Sheet Tab" section.

Rename an Excel Workbook in File Explorer (Windows)

This works for every version of Excel and for .xlsx, .xlsm, .xls and .csv files.

  1. Save your work and close the workbook in Excel.
  2. Open File Explorer (Windows key + E) and find the file.
  3. Select it and press F2, or right-click and choose Rename.
  4. Type the new name and press Enter.

Keep the extension unchanged. Changing .xlsx to .xls or .csv by renaming does not convert the file; Excel will warn that the format and extension don't match. Use File > Save As and pick a different file type to convert. The file extension guide explains the difference.

Rename an Excel Workbook in Finder (Mac)

  1. Close the workbook in Excel.
  2. Select the file in Finder and press Return, or Control-click it and choose Rename.
  3. Type the new name and press Return.

Rename a Workbook from Inside Excel (Microsoft 365)

In Excel for Microsoft 365 on Windows and Mac:

  1. Click the workbook name in the title bar at the top of the window.
  2. In the panel that opens, click the File Name box, type the new name and press Enter.

The workbook stays open and keeps its version history. Microsoft describes this for files saved to OneDrive or SharePoint. For a workbook saved only on your computer the box may be greyed out, depending on your version; in that case close the workbook and rename it in File Explorer or Finder, or use Save As.

Rename a Workbook in Excel for the Web

  1. Open the workbook in Excel for the web (from OneDrive, SharePoint or office.com).
  2. Click the file name near the top of the browser window.
  3. Type the new name and press Enter.

If you can't edit the name, make sure you are in editing mode rather than viewing mode. You also can't rename it while someone else is editing the workbook. In OneDrive itself, you can select the file and choose Rename without opening it.

Save As: A Renamed Copy, Not a Rename

File > Save As (or File > Save a Copy when AutoSave is on for a OneDrive file) saves the workbook under a new name and leaves the original file in place. You end up with two workbooks. If you only wanted a new name, delete the old one afterwards, and double-check which one you are deleting: after Save As, the copy with the new name is the one open in Excel.

Rename an Excel File on iPhone, iPad or Android

  • iPhone and iPad (Excel app): in the file list, tap More (three dots) next to the workbook, tap Rename, type the new name and tap Rename.
  • Android (Excel app): open the workbook and tap its name at the top of the screen, type the new name and tap Done.
  • Files app on iPhone: touch and hold the .xlsx file and tap Rename.

Rename a Sheet Tab

To rename a worksheet (Microsoft lists three ways in Excel for Windows):

  1. Double-click the sheet tab, type the new name and press Enter.
  2. Right-click the sheet tab, choose Rename, type the new name and press Enter.
  3. Keyboard: press Alt, then H, O, R (one after another, not together), type the new name and press Enter. This uses the Home tab's Format menu, Rename Sheet.

In Excel for Mac and Excel for the web, double-clicking the tab or right-clicking (Control-clicking on a Mac) and choosing Rename works the same way.

Sheet name rules:

  • At most 31 characters.
  • Not blank.
  • None of these characters: / \ ? * : [ ]
  • Cannot start or end with an apostrophe.
  • Cannot be History, which Excel reserves.

Formulas in the same workbook that refer to the sheet, such as ='Sheet1'!B4, are updated automatically when you rename it. Formulas in other workbooks that link to it update if those workbooks are open at the time; otherwise you may need to fix the link.

Problems Renaming an Excel File

"The file is open in Microsoft Excel"

Windows won't rename a workbook that Excel has open. Close it, and if the error persists, check for another Excel window or a leftover Excel process in Task Manager (Ctrl+Shift+Esc). Files in OneDrive or Dropbox folders can also be locked briefly while syncing.

While a workbook is open, Excel creates a small hidden owner file beginning with ~$ in the same folder. It disappears when you close the workbook. If Excel crashes and leaves one behind, you can delete it once Excel is closed; don't rename it.

AutoRecover versions

If Excel crashed and you rescued a file from the Document Recovery pane, save it under a proper name straight away with File > Save As. Recovered workbooks can carry names like "(Autosaved)" or "(version 1)", and these are easy to lose track of. Once saved properly, delete or ignore the leftovers.

Links from other workbooks break

If other workbooks pull data from this one (external references like ='[Budget 2026.xlsx]Sheet1'!A1), renaming the file in File Explorer breaks those links. Open the dependent workbook and use Data > Edit Links (called Workbook Links in newer versions of Excel for Microsoft 365) to point it at the new file name. Pivot tables, Power Query queries and Power BI reports that use the file path need the same treatment.

Rename Many Files Using an Excel List

A common job is the reverse of everything above: you have a spreadsheet with old names in column A and new names in column B, and you want the files renamed to match.

The quickest no-install method on Windows is to let Excel write the commands. With headers in row 1, put this formula in C2 and fill it down:

="ren """&A2&""" """&B2&""""

Each row now contains a command such as ren "IMG_0412.jpg" "lisbon-tram.jpg". Copy column C into a text file saved with a .bat extension in the same folder as the files, and run it. The batch file guide explains how to create and run the .bat safely, including a dry run first, and bulk renaming files from a list covers PowerShell and Mac methods that read a CSV directly.

Check two things before you run it: every name in column A must include its extension, and no two rows in column B can have the same new name.

Naming Excel Files Well

  • Put the subject first and a sortable date: 2026-11_sales-report.xlsx.
  • Use v01, v02 for drafts rather than "final" and "final (2)".
  • Avoid square brackets in workbook names. Excel uses them in external references, and they cause problems in some import tools.

When you are dealing with a folder of exported spreadsheets called export (14).xlsx, renaming by pattern doesn't help. File Renamer AI reads each uploaded spreadsheet (and PDFs, Word files and images) and suggests a descriptive name based on its contents, which you can review before downloading the renamed files as a ZIP. If you only need prefixes, numbering or find and replace, you can rename files online for free, in your browser.

Frequently Asked Questions

How do I change the file name of an Excel workbook?

Close the workbook, then select it in File Explorer and press F2 (Windows) or select it in Finder and press Return (Mac), and type the new name. In Excel for Microsoft 365 with the file on OneDrive or SharePoint, you can click the name in the title bar and edit it without closing.

How do I rename a sheet in Excel?

Double-click the sheet tab at the bottom of the window, type the new name and press Enter. You can also right-click the tab and choose Rename, or press Alt, H, O, R in sequence on Windows.

Why can't I rename my Excel file?

The workbook is open in Excel, or an Excel process is still running in the background. Close it, check Task Manager, wait for any cloud sync to finish, and try again.

Can I rename an Excel file while it is open?

Only if it is stored on OneDrive or SharePoint, by clicking the file name in Excel's title bar or the top of Excel for the web. A workbook saved only on your computer generally needs to be closed first, or you can create a renamed copy with Save As.

What is the maximum length of an Excel sheet name?

31 characters. Sheet names also cannot contain / \ ? * : [ or ], cannot be blank, and cannot start or end with an apostrophe.

Does renaming an Excel file break formulas?

Formulas inside the workbook are not affected. Formulas in other workbooks that link to it will break if they are closed when you rename it; fix them with Data > Edit Links or Workbook Links.

Ready to organize your files?

Try AI renaming right away. No sign-up needed until you download.

Try It Free