Excel shortcuts

How to create a shortcut for subscript in Excel

If you work with Microsoft Excel on a regular basis, you may find yourself in need of a way to quickly create subscript characters. While you could always insert the characters manually, this can be time-consuming and frustrating, especially if you need to do it frequently. Fortunately, there is a way to create a shortcut for subscript in Excel, which can save you a lot of time and hassle.

The first thing you need to do is open up the Microsoft Excel application. Then, click on the 'File' menu and select 'Options'. In the 'Excel Options' window that appears, select 'Customize Ribbon' from the list of options on the left-hand side. Next, click on the 'Customize' button next to 'Keyboard shortcuts'.

In the 'Customize Keyboard' window that appears, select the 'Home' tab from the 'Category' drop-down menu. Then, scroll down the list of 'Commands' until you find the 'Subscript' command. Once you have found it, click on the 'Press new shortcut key' field and press the shortcut key combination that you would like to use for subscript. For example, you could use 'Ctrl+Shift+S'.

Once you have selected a shortcut key combination, click on the 'Assign' button and then click on the 'Close' button. You should now be able to use your new shortcut key combination to quickly insert subscript characters into your Excel spreadsheet.

If you find that you need to use subscript characters on a regular basis, you may also want to consider creating a custom number format that includes subscript characters. This can be done by selecting the 'Number' tab from the 'Category' drop-down menu in the 'Customize Keyboard' window. Then, scroll down the list of 'Commands' until you find the 'Format Cells' command. Once you have found it, click on the 'Press new shortcut key' field and press the shortcut key combination that you would like to use for the 'Format Cells' command. For example, you could use 'Ctrl+Shift+F'.

Once you have selected a shortcut key combination for the 'Format Cells' command, click on the 'Assign' button and then click on the 'Close' button. You should now be able to use your new shortcut key combination to quickly open the 'Format Cells' dialog box. In the 'Number' tab of the 'Format Cells' dialog box, select the 'Custom' option from the 'Category' drop-down menu. In the 'Type' field, enter the following:

[h]mm:ss;@

This will ensure that your cells are formatted as time values. Next, click on the 'Subscript' button in the 'Font' group. Then, click on the 'OK' button. Your cells should now be formatted as time values with subscript characters.

If you need to insert subscript characters into your cells on a regular basis, you may also want to consider creating a custom number format that includes subscript characters. This can be done by selecting the 'Number' tab from the 'Category' drop-down menu in the 'Customize Keyboard' window. Then, scroll down the list of 'Commands' until you find the 'Format Cells' command. Once you have found it, click on the 'Press new shortcut key' field and press the shortcut key combination that you would like to use for the 'Format Cells' command. For example, you could use 'Ctrl+Shift+F'.

Once you have selected a shortcut key combination for the 'Format Cells' command, click on the 'Assign' button and then click on the 'Close' button. You should now be able to use your new shortcut key combination to quickly open the 'Format Cells' dialog box. In the 'Number' tab of the 'Format Cells' dialog box, select the 'Custom' option from the 'Category' drop-down menu. In the 'Type' field, enter the following:

[h]mm:ss;@

This will ensure that your cells are formatted as time values. Next, click on the 'Subscript' button in the 'Font' group. Then, click on the 'OK' button. Your cells should now be formatted as time values with subscript characters.

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.