How to Assign Save As Shortcut Key in Excel


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.

Excel IconSource:

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.

Excel OptionsSource:

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.

Customize RibbonSource:

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.

Customize Keyboard ShortcutsSource:

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.

File CategorySource:

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.

Save As CommandSource:

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.

Assign Shortcut KeySource:

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.

Close WindowsSource:

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.

Test Shortcut KeySource:


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!

Related video of How to Assign Save As Shortcut Key in Excel

M Arthur
M Arthur

Pembelajar dan penyuka dunia teknologi. Suka sekali berbagi pengetahuan lewat tulisan. Terimakasih sudah membaca salah satu tulisan saya.