For example, If you add the “Save As” option to your Quick Access Toolbar, you may move aimlessly over the icon to see its keyboard shortcut. e.g., Alt+H keyboard shortcut to open the Home tab.

Excel Shortcut: “Save As”

Save and Save As: Both shortcuts belong to Excel’s “File” class functions. “Save” and “Save As” shortcut keys in Excel save the temporary data in Excel to an Excel file.

“Save” and “Save As” Shortcuts in ExcelShortcuts In ExcelAn Excel shortcut is a technique of performing a manual task in a quicker way.read more are the most important functions as they enable the user to save the data created in Excel. Without these functions, the user may lose the data that has been made in Excel once the file is closed. So, one must understand these functions clearly.

  • The “Save As” shortcut key in Excel differs from the “Save” shortcut in Excel. The “Save As” function enables users to store the data in a separate file or even in an independent format from the original structure.It was introduced when it observed that the user loses the original file once the changes are saved in the file. The “Save As” shortcut function in Excel enables users to save the changes made in the primary file in a new file. Using the “Save As” function, the user can keep the file in the same format, with a different name, or even at a different location.So, Excel’s “Save As” shortcut function offers more functionality than Excel’s traditional “Save” function.

Save As Shortcut in Excel Examples

Add the “Save As” function to the ribbon.

How to Use the “Save As” Shortcut in Excel?

Below are the four methods of using Excel’s “Save As” shortcut.

  • Using the “Save As” shortcut key in Excel – F12 Add the “Save As” function to the Quick Access Toolbar. Add the “Save As” function to the ribbon. Using VBA

Method #1 – Using the Excel Keyboard Shortcut for “Save As”

Step 1 – Make sure that no undoing of actions is required.

Before saving the file, one should ensure that no action performed needs an undo. If it requires undoing, one must first undo the action and then only can save the changes.

Step 2 – Use the keyboard Excel shortcut key “F12” to open the “Save As” dialog box.

Step 3 – Please choose a new file name, type, and location where you want to save the file.

Method #2 – Add the “Save As” Function to the Quick Access Toolbar in Excel

Step 1 –

Go to the Quick Access ToolbarQuick Access ToolbarQuick Access Toolbar (QAT) is a toolbar in Excel that may be customized and is located on the upper left-hand side of the window. It enables users to save important shortcuts and easily access them when needed.read more and click on the little “dropdown” key.

Step 2 –

From the options, choose the option “More Commands.”

Step 3 –

Choose “All Commands” from the menu and add the “Save As” function to the Quick Access Toolbar.

Step 4 –

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

One can also add the “Save As” function to the ribbon.

Click on “File” and choose “Options” from the menu.

Choose all commands from the customize ribbon tab, search for the “Save As” function, and add that to the ribbon.

After the “Save As” function is added to the ribbon, it will appear 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 active Excel.

Save As is the “Save As” function that must be executed.

“Save this as this name” and enter the name by which the file has to be saved.

Explanation of the “Save As” Function in Excel

Whenever we work on a spreadsheet shared between teammates, then it becomes essential that the other team members should not edit the primary file. For example, suppose there is a situation where the team manager has created a file and shared the file with the teammates. Some teammates have altered the formulas as per their needs and saved the changes in the file.

In such a situation, it will create a problem for the user who has made the primary file, as the teammate’s changes are already saved in the same file. Furthermore, restoring the changes and recovering the original file is impossible. So, to take care of both situations, we use Excel’s “Save As” function to save the changes and keep the primary file.

  • Excel’s “Save As” function allows the user to save the changes by a new file name and enables the user to change the file type and location where the file has been saved.Using the “Save As” function, the user can create the file with a new location and a new file type. However, sometimes the user needs to save a file as a “PDF,” and sometimes they must change the file type to a macro-enabled worksheet. Therefore, it becomes essential that the user has some inbuilt option in such cases. 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 shortcuts for the “Save As” function.We can use the keyboard shortcut key combinations and add these “Save As” functions in the ribbon or the quick access toolbar. Using the “Save As” shortcut key will enable a user to reduce the time saving the file with conventional methods. Moreover, we also have the VBA code that one can easily use to execute the “Save As” shortcut key in Excel.

Things to Remember About “Save As” Shortcut in Excel

  • We must enter a unique name when using the “Save As” shortcut in Excel. Otherwise, we will get a warning message that “filename exists,” If we accidentally override the warning and hit the save button, the old file will get replaced. Hence, we will lose the primary file.If we used VBA code in ExcelUsed VBA Code In ExcelVBA code refers to a set of instructions written by the user in the Visual Basic Applications programming language on a Visual Basic Editor (VBE) to perform a specific task.read more, we must use the Excel extensionExcel ExtensionExcel extensions represent the file format. It helps the user to save different types of excel files in various formats. For instance, .xlsx is used for simple data, and XLSM is used to store the VBA code.read more “.xlsm” while using the “Save As” shortcut in Excel.If we want to save the file with the same name as the primary file, we should change the file’s location while doing the “Save As” shortcut in Excel.

This article is a guide to Save As Shortcut in Excel. Here we discuss the keyboard shortcut of Save and Save As, including 4 different Excel methods (the F12 function, using the quick access toolbar, adding it in ribbon, and creating a shortcut in VBA). You may learn more about Excel from the following articles: –

  • Age Calculation in ExcelUsing a Shortcut key to Merge Cells in ExcelCompare Two Excel ColumnsUnmerge Cells in Excel