How to Save an Excel File

Learning how to save an Excel file is one of the first things you should know when working with Microsoft Excel. Saving a workbook regularly helps protect your work and makes sure you can access your data again later.

Excel provides several ways to save a file. You can use the Save command, a keyboard shortcut, or Save As when you want to create a new copy, change the file name, or save the workbook in another location or format.

💾 How to Save an Excel File using the Save Option

Follow the below steps to save your Excel workbook:

• Click the File tab in the upper left corner.

• Select Save from the menu.

• If this is the first time you are saving the workbook, the Save As window will appear.

• Select the folder where you want to save the file.

• Enter a suitable name for the Excel file.

• Select the required file format from the Save as type or file format option.

• Click Save.

⌨️ How to Save an Excel File Using a Keyboard Shortcut

The quickest way to save an Excel file is to use a keyboard shortcut. Follow the below steps to save the Excel file using the shortcut key:

• Press Ctrl + S on Windows.

• On Mac, press Command + S.

• If the workbook has not been saved before, Excel will ask you to choose a file name and location.

• Enter the file name and select the folder where you want to save it.

• Click Save.

💾 Save an Excel File with a different Name, Location or Format

Follow the below steps to save the Excel file using a new name, with a different location or format:

• Click File.
• Select Save As.
• Location: Browse to the location where you want to save the workbook.
• Name: Enter a new file name.
• Format: Select the required file format.
• Click Save.

📊 Common Excel File Formats

Excel supports several file formats, and each format is designed for a specific purpose, such as editing, sharing, compatibility, or storing data. The most common file formats are:

• Excel Workbook (.xlsx): The standard Excel format used for most workbooks and spreadsheets.

• Excel Macro Enabled Workbook (.xlsm): Used when the workbook contains VBA macros.

• Excel Binary Workbook (.xlsb): A binary format that can be useful for large workbooks and may help improve file performance.

• Excel 97 to 2003 Workbook (.xls): An older Excel format used mainly for compatibility with earlier versions of Excel.

• CSV (Comma Delimited) (.csv): Used to store tabular data in a simple text format that can be opened by many spreadsheet and data applications.

💾 Save vs Save As in Excel

The below are the main differences between Save and Save As in Excel.

Save

• Purpose: Saves the latest changes to the current Excel file.
• File: Updates the existing workbook without creating another copy.
• File name, location and format: Keeps the same file name, location and format.
• Best for: Regularly saving your work while continuing to use the same workbook.

Save As

• Purpose: Saves the workbook as a new file.

• File: Creates a separate copy while keeping the original workbook unchanged.

• File name, location and format: Allows you to change the file name and save the workbook in a different location or format.

• Best for: Creating a new version of a workbook while keeping the original file.

🔐 What Happens when you Save an Excel File

When you save a workbook, Excel stores the current changes in the selected file. This includes changes such as entered data, formulas, formatting, worksheets, and other supported workbook content.

If you continue editing after saving, the new changes are not necessarily stored until Excel saves the workbook again. For this reason, saving regularly is a useful habit.

⁉️ FAQs

How do I save an Excel file for the first time?

Open the workbook and select File > Save. Choose a location, enter a file name, select the required format, and click Save.

What is the shortcut to save an Excel file?

On Windows, press Ctrl + S. On Mac, press Command + S.

How do I save an Excel file with a new name?

Select File > Save As, enter the new file name, choose the location, and click Save. This creates a separate copy of the workbook.

How do I save an Excel file as XLSX?

Select File > Save As, choose Excel Workbook (*.xlsx) as the file format, and click Save.

How do I save an Excel file as XLS?

Use File > Save As and select Excel 97 2003 Workbook (*.xls) from the available file formats.

How do I save an Excel file as a CSV?

Select File > Save As, choose CSV as the file format, and then save the workbook. Keep in mind that CSV files generally store data from only one worksheet and do not retain many Excel specific features.

Can I save an Excel file as a PDF?

Yes. Excel allows you to save or export a workbook or worksheet as a PDF, depending on your Excel version and available options.

How do I save an Excel file as a PDF?

To save an Excel file as a PDF, open the workbook and select File > Save As. Choose PDF as the file format, select the location, enter a file name, and click Save. You can also use the Export option if it is available in your version of Excel.

Why can’t I save my Excel file?

The problem can occur because the file is read only, the storage location is unavailable, the file name or path has an issue, or another program is using the file. Check the location and permissions and try saving a copy with Save As.

How do I save an Excel file without changing the original?

Use File > Save As and give the new workbook a different name or save it in another folder. Your original file will remain unchanged.

How do I save an Excel file to my computer?

Select File > Save As, choose a folder on your computer, enter the file name, and click Save.

How do I save an Excel file to OneDrive?

Choose File > Save As, select OneDrive, choose a folder, enter a file name, and save the workbook.

How often should I save an Excel file?

Save your workbook whenever you make important changes. Using Ctrl + S or Command + S regularly is a simple way to avoid losing recent work.

Does Excel automatically save my file?

Excel can use AutoSave when a workbook is stored in supported cloud locations such as OneDrive or SharePoint with Microsoft 365. Turn on the AutoSave option near the top of the Excel window to automatically save changes as you work.

AutoSave availability depends on your Excel version and account setup.

How do I change auto save time in Excel?

Excel’s AutoRecover setting controls how often Excel saves recovery information. To change the interval, go to File > Options > Save, check Save AutoRecover information every, and enter the number of minutes you want. Click OK to apply the setting.

Keep in mind that AutoSave and AutoRecover are different features. AutoSave continuously saves supported cloud stored files, while AutoRecover helps recover unsaved work if Excel closes unexpectedly.

What is the difference between XLS and XLSX?

XLSX is the modern Excel workbook format, while XLS is an older format used by earlier versions of Excel. XLSX is generally the better choice unless you specifically need compatibility with older Excel versions.

How do I save an Excel file with macros?

Save the workbook as Excel Macro Enabled Workbook (.xlsm). Using the regular .xlsx format will not preserve VBA macros.

🎯 Conclusion

Knowing how to save an Excel file helps you protect your work and keep your spreadsheets organized. For everyday use, Ctrl + S on Windows or Command + S on Mac is the easiest way to save your latest changes.

When you need to create another version, change the file location, or select a different format, use Save As. For most Excel workbooks, the .xlsx format is the best choice, while special formats such as .xlsm are useful when your workbook contains macros.

Saving your Excel files regularly is a simple habit that can prevent unnecessary data loss and make your work easier to manage.