Save as is located in the file tab of the worksheet in excel but there are also some keyboard shortcuts of using it, one being on the quick access tool bar or we can press F12 and display the save as option or we press the keyboard shortcut CTRL + S which opens the save as dialog box for us to save the file in the desired path.
Excel Shortcut: “Save As”
“Save” and “Save As” both of these shortcuts belong to the “File” class functions of excel. Save and Save As Shortcut Keys in excel save the temporary data that we have in excel to an excel file.
Save and Save As Shortcuts in excel are the most important functions as they enable the user to save the data that is created in excel, without these functions, the user will lose the data that has been made in excel once the file is closed. So this is very important that these functions must be understood clearly.
- The “Save As” shortcut key in excel is different from the “Save” shortcut of excel as the “Save As” function enables a user to store the data in a separate file or even in an independent format from the original format.
- It was introduced when observed that the user loses the original file once the changes are saved in the file. The “Save AS” shortcut function in excel enables a user to save the changes that have been made in the primary file in a new file. Now, by using the save as function user has the option to save the file in the same format or a different name or even at a different location.
- So “Save as” shortcut function of excel offers more functionality than the traditional “Save” function of Excel.
Save As Shortcut in Excel Examples
#1 – Using Save As shortcut key in excel – F12
#2 – Adding the “Save As” function to the quick Access toll bar.
#3 – Adding the “Save As” function to the ribbon.
#4 – Using VBA
How to Use Save As Shortcut in Excel?
Below are the four methods of using the Save As Shortcut in Excel.
Method #1 – Using the Excel Keyboard Shortcut for Save As
Step 1st– Make sure that No undo of actions is required.
Before saving the file, this should ensure that no action that has been performed needs an undo. If Undo is required, we must first undo the action and then only save the changes.
Use the keyboard excel shortcut key “F12” to open the “Save As” dialogue.
Please choose a new file name, file type, and the location where we want to save the file.
Method #2 – Add Save as Function to the Quick Access Toolbar in Excel
Go to the quick access toolbar and click on the little “Dropdown” key.
From the options, choose the option of “More Commands.”
From the menu, choose the “All Commands” and add the “Save as” function to the Quick Access toolbar.
After adding the “Save As” function, we can use it with a single click.
Method #3 – Adding “Save as” Option to the Ribbon in Excel
The “Save as” function can also be added to the ribbon.
Click on the “File option” and choose the “option” from the menu.
From the customize ribbon tab, choose all commands and search for the “Save as” function and add that to the ribbon.
After the “Save as” function is added to the ribbon, then it will appear as below.
Method #4 – Use VBA as a Save As Shortcut
VBA can also be used as a shortcut for “Save as” by using the code.
Activeworkbook means the excel that is active.
Save as means the “Save as” function that needs to be executed.
“save this as this name” enter the name by which the file has to be saved.
Explanation of “Save As” Function in Excel
Whenever we are working on a spreadsheet that’s shared between teammates, then this becomes important that the primary file is not edited by the other members of the team. Let’s suppose a situation where the manager of the team has created a file and shared the file with the teammates, and some of the teammates have altered the formulas as per there need and also saved the changes in the file.
Now, this will create a problem for the user that has created the primary file as the changes that are made by the teammates are already saved in the same file, and this is now not possible to restore the changes and get back the original file. So, to take care of both the situations that are to save the changes and also to keep the primary file, we use the “Save As” function of Excel.
- “Save As” function of excel not only allows the user to save the changes by a new file name but also allows the user to change the file type and location where the file has been saved.
- By using the “Save as” function, this can be possible that the user can create the file that has a new location and a new file type. Sometimes the user has to save a file as a Pdf and sometimes want to change the file type to a macro-enabled worksheet, and in such cases, this becomes important that the user has some inbuilt option to do so and hence we have the “Save as” function in excel.
- So whenever we want to save the changes and the primary file, use the “Save as” function. There are many ways to add the shortcuts for the “Save as” function.
- We can use the keyboard shortcut key combinations and also add these “Save as” function in the ribbon or in quick access toolbar. Using Save As shortcut keys will enable a user to cut the time that is used in saving the file with the conventional methods. Moreover, we also have the VBA code that can be used to easily used to execute the “Save As” shortcut key in excel.
Things to Remember About “Save As” Shortcut in Excel
- When we are using the “Save as “shortcut in excel, we must enter a unique name; else we will get a warning message that “filename exists” and if accidentally we override the warning and hit the save button, then the old file will get replaced, and hence we will lose the primary file.
- If we have used VBA code in excel, then this is important that we use the excel extension “.xlsm” while using the “Save as” Shortcut in excel.
- If we want to save the file with the same name as of the primary file, then we should change the location of the file while doing the “Save As” shortcut in excel.
This has been a guide to Save As Shortcut in Excel. Here we discuss the top methods to use a keyboard shortcut to Save and Save As Function, including (F12 function, Using Quick Access Toolbar, Adding it in Ribbon, and creating a shortcut in VBA). You may learn more about Excel from the following articles –