How To Save Microsoft Excel Sheet
To save a Microsoft Excel sheet, press Ctrl+S on Windows or Command+S on Mac. For a new file, choose a folder, enter a name and save it as an Excel Workbook (.xlsx). Saving normally keeps every worksheet in the workbook; to save just one sheet.
Which licences fit your PC setup?
Prices are an AUD snapshot, not a live quote. Confirm variant and total on the listing.
-

Office 2021 Pro Plus key
$57.00 AUD
-

Office 2019 Pro Plus key
$45.00 AUD
-

Microsoft 365 Pro Plus, 5 devices
$15.00 AUD
$29.00
Save an Excel workbook for the first time
A worksheet is an individual tab within an Excel file. The file itself is called a workbook and can contain several worksheets. The Save command saves the workbook, including changes across its tabs.
Follow these steps in Excel for Windows. Menu labels may differ on Mac or between editions.
- Choose File > Save As. If you see Save a Copy instead, use that option.
- Select a destination, such as a folder on your computer or your OneDrive account. Use Browse if you need to find a local folder.
- Enter a descriptive file name, such as Project Budget November.
- Choose Excel Workbook (.xlsx) as the file type for an ordinary workbook without macros.
- Select Save and check that Excel shows the intended file name.
Check the destination before closing Excel, especially if you use both local and cloud folders with similar names. Microsoft's workbook saving instructions explain the location and file type options.
Update your file or create a separate copy
After the first save, use Ctrl+S on Windows, Command+S on Mac or File > Save to update the existing file. This keeps the same name, location and format.
Use Save As or Save a Copy when you need a different name, folder or format. For example, make a dated copy before replacing a budget's assumptions. If AutoSave is on, create the copy before editing so your changes do not immediately update the original.
Save only one worksheet as a new file
Renaming a tab does not create a separate file. To keep one worksheet in its own workbook, use the desktop app's Move or Copy command:
- Right-click the tab of the worksheet you want to save.
- Select Move or Copy.
- In the To book list, select (new book).
- Tick Create a copy to retain the sheet in the original workbook.
- Select OK, then save the new workbook with its own name and location.
Microsoft's single-worksheet saving guide confirms that Create a copy keeps the sheet in both workbooks. Check formulas in the new file: references to other sheets may still depend on the original workbook.
Choose a format that keeps what you need
Keep an Excel-format master file before exporting data or preparing a document for sharing. Changing the extension alone does not convert a file; choose the format through Save As or the relevant export option.
| Format | When to choose it | What to watch for |
|---|---|---|
| Excel Workbook (.xlsx) | Everyday spreadsheets with formulas, formatting and multiple worksheets. | It cannot store VBA macros. |
| Excel Macro-Enabled Workbook (.xlsm) | Workbooks containing VBA macros you need to retain. | Keep this format when saving changes to those macros. |
| CSV (.csv) | Plain tabular data needed by another system. | Only the active sheet's text and values are saved, without workbook formatting or working formulas. |
| PDF (.pdf) | A fixed-layout copy to view or print. | Retain the Excel file for further spreadsheet editing. |
Read any compatibility warning before confirming an export. Microsoft's supported file formats reference explains which formats preserve workbook features. Open a PDF export to check its page breaks and columns before sending it.
Use AutoSave and AutoRecover correctly
AutoSave updates supported cloud files
In Excel for Microsoft 365, AutoSave can save changes automatically when a supported workbook is stored in OneDrive or SharePoint Online. Save the workbook there, sign in with the appropriate account and check the AutoSave switch.
A local file or a file in another cloud service does not automatically qualify for this feature. An older format or unsupported workbook feature can also prevent AutoSave from working. Microsoft's AutoSave guidance describes the requirements.
AutoRecover helps after an interruption
AutoRecover creates recovery information at intervals. It is separate from AutoSave and does not replace saving your file.
- In Excel for Windows, open File > Options > Save.
- Tick Save AutoRecover information every n minutes.
- Choose an interval and select OK.
If Excel closes unexpectedly, reopen it and check for recovered files. For a workbook you never saved, look under File > Info > Manage Workbook for Recover Unsaved Workbooks. Open any suitable recovery file, check its contents and save it immediately. Recovery depends on what Excel retained; Microsoft's file recovery instructions cover the available options.
Save from Excel for the web
Excel for the web saves workbook changes automatically. Check that saving has completed before closing the browser. To keep a local copy, choose File > Create a Copy > Download a Copy, then check your browser's downloads folder. Microsoft's download instructions describe this process.
Handle a failed save before closing Excel
If saving fails, keep the workbook open and try Save As with a new name in a local folder you can write to. Check available storage and whether the destination is read-only. For a cloud file, check your connection and sign-in status. Microsoft's save-error troubleshooting guide provides further checks.
If the message concerns your Office licence, the related guides on activating Microsoft Office using CMD and finding an Office product key using Command Prompt address those specific topics. Other Office help is available in the Microsoft Office guides.
Save your workbook now, then reopen it from its chosen folder to confirm your latest changes are present.
Other editions for separate workloads
Other editions for separate workloads; prices in AUD, confirm the total on the listing.
-

Windows 11 Pro key
$14.99 AUD
$29.00 -

Office 2024 Pro Plus key
$20.00 AUD
$39.00 -

Windows 11 Home key
$18.88 AUD
$37.00
How to check this worked
- Open Settings, System, Activation and confirm the edition shown.
- Enter the key and run activation; expect a green tick within a minute.
- Reboot and re-check activation survives the restart.
FAQ
What else should you know before buying?
- What do I need before starting?
- Read the requirements and confirm the edition first; the steps assume the machine is compatible.
- How do I know the licence is genuine?
- Activate on Microsoft's servers and check Settings, System, Activation. A working activation is the test.
- Is this a subscription?
- Keys sold here are one-time lifetime licences. Microsoft 365 plans are billed by Microsoft instead.
- What if the key fails?
- Email hi@ms.codes with the order number and a screenshot. Replacement or refund applies within 30 days.
Check who prepared and reviewed this guide
- Written by
- MS.Codes editorial
- Reviewed by
- Support team
Last verified: (source review; see test status above).