To save an Excel workbook under a different name or in another location, open it and choose File > Save As, select a folder, enter a file name, choose a format if needed, and click Save. In Excel for Microsoft 365 on Windows, press F12 to open the Save As dialog directly. Save As creates a separate file, so you can keep the original unchanged while working on the copy.
Before you start, decide whether you want a second editable workbook, a file in a different format, or a copy downloaded to your computer. Those choices affect which location and file type you should select. The steps below are for the Windows desktop version of Excel for Microsoft 365; notes explain the differences in Excel for Mac and Excel for the web.
What You’ll Need
- An open Excel workbook. If it has never been saved, Save As is also the first step for naming and saving it.
- A destination folder you can access, such as a local folder, a network folder, or OneDrive. For a cloud location, sign in to the relevant account.
- A suitable file format. Use the default Excel Workbook format (.xlsx) for most ordinary spreadsheets. Choose a different type only when you have a reason, such as sharing a CSV data file or keeping macros.
Step-by-Step
- Open the workbook you want to save. Check that it is the correct workbook before creating a copy. If you are starting with a blank workbook, add any content you want to keep, or proceed to save the blank file as a template for later work. If the workbook is stored in OneDrive or SharePoint, check the file name and location shown in Excel so you know which original you are copying.
- Open Save As. In Excel for Microsoft 365 on Windows, select File > Save As. You can also press F12; on some laptops you may need to hold Fn while pressing F12. If the workbook is already saved to a cloud service, Excel may show a Save a Copy option instead of presenting the traditional Save As flow. Choose that option to make a separate workbook without replacing the cloud original.
- Choose where the new file should go. For a folder on your computer or a mapped network drive, select Browse to open the Windows Save As dialog. Navigate through the folders to the destination. For OneDrive or SharePoint, choose the relevant cloud location and folder if it is offered in Excel. Avoid choosing a temporary folder if you will need to find or share the workbook later.
- Enter a clear file name. Click the File name box and type a name that distinguishes the new workbook from the original, such as ProjectPlan_Review.xlsx or SalesData_2026.xlsx. Excel usually adds the extension based on the selected file type, so you generally do not need to type .xlsx yourself. Use a descriptive name and, when useful, a date or version label. Windows does not allow certain characters in file names, including a forward slash, backslash, colon, asterisk, question mark, quotation mark, less-than sign, greater-than sign, or vertical bar.
- Check the file type. The Save as type list in the Windows dialog normally defaults to Excel Workbook (*.xlsx). Keep that choice for a typical workbook with formulas, formatting, charts, and multiple sheets. If the workbook contains VBA macros, choose Excel Macro-Enabled Workbook (*.xlsm) instead; .xlsx does not retain VBA code. For a plain-text data exchange, choose CSV only if you understand its limitations: CSV saves data from the active worksheet, not the whole workbook with its formatting and other sheets.
- Save the copy. Click Save. If Excel warns that the selected format does not support a feature, pause and read the message before continuing. Choose the option to keep the current Excel format if you need to preserve workbook features, or confirm the format change only when that is what you intend. If a confirmation asks whether to replace an existing file, check the folder and name before choosing to replace it.
- Verify the new workbook. Look at the title bar or use File > Info to confirm the name and location. If you chose a cloud folder, check that the workbook is signed in and syncing. To verify that the new file is separate, use File > Open or File Explorer to locate it, then open it and confirm the expected sheets and content are present.
- Continue working in the right file. After Save As, Excel normally leaves the new copy open. Edits and later presses of Ctrl+S will update that copy, not the original. If you meant to keep editing the original, reopen it from its original location. This distinction is especially important when comparing versions or sending a working copy to someone else.
On Mac: In Excel for Mac, use File > Save As or press Command+Shift+S. Choose the destination in the save dialog, enter a name, and check the file format option if you need a format other than an Excel workbook. The wording and layout of the dialog can differ from Windows, but the key checks are the same: destination, name, and format. The Mac equivalent of Windows Ctrl+S for saving later is Command+S.
In Excel for the web: Workbooks stored in OneDrive or SharePoint are generally saved automatically. To make another cloud copy, use File > Save As > Save a Copy if that option appears, then choose a name and location. To create a local file on your computer, use File > Save As > Download a Copy when available. The downloaded file is separate from the cloud workbook, so later edits to one do not automatically update the other.
Common Mistakes
- Choosing .xlsx for a workbook with macros. The standard .xlsx format cannot store VBA macros. Save a macro-enabled workbook as .xlsm and check any format warning instead of dismissing it automatically.
- Assuming Save As replaces the original. Save As is meant to create a new file when you give it a different name or location. Excel usually switches to the new copy afterward, which can make it seem as though you are still editing the original.
- Changing the extension by typing it into the name box. Selecting a file type is safer than manually changing .xlsx to .csv or .xlsm. The extension should match the actual format selected in the dialog.
- Saving a full workbook as CSV. CSV is a text format, not a complete Excel workbook. It does not preserve formulas as formulas, formatting, charts, or extra worksheets in the same way an .xlsx file does. Keep an Excel-format copy if you need those features.
- Overwriting a file without checking. If Excel asks to replace an existing file, verify that it is the intended file. A similar name or a folder with several versions can make accidental replacement easy.
- Forgetting the destination. A correct file name is not enough if the workbook is saved in an unexpected folder. Confirm the location before saving, especially when switching between local storage and OneDrive.
Tips
- Use names that explain the file’s purpose. A label such as Budget_Approved or Inventory_Import is more useful than NewWorkbook or Final2. Add a date only when it helps identify the version, and use a consistent date style so files sort predictably.
- Keep a working copy and a source copy. When experimenting with formulas, formatting, or imports, save a copy first. You can then return to the source if a change causes problems, without relying on undo history.
- Use the right format for the recipient. Send .xlsx when the recipient needs to edit an Excel workbook. Use PDF when the goal is to share a fixed-looking report, and use CSV when another system specifically requests tabular text data. If saving as another format, retain an .xlsx version when you may need to revise the workbook.
- Use cloud storage deliberately. OneDrive and SharePoint make it easier to access and share a workbook across devices, but make sure you are signed in to the correct account and folder. For a file that must be available without an internet connection, verify that it is downloaded or saved locally.
- Check after the save, not just before it. Reopen the copy or inspect its title and location. This catches errors such as saving to the wrong folder, using the wrong file type, or continuing to edit the source instead of the new version.
Troubleshooting
Save As is missing or Excel shows Save a Copy: This can happen with a workbook in OneDrive or SharePoint. Choose Save a Copy to create a separate file, then select its location and name. If you only need to change the current file’s name or folder, use the cloud service’s rename or move options, or save a copy and then decide whether to remove the old file.
The Save button is unavailable, or saving fails: Check that you have permission to write to the destination and that the folder exists. If the workbook is on a network or cloud drive, confirm your connection and sign-in status. Try saving to a folder on your computer that you can access. If that works, the issue is likely the original destination, its permissions, or synchronization rather than the workbook itself.
Excel says the file name is invalid: Remove characters Windows does not permit in file names, such as a colon or a question mark, and try again. Also check that the name is not blank and that the destination path is available. If a file with the same name already exists, choose a distinct name or carefully confirm whether replacing it is intended.
Formatting, sheets, or macros disappear: The file may have been saved in a format that cannot preserve them. Reopen the original Excel workbook if it is still available, then save a new copy as .xlsx for standard workbook features or .xlsm when VBA macros must remain. CSV is suitable for simple data exchange, not for storing a complete formatted workbook.
The copy does not appear in the folder: Check the location displayed in Excel and search File Explorer for the exact file name. In OneDrive, wait for synchronization and check for a sync warning or sign-in prompt. In Excel for the web, a downloaded copy may be in your browser’s Downloads folder rather than the cloud workbook’s folder.
The wrong file is open after saving: Save As usually leaves the new copy open. Check the title bar, then use File > Open to reopen the original if that is the one you intended to edit. Before making more changes, confirm the name and storage location so you do not update the wrong version.
Frequently Asked Questions
What is the keyboard shortcut for Save As in Excel?
In Excel for Microsoft 365 on Windows, press F12. On some laptops, you may need Fn+F12. In Excel for Mac, use Command+Shift+S. The usual save shortcut is Ctrl+S on Windows and Command+S on Mac, but that saves changes to the current file rather than opening Save As.
Does Save As change the original Excel file?
Not when you save under a different name or in a different folder. Excel creates a separate file and normally switches to it. If you choose the original file’s exact name and location and confirm replacement, the original can be overwritten.
How do I save an Excel file as a PDF?
Open File > Save As, choose the destination, and select PDF in the file type list, then save. Depending on the Excel version, File > Export may also provide a PDF option. Check the print layout and selected sheets first, because the PDF reflects the pages being exported rather than preserving an editable workbook.
Can I save only one worksheet as a separate Excel file?
Yes. In the desktop app, right-click the worksheet tab, choose Move or Copy, select (new book) in the To book list, and select Create a copy if you want to keep the worksheet in the original too. Then save the new workbook with File > Save As. Check formulas that refer to other sheets, since those references may behave differently in the separate file.
Why does Excel warn that some features will be lost?
The selected file type cannot store every feature in the workbook. For example, CSV does not retain full workbook formatting or additional sheets, and .xlsx does not keep VBA macros. If you need the features, cancel the format change and save in an Excel format that supports them, such as .xlsm for a macro-enabled workbook.
Where does Excel for the web save a copy?
A copy made with File > Save As > Save a Copy is saved in the cloud location you choose, usually OneDrive or SharePoint. A file made with Download a Copy is downloaded to your computer, commonly to the browser’s Downloads folder. Check the browser’s download list if you cannot find it.
Related
- Open Power Query in Excel for the Web: Step-by-Step
- How to Open a SharePoint Excel File in the Desktop App
- Open Excel Online in the Desktop App
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Add Slide Numbers in PowerPoint: A Step-by-Step GuideTo add slide numbers in PowerPoint for Microsoft 365 on Windows, go to Insert > Header & Footer,…
- Microsoft Word: How to Add FootnotesTo add a footnote in Microsoft Word, place the cursor where its reference number should appear, then choose…
- Add Color to Excel Data Validation ListsTo add color to an Excel data-validation list, create the drop-down first, then use conditional formatting to color…
- Make a Brochure in Microsoft Word Online and DesktopYes. You can make a brochure online in Word for the web by starting with a brochure template…
- How to Change the Microsoft Outlook View and LayoutTo change the Microsoft Outlook view, open the View tab and select a layout or view option. In…
- Excel Dropdown List: How to Create and Use OneTo create and use a dropdown list in Excel for Microsoft 365 on Windows, select the cells, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.