The basic save: Ctrl+S or the File menu

To save a file in Excel, press Ctrl+S on Windows or Command+S on Mac. That is the fastest way. If you prefer the menu, click File in the top left, then click Save.

The first time you save, a dialog box opens asking where you want to put the file and what to name it. Type a name that describes what is in the spreadsheet — "2024 Budget" or "Client List January" works better than "Spreadsheet1". Choose a folder you will remember, like your Documents folder or a project folder you already use.

After that first save, pressing Ctrl+S updates the same file without asking questions. Excel saves over the old version with your new changes. If you want to keep both the old and new versions, use Save As instead (File > Save As), which lets you give it a different name or put it in a different folder.

Key Takeaways

  • Press Ctrl+S (or Command+S on Mac) to save your work, or use File > Save from the menu.
  • The first time you save, give your file a descriptive name and choose a folder you will remember.
  • Use Save As (File > Save As) when you want to keep the old version and create a new file with a different name.
  • Excel saves in .xlsx format by default, which works on Windows, Mac, and most other programs that read spreadsheets.
  • Turn on AutoSave in OneDrive or SharePoint if you want Excel to save automatically without you pressing Ctrl+S.

Choosing where to save: Local folder or cloud storage

When you save for the first time, you choose a location. Your two main options are a folder on your computer (like Documents or Desktop) or a cloud service like OneDrive, Google Drive, or Dropbox.

Saving to a local folder means the file lives only on your computer. It is fast and does not need internet, but if your computer breaks or gets stolen, the file is gone unless you backed it up separately. Saving to OneDrive or another cloud service means the file is stored on a company's servers and synced to your computer. You can access it from any device with internet, and it is automatically backed up.

If you work with other people on the same spreadsheet, cloud storage is usually better because everyone can see changes in real time. If the file is just for you and you do not need it on your phone or other devices, a local folder is fine.

File format: .xlsx, .xls, and other options

Excel saves files as .xlsx by default. This is the modern format and works on Windows, Mac, and most other programs. You do not need to think about this unless you are sharing the file with someone using very old software.

If someone asks for a different format, go to File > Save As. A dropdown menu labeled "Save as type" shows other options. .xls is an older Excel format that some older programs still use. .csv (comma-separated values) is a plain-text format that removes all formatting and formulas but works in almost any program. .pdf turns your spreadsheet into a document people can view but not edit.

Unless you have a specific reason to use a different format, stick with .xlsx. It preserves all your formulas, formatting, and features.

AutoSave: Let Excel save automatically

If your file is stored in OneDrive or SharePoint (Microsoft's cloud services), you can turn on AutoSave. This saves your work automatically every few seconds without you pressing Ctrl+S. Look for the AutoSave toggle in the top left of the window, just above the spreadsheet. Click it to turn it on.

AutoSave is useful if you work for long stretches and forget to save, or if you are worried about losing work if your computer crashes. The downside is that every small change is saved, so if you make a mistake and want to undo it, you may not be able to go back very far. You can still use Ctrl+Z to undo recent changes even with AutoSave on.

AutoSave only works with OneDrive or SharePoint. If your file is on your local computer or another cloud service like Dropbox or Google Drive, AutoSave is not available.

Saving a copy or backup

If you want to keep the current version of a file and also create a new one, use Save As. Go to File > Save As, give it a new name (like "Budget v2" or "Budget Final"), and click Save. Now you have two separate files — the original and the new one. Changes you make from now on only affect the new file.

This is useful when you are making big changes and want to be able to go back to the original if something goes wrong. It is also how you create versions for different purposes — for example, saving "Budget Draft" and "Budget Submitted" as separate files.

If you just want a backup without creating a new working file, you can also right-click the file in File Explorer (Windows) or Finder (Mac) and choose Copy, then paste it in the same folder. This creates a duplicate with a name like "Budget - Copy.xlsx".

Fixing common save problems

If you see a message saying the file is read-only, it means you can view it but not change it. This usually happens when the file is on a shared drive and someone else has it open, or when the file permissions are set to read-only. Try closing the file and opening it again, or ask whoever shared it with you to give you edit permission.

If you get an error message when saving, the most common causes are a full hard drive, a broken internet connection (if saving to cloud storage), or the file is too large. Check that you have space on your computer and that your internet is working. If the file is very large (over 100 MB), it may take a long time to save or fail on slower connections.

If Excel crashes before you save, you may be able to recover your work. When you reopen Excel, it usually shows a recovery pane on the left side with unsaved versions. Click the version you want to keep, then save it with Ctrl+S.

Sharing a file without letting others edit it

If you want to share a spreadsheet but do not want people to change it, save it as a PDF instead of an Excel file. Go to File > Save As, choose PDF from the "Save as type" dropdown, and click Save. A PDF looks exactly like your spreadsheet but people can only view it, not edit it.

If you want to keep it as an Excel file but prevent editing, you can also go to File > Info > Protect Workbook and choose "Encrypt with Password". This requires anyone who opens it to type a password. You can set one password for opening the file and a different one for editing it.

Frequently Asked Questions

What happens if I close Excel without saving?

Excel usually asks "Do you want to save changes?" before closing. Click Yes to save, or No to close without saving. If you click No by accident, your changes since the last save are lost. If this happens often, turn on AutoSave so you do not have to remember.

Can I save an Excel file with a password?

Yes. Go to File > Info > Protect Workbook and choose "Encrypt with Password". Type a password and click OK. Anyone who opens the file will need to type that password. Write down the password somewhere safe — if you forget it, you cannot open the file.

How do I save an Excel file so it opens in Google Sheets instead?

Save it as a .csv file (File > Save As, choose CSV from the dropdown). Upload the CSV to Google Drive and open it with Google Sheets. Google Sheets will convert it automatically. Keep in mind that some Excel features like complex formulas may not work the same way in Google Sheets.

What is the difference between Save and Save As?

Save (Ctrl+S) updates the file you are currently working on. Save As lets you create a new file with a different name or location, leaving the original file unchanged. Use Save As when you want to keep multiple versions.

Why does my file say "unsaved changes" even after I pressed Ctrl+S?

This usually means the save failed — often because of a lost internet connection if the file is in cloud storage, or because the file is read-only. Check your internet connection and try saving again. If it keeps happening, try Save As to save it with a new name or in a different location.