Excel shortcuts

How to create a superscript shortcut in Microsoft Excel

If you work with Microsoft Excel on a regular basis, you may find yourself needing to create superscript characters from time to time. While you could always just insert the characters manually each time you need them, this can be time-consuming and frustrating, especially if you need to create superscript characters frequently. Fortunately, there is a way to create a shortcut in Microsoft Excel that will allow you to quickly and easily create superscript characters whenever you need them.

The first thing you'll need to do is open up Microsoft Excel and create a new workbook. Once you have the workbook open, click on the "File" menu and then select "Options." In the "Excel Options" window that appears, select "Customize Ribbon" from the list of options on the left-hand side. In the "Customize the Ribbon" area on the right-hand side, select the "Main Tabs" checkbox and then click on "OK."

Now that you have the "Main Tabs" option enabled, you should see a new "Developer" tab appear at the end of the toolbar at the top of the Excel window. Click on the "Developer" tab and then select "Macros" from the menu. In the "Macro Security" dialog box that appears, select the "Disable all macros except digitally signed macros" option and then click on "OK."

With the "Developer" tab still selected, click on the "Visual Basic" button. This will open up the Microsoft Visual Basic for Applications window. In the "Project - VBAProject" pane on the left-hand side of the window, double-click on "Module1" to open it up in the main pane.

Now, you'll need to copy and paste the following code into the main pane:

Sub Superscript()
'
' Superscript Macro
' Keyboard shortcut: Ctrl+Shift+S
'
Selection.Font.Superscript = True
End Sub

Once you have the code copied and pasted into the main pane, click on the "File" menu and select "Save." In the "Save As" dialog box that appears, navigate to the location where you want to save the file and then enter "Superscript.xlsm" into the "File name" field. Make sure that the "Save as type" field is set to "Excel Macro-Enabled Workbook (*.xlsm)" and then click on the "Save" button.

Now, close the Microsoft Visual Basic for Applications window and return to your workbook. Click on the "View" tab and then select "Macros." In the "Macros" dialog box that appears, select "Superscript" from the list of macros and then click on the "Run" button.

You should now see the text that you selected in your workbook appear as superscript characters. If you want to create a keyboard shortcut for this macro so that you can quickly and easily create superscript characters in the future, click on the "Developer" tab and then select "Macros." In the "Macros" dialog box that appears, select "Superscript" from the list of macros and then click on the "Options" button.

In the "Macro Options" dialog box that appears, enter "Ctrl+Shift+S" into the "Shortcut key" field and then click on the "OK" button. From now on, whenever you want to quickly create superscript characters in Microsoft Excel, all you'll need to do is select the text you want to convert and then press "Ctrl+Shift+S" on your keyboard.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.