Excel Functions Tutorials
- Excel Tools
- Excel Ribbons and Tabs
- Quick Access Toolbar in Excel (QAT)
- "Save As" Shortcut in Excel
- Accounting Number Format in Excel
- Add-Ins in excel
- Add Filter in Excel
- Advanced Filter in Excel
- Auto Filter In Excel
- Auto Format Excel
- AutoFill in Excel
- Analysis ToolPak in Excel
- ANOVA in Excel
- Border in Excel
- Checkbox in Excel
- Check Mark in Excel (? Tick Symbol)
- Combo Box in Excel and VBA
- Conditional Formatting in Excel
- Conditional Formatting with Formulas
- Conditional Formatting for Blank Cells
- Conditional Formatting Based on Another Cell Value
- Conditional Formatting in Pivot Table
- Consolidate Data in Excel
- Comma Style in Excel
- CSV vs Excel
- Data Bars in Excel
- Data Table in Excel
- Data Validation Excel
- Data Model in Excel
- Developer Tab in Excel
- Descriptive Statistics in Excel
- Dynamic Named Range in Excel
- Drawing in Excel
- Excel Fill Handle
- Excel Fill Down
- Error Bars in Excel
- Excel Forms for Data Entry
- Excel Tables
- Excel Power View
- Exponential Smoothing in Excel
- Filters in Excel
- Flash Fill in Excel
- Freeze Panes in Excel
- Freeze Columns in Excel
- Freeze Cells in Excel
- Format Painter in Excel
- Shortcut for Format Painter in Excel
- F-Test in Excel
- Goal Seek in Excel
- Gridlines in Excel
- Heat Map in Excel
- 3D Maps in Excel
- Header and Footer in Excel
- Insert Button in Excel
- Insert / Draw Line in Excel
- Insert Function in Excel
- List Box in Excel VBA
- Lock Cells in Excel
- Macros in Excel
- Enable Macros in Excel
- Merge and Center in Excel
- Merge Cells in Excel
- Merge Tables in Excel
- Name Box in Excel
- Name Range in Excel
- Null in Excel
- One Variable Data Table in Excel
- OneDrive Excel
- Protect Workbook in Excel
- Pivot Table in Excel
- Pivot Table Examples
- Pivot Table Filter
- Pivot Table Slicer
- Paste Special in Excel (With Top 10 Shortcuts)
- Quick Analysis Tools in Excel
- Radio Button in Excel
- Recording Macros in Excel
- Regression Analysis in Excel
- Scenario Manager in Excel
- Scroll Bars in Excel
- Scroll Lock in Excel
- Slicers in Excel
- Solver in Excel
- Sort by Color in Excel
- Sort by Number in Excel
- Sort Data in Excel
- Sparklines in Excel
- Spell Check in Excel
- Split Panes in Excel (Horizontally, Vertically, Cross Split)
- Status Bar in Excel
- Text to Columns in Excel
- Timeline in Excel
- Toolbar on Excel
- Track Changes in Excel
- Trend Line in Excel
- Two-Variable Data Table in Excel
- Watch Window in Excel
- Wrap Text in Excel
- XML in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tips (178+)
- VBA (162+)
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.
Save As Shortcut (Table of Contents)
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 created in excel once the file is closed. So this is very important that these functions must be understood clearly.
- “Save As” shortcut key in excel is different from the “Save” shortcut of excel as “Save As” function enables a user to store the data in a separate file or even in a separate format from the original format.
- It was introduced when it has been observed that the user loses the original file once the changes are saved in the file. “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 in 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 “Save As” function to quick Access toll bar.
#3 – Adding “Save As” function to 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 make sure 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.
Now, choose a new file name, file type, and 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 we have added the “Save As” function we can use it with the 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 “File option” and choose the “option” from the menu.
From the customize ribbon tab, choose all commands and search for “Save as” function and add that to the ribbon.
After “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
Saveas 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 is 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 has 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 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 “file name exists” and if accidentally we override the warning and hit 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 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 keyboard shortcut to Save and Save As Function including (F12 function, Using Quick Access Toolbar, Adding it in Ribbon and creating shortcut in VBA). You may learn more about Excel from the following articles –