Excel Save As Shortcut
The use of the 'Save As' command is widespread in Excel, and therefore, we can cut the time to increase the speed of the process to some extent by using the 'Save As' shortcuts. So, it is essential to know the Excel 'Save As' shortcuts and increase Excel's overall productivity.
This article discusses some methods to understand how we can use 'Save As' shortcuts in Excel. We are using MS Excel 2013 during this tutorial to discuss the methods. However, the methods are the same for the other versions of Excel too. Before we discuss methods, let us discuss the function of the 'Save As' command and how it is different from the 'Save' command:
'Save' and 'Save As'
Like the 'Save' command, the 'Save As' command also belongs to the 'File' section of Excel. Both commands are important because they allow us to save data created in Excel. However, there is little difference between these commands. Once the file is saved, applying the 'Save' command will save the changes in the same file. However, the 'Save As' command creates a new file with the changes and allows us to choose a specific filename and a location every time. More specifically, we can save changes to the new file even after working on the original file with the 'Save As' command and keep the original file intact from the changes.
In particular, both of these commands (i.e., 'Save' and 'Save As') help us save the temporary data we have in Excel to an Excel file. Without these commands, we would lose data added to Excel after the file was closed. Apart from this, the 'Save As' command offers more options and functionalities than the traditional 'Save' command in Excel. For instance, we can choose a new name, name extension, location, and many more.
'Save As' Shortcuts in Excel
There are four significant ways of using the 'Save As' shortcut in Excel, i.e.:
Let us discuss each method in detail:
By using the Excel Keyboard Shortcut
Using the keyboard shortcut key for performing the 'Save As' task is the easiest and the fastest method. Since the 'Save As' function creates a new copy of the file, we must ensure no more changes are left to be made. Once we are done making changes to the file and want to save a copy of it in a specific folder with a specific extension, we can press the 'F12' key from the keyboard, and it will quickly launch the 'Save As' dialog.
Note: It is important to note that 'F12' is a function key, and we may first need to activate the function keys by pressing the 'Fn' key from the keyboard. For some keyboards, this may not be necessary.
Let us use this method practically:
Suppose the manager has shared an Excel file with us for further corrections, suggestions, or improvements. In this case, we shouldn't disturb/ alter the original file. So, if we have something to add to the file, we can make changes to the file and then save it using the 'Save As' keyboard shortcut.
By using the 'Save As' Shortcut from the Quick Access Toolbar
Another method includes the shortcut of the 'Save As' command directly from the 'Quick Access Toolbar'. However, we must configure the setup before we can start using it. We need to follow the steps discussed below to configure the setup and further use the shortcut:
By using the 'Save As' Shortcut from the Ribbon
Another method includes the shortcut of the 'Save As' command directly from the Ribbon. Like the above method, we must configure the shortcut on Ribbon before we can start using it. We need to follow the steps discussed below to configure the 'Save As' shortcut and further use it:
By using the VBA
Since Excel allows us to use VBA codes, we can also use little coding as a shortcut for the 'Save As' command. The advantage of using this method is that we can give a file name instantly while coding. However, this method may not be friendly for beginners or people with no coding knowledge.
To apply this method, we can use the following syntax/ code:
ActiveWorkbook.saveas ("Enter File Name Here")
'ActiveWorkbook' indicates the Excel file that is currently in use.
'saveas' indicates that the command 'Save As' must be executed.
'Enter File Name Here' means that we need to put a corresponding name by which the file has to be saved.
Once we enter the code into the VBA editor and run it, the file with an entered name will be saved into the exact location as the original one. However, it may tell us that the file will be saved in a macro-enabled format only. In our case, we use the name 'Data New' within the code:
Some Important Points to Remember for Using the 'Save As' Command/ Shortcut
The following are some crucial points to remember to avoid facing any errors when using 'Save As' Shortcut to save files in Excel: