Simple and Detailed Guide to Saving Excel Files on Computers, Phones, and MacBooks

There are many simple ways to save Excel files on your computer that apply to all types of machines. Let's discover how to do it in this article.

0
261

Excel is becoming the most widely used calculation and statistics tool today. After creating a spreadsheet, users should save the file to access, edit, and share it with friends and colleagues later. So how do you save an Excel file? Let’s find out in the following article!

How to save an Excel file on a Windows computer

There are many ways to save an Excel file on a computer with its own characteristics. You need to research carefully, determine your own documents as well as needs and usage purposes. From there, make the appropriate save choices. Below, FPT Shop would like to share with you some common, simple, and fast ways to save Excel spreadsheets.

Save Excel files with Save, Save As

Differentiate between Save and Save As

Although Save and Save As have the same save function, these two tools are very different.

  • Save: The Save command will help you save changes while creating and editing your own spreadsheet. This is a regular save mode that allows you to save files quickly.
  • Save As: The Save As command will create a copy of the spreadsheet, while the original remains intact. From there, you can set different file formats for the original file.

Save files with Save

Step 1: Press the Save command on the top left of the Excel window, above the Quick Access Toolbar.

Step 2: If it is the first time saving the spreadsheet, the Save As dialog box appears, you select the location to save the available Excel file or click Browse to find the desired save location.

Step 3: Next, you enter the file name in the File name box and click Save. From the next time, when you want to save, you just need to press the Save button.

Save files with Save As

When your Excel file has been saved but you want to create a different copy, use the Save As command as follows:

Step 1: Click on the File tab on the toolbar and then select Save As.

Step 2: Then, you proceed to choose where to save the file, set a new name, and then click Save to save it.

Use keyboard shortcuts to save Excel files

Using keyboard shortcuts is a very simple and convenient way to save Excel files.

Step 1: Press the keyboard shortcut Ctrl + S to activate the Save feature or the F12 key to activate Save As.

Step 2: Next, enter the file name in the File name box and press Enter or Save to complete.

Save Excel files using OneDrive

If you are using Excel from version 2016 onwards, you have the option to store your spreadsheets on the cloud system via OneDrive. With this method, you not only save storage space for personal computers but also easily export and share spreadsheets with others using OneDrive.

To save Excel files with OneDrive, you follow these steps:

Step 1: Turn on Auto Save at the top of the Excel file, above the toolbar, to activate the feature of automatically saving files with OneDrive.

Step 2: Next, click on the OneDrive logo to confirm. You can use an existing account or sign up for a new Microsoft account to log in.

Use the Auto Recovery feature to save files

If you frequently use Microsoft Office, you are probably familiar with Auto Recovery, one of the great features for saving files. With Auto Recovery, the spreadsheet will be automatically saved to a temporary folder. If you forget to save changes or Excel encounters an error, users can still easily restore and recover files.

However, to be able to use this useful feature, you need to enable Auto Recovery in Excel according to the following instructions:

Step 1: Select the File tab on the toolbar > Click Options.

Step 2: In the Excel Options dialog box, click the Save button in the left column and check the Save AutoRecover information every … minutes box in the right frame.

Save Excel files in PDF format

By default, Excel files will be saved as files with the extension .xlsx. However, in some cases, you may want to save this file in PDF format to share it with others for viewing but do not want it to be edited. Follow the steps below to do this:

Step 1: First, click the File tab on the toolbar.

Step 2: Then, select Save As in the left column > Click Browse to select the new save location > Click the PDF option in the Save as type box > Click Save.

How to save an Excel file on a mobile phone

Excel now has a version for working on mobile phones. This allows users to use, create, and edit spreadsheets anytime, anywhere with a smartphone in hand. With the Excel application, to save a file, you also have 2 choices Save or Save As.

Save files with Save

Step 1: Click on the 3 dot icon in the top right corner of the screen > Select Save.

Step 2: Click on Change the name of this file and enter the desired name to save and click OK.

Save files with Save As

Step 1: Click on the 3 dot icon in the top right corner of the screen > Select Save as.

Step 2: Choose the save location, enter a new name, and then click Save.

How to save an Excel file on a MacBook

Although the MacBook is slightly different from other devices, you can still save Excel files using the following steps:

Step 1: At the Excel file you want to save, select Save As or press Command S to save it.

Step 2: Then, choose the save location, set the filename, and click Save.

Conclusion

Just now, FPT Shop has shared with you how to save Excel files on a computer, phone, and MacBook. Hopefully, through this, you will choose the most convenient and fastest method to save your spreadsheets.

You may also like

5 Essential Excel Functions for Beginners

Master the fundamentals of Excel with these 5 basic functions! Learn how to use SUM, AVERAGE, COUNT, MIN, and MAX in order to make calculating and analyzing data easier and more efficient.

A Simple Method for Adding Watermark to Excel for All Spreadsheets in No Time

Watermarking in Excel is a great way to mark your ownership and protect the content on your Excel spreadsheets. If you’re unsure how to do it, you can follow the steps outlined in this article.

How to recover unsaved or overwritten Excel files effectively: a sure-fire method

Knowing how to recover unsaved Excel files can be extremely helpful in cases when your computer unexpectedly shuts down or you accidentally click on “Don’t save” when Excel asks if you want to save your changes before closing. Follow this article to learn the step-by-step process of how to accomplish it.

5+ Effective Ways to Convert PDF to Excel Quickly, Useful Office Tricks

Knowing the ways to convert PDF files to Excel below will enable you to easily edit and add content inside. Office workers and students definitely must know this trick if they want to simplify their tasks.