Microsoft Excel is widely used for data analysis, calculation, and visualization. It’s a powerful tool that has many features, including the ability to assign shortcut keys to speed up your workflow. One of the most common shortcut keys that you might want to assign is the Save As function. This article will show you how to assign the Save As shortcut key in Excel.
Step 1: Open Excel Options
The first step to assigning a shortcut key is to open Excel Options. To do this, click on the File tab in the top left corner of the Excel window. From there, click on Options at the bottom of the left-hand menu.
Step 2: Customize Ribbon
In the Excel Options window, click on Customize Ribbon in the left-hand menu. This will bring up the Customize Ribbon options on the right-hand side of the window.
Step 3: Customize Keyboard Shortcuts
At the bottom of the Customize Ribbon options, you’ll see a button labeled Customize…. Click on this button to open the Customize Keyboard Shortcuts window.
Step 4: Choose a Category
The Customize Keyboard Shortcuts window will show you a list of categories on the left-hand side. Select the category that the Save As command belongs to. In this case, it’s the File category.
Step 5: Choose a Command
Once you’ve selected the category, you’ll see a list of commands on the right-hand side of the window. Scroll down until you find the Save As command and click on it.
Step 6: Assign a Shortcut Key
After selecting the Save As command, you’ll see the current shortcut key (if there is one) in the Current keys box. To assign a new shortcut key, click on the Press new shortcut key box and then press the key combination you want to use. In this example, we’ll use Ctrl + Shift + S.
Step 7: Close the Windows
Click on the Assign button to assign the new shortcut key. Then click on Close to close the Customize Keyboard Shortcuts window and click on OK to close the Excel Options window.
Step 8: Test the Shortcut Key
Now that you’ve assigned the Save As shortcut key, test it out to make sure it works. To do this, simply press the key combination (Ctrl + Shift + S in our example) and the Save As dialog box should open.
Assigning shortcut keys can save you a lot of time and make your workflow more efficient. By following the steps in this article, you can easily assign the Save As shortcut key in Excel. Try it out and see how much time you can save!