In Excel for Microsoft 365 on Windows, press F12 to open the Save As window, then choose where to save the workbook, enter a file name, and select Save. Use Ctrl+S to save changes to the current file; Save As is the choice when you need a separately named copy or a different file format.
The Excel Save As shortcut and what it does
F12 is the direct Save As shortcut in desktop Excel for Windows. It opens the Save As interface, where you can set a new name, folder, or file type. If the workbook has not been saved before, Excel also needs a name and location for its first save. After that initial save, F12 is useful for creating another version without replacing the original.
On some laptops, the function keys share duties with brightness, volume, or other hardware controls. If pressing F12 changes a device setting instead of opening Excel’s Save As window, try Fn+F12. The Fn key behavior depends on the computer’s keyboard settings; some models have a function-lock option that changes whether the F keys work directly.
Save As does not itself make a backup of every later edit. It creates or saves a workbook under a chosen name and location. Once the new copy is open, further Ctrl+S commands update that copy. Keep the original too if you need to compare versions or return to its earlier contents.
How to save a workbook under a new name
Use this sequence when you want to preserve the current workbook and start a separately named version:
- Open the workbook and press F12.
- In the Save As window, select a folder or cloud location. If necessary, browse to the folder where you want the copy.
- Enter a descriptive name in the File name box. You can usually omit the extension; Excel adds it based on the selected file type.
- Check the file type if you need a format other than the current one, such as Excel Workbook (*.xlsx).
- Select Save. If Excel warns that a file with the same name already exists, confirm only if replacing that file is what you intend.
A name such as Quarterly forecast – revised makes the new version easier to identify than a generic name like Copy. Avoid changing the extension by typing it manually unless you also select the matching file type. The extension and the workbook’s actual format should agree.
Save, Save As, and Save a Copy are different
Save updates the file you are currently working in. In Windows Excel, Ctrl+S is the standard shortcut. If you have made edits to a workbook called Inventory.xlsx, Ctrl+S writes those edits to that workbook, subject to its location and permissions.
Save As lets you choose a different name, folder, or format. When you save to a new name, the new workbook becomes the file you are editing. This is handy for preparing a monthly report from a reusable template: open the template, use F12, and save the working version as November report.xlsx, leaving the template unchanged.
In Microsoft 365, cloud-stored workbooks can show a Save a Copy option or wording that differs from the traditional Save As dialog. This is meant to create another file while the original remains available. It is especially relevant when a workbook is stored in OneDrive or SharePoint. Read the destination and file name shown before confirming, because saving a copy and renaming the current file are not the same operation.
Choosing a folder and cloud location
Save As can place a workbook in a local folder, an external drive, or a connected cloud location. The Save As view may show recent folders and storage accounts, while browsing lets you navigate to other locations. Choose a place you can find again and that is appropriate for the workbook’s sensitivity. A shared OneDrive or SharePoint folder may make a file available to colleagues; a local folder generally does not share it automatically.
If Excel is signed in to a Microsoft 365 account, cloud locations can support access from other devices and collaboration. That does not mean every workbook is automatically shared with everyone: access depends on the account, folder permissions, and sharing settings. Conversely, a workbook saved only to the computer may not be available to another device unless it is copied or synchronized.
For a file you need to send to someone, check the final destination and format before attaching it. If the workbook contains private or confidential information, consider whether the recipient should receive the entire workbook or a safer, limited version. Save As makes a separate file, but it does not automatically remove hidden sheets, comments, metadata, or data that is not visible in the current worksheet.
Picking the right Excel file format
Save As includes a file-type choice because Excel workbooks can be stored in formats with different capabilities. For ordinary Excel work, Excel Workbook (*.xlsx) is the usual choice. It preserves standard worksheet data, formulas, and formatting, but it does not preserve VBA macros.
- .xlsx: The standard macro-free Excel workbook format. Choose it for typical spreadsheets that do not need VBA code.
- .xlsm: The Excel Macro-Enabled Workbook format. Use it when the file contains VBA macros that must remain in the workbook.
- .xls: An older Excel format for compatibility with older software. It has older worksheet and feature limits, so use it only when a recipient or system requires it.
- .csv: A plain-text, comma-separated format for tabular data exchange. It saves data from the active worksheet, not a full multi-sheet workbook, and does not retain Excel formatting, formulas as formulas, charts, or workbook features.
- .pdf: A fixed-layout document format useful for sharing or printing a view of a workbook. It is not a practical replacement for an editable Excel workbook.
Excel may display a warning when a chosen format cannot preserve features in the workbook. For example, saving a macro-enabled workbook as .xlsx removes its VBA macros from the saved file. Saving a multi-sheet workbook as CSV does not package all sheets into one CSV file. If you need to keep the original features, retain an .xlsx or .xlsm copy as appropriate, then create an additional export in the other format.
Shortcuts on Mac and Excel for the web
On Excel for Mac, the common Save As shortcut is Command+Shift+S. You can also use File > Save As. The function keys on Mac keyboards can have system functions, so F12 may require an Fn or Globe-key combination depending on the Mac’s keyboard settings and configuration. If the shortcut does not open the dialog, use the File menu rather than assuming the Windows F12 behavior applies.
Excel for the web runs in a browser and does not provide the same desktop F12 Save As dialog. For a separate file, use File > Save As and select the available copy or download option. The exact choices can depend on where the workbook is stored and the organization’s settings. The web version saves changes to its cloud workbook automatically, so use Save As when you want a separate copy, not as a routine substitute for saving every edit.
Do not confuse Excel’s F12 command with the browser’s F12 developer tools. In desktop Excel for Windows, F12 is interpreted by Excel when the workbook window has focus; in a web browser, F12 commonly belongs to the browser. For the web app, use its File menu.
Common problems and how to avoid them
- F12 does nothing useful: Try Fn+F12 on a laptop, check that Excel is the active app, or choose File > Save As. Function-key settings can differ by device.
- The workbook seems to overwrite the original: Check the folder and name in the Save As view before saving. A new name creates a separate file; choosing the old name in the same folder can replace that file after a confirmation.
- A macro disappears: The workbook may have been saved as .xlsx. Use .xlsm to retain VBA macros, and read Excel’s compatibility warning before proceeding.
- Only one worksheet appears in the exported file: That is expected for CSV. CSV is a text export of the active sheet, not a container for an entire multi-sheet workbook.
- You cannot save to a folder: The folder may be read-only, disconnected, unavailable, or restricted by an organization’s permissions. Try a permitted location and then move or share the file according to your organization’s rules.
When a file is important, verify the result rather than relying only on the dialog closing. Check the workbook name in Excel’s title area or reopen the destination folder and confirm that the new file exists. For a format conversion, open the saved copy and make sure the data and features you need remain available.
Frequently Asked Questions
What is the Save As shortcut in Excel for Windows?
Press F12 in desktop Excel for Windows. On some laptops, use Fn+F12 if the function key is assigned to a hardware control.
Does Ctrl+S save as a new file?
No. Ctrl+S saves changes to the workbook you are currently editing. Use F12 to choose a new name, location, or format and create a separate version.
What is the Save As shortcut in Excel for Mac?
The usual shortcut is Command+Shift+S. You can also choose File > Save As. Function-key behavior can vary with Mac keyboard settings.
How do I save an Excel workbook as a PDF?
Open Save As with F12 on Windows, choose PDF as the file type, and save. Review the selected print area and page layout first, because those settings affect what appears in the PDF.
Why does Excel warn me when I save as CSV?
CSV preserves plain tabular text rather than the full workbook. It does not retain multiple sheets, formatting, charts, or Excel formulas as editable formulas, so Excel warns that workbook features may be lost.
Related
- Excel Keyboard Locked? How to Unlock It
- Excel Save As Keyboard Shortcut: F12 and Mac Options
- Excel Invoice Template: Find Free Microsoft Options
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Debt Snowball Spreadsheet: Build a Payoff Tracker in ExcelBuild a debt snowball spreadsheet in Excel by listing each debt from smallest to largest balance, setting a…
- New Home Budget Spreadsheet: How to Build OneA new-home budget spreadsheet should separate one-time buying and moving costs from recurring monthly expenses, then compare planned…
- Excel Timesheet: How to Add Up Hours CorrectlyTo add up timesheet hours in Excel, put each shift’s worked duration in a cell and total the…
- Group Rows in Excel by the Same NameTo group rows that share a name, first sort the entire data range by the Name column so…
- Excel Cell Bullet Points: Add and Format Lists in CellsYes. In Excel for Microsoft 365 on Windows, edit a cell and press Alt+0149 on the numeric keypad…
- Freeze Panes in OpenOffice Calc: Steps and TipsTo freeze panes in OpenOffice Calc, select the cell just below the rows and just to the right…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.