Three Ways To Insert Superscripts And Subscripts
Three Ways To Insert Superscripts And Subscripts @BrainUpp
You can also use keyboard shortcuts to quickly apply superscript or subscript to selected text. For superscript, press Control-Shift-Command-Plus Sign (+). For subscript, press Control-Command-Minus Sign (-).
Format text or numbers as superscript or subscript
Select characters in a cell or cell range that you'd like to format. On the Home tab, in the Font group, click the Font Settings dialog box launcher. Press CTRL+1. Under Effects, check the Superscript or Subscript box, and click OK.
How to do subscript and superscript in Excel for text and numbers
What is superscript and subscript in Excel?
Superscript is a small letter or number typed above the baseline. If there is any preceding text in a cell, superscript is attached to the top of the regular sized characters.
For example, you can use superscript to write square units like m2 or inch2, ordinal numbers such as 1st, 2nd, or 3rd, or exponents in math such as 23 or 52.
Subscript is a small character or string that sits below the line of text.
In math, it is often used to write number bases like 648 or chemical formulas such as H2O or NH3.
How to do superscript and subscript for text values
Most Excel formatting can be applied to any data type in the same way. Superscript and subscript are a different story. The methods described in this section work only for text values, but not for numbers. Why? I believe only the Microsoft team know the exact reason :) Possibly because this would convert numbers to strings and they want to prevent you from accidentally mangling your data.
Apply superscript or subscript format
Every time you want to format text in Excel, open the Format Cells dialog box. It allows you to quickly apply the superscript, subscript, and strikethrough effect or whatever formatting you want.
In case of superscript and subscript, there is one hurdle. You can't just apply the format normally to the entire cell because this would move all the text above or below the baseline, which is almost certainly not what you want.
Here are the steps to insert subscript or superscript correctly:
Select the text you'd like to format. For this, double click a cell and select the text using the mouse. Or you can go the old-fashioned way - click the cell and press F2 to enter edit mode.
Open the Format Cells dialog by pressing Ctrl + 1 or right-click the selection and choose Format Cells… from the context menu.
In the Format Cells dialog box, go to the Font tab, and select Superscript or Subscript under Effects.
Click OK to save the change and close the dialog.
Done! The selected text will be subscripted or superscripted depending on which option you've ticked off.
Note. Like any other formatting in Excel, it changes only visual representation of the value in a cell. The formula bar will display the original value without any indication of the applied superscript or subscript format.
Excel subscript shortcut
Ctrl + 1, then Alt + B, and then Enter
Excel subscript shortcut
Please pay attention that the keys should not be pressed simultaneously, each key combination should be pressed and released in turn:
Select one or more characters you want to format.
Press Ctrl + 1 to open the Format Cells dialog box.
Then press either Alt + E to select the Superscript option or Alt + B to select Subscript.
Hit the Enter key to apply the formatting and close the dialog.
Add Superscript and Subscript icons to Quick Access Toolbar
The users of Excel 2016 on Office 365 subscriptions, have the ability to add the Subscript and Superscript buttons to their Quick Access Toolbar (QAT). Here are the steps for this one-time setup:
Click the down arrow next to the QAT in the upper left corner of the Excel window, and choose More Commands… from the pop-up menu.
Add Superscript andUnder Choose commands from, select Commands Not in the Ribbon, scroll down, select Subscript in the list of commands, and click the Add button.
In the same way, add the Superscript button.
With both buttons added to the list of commands on the right pane, click OK to save the changes.
Moreover, a special keyboard shortcut is assigned to each Quick Access Toolbar button enabling you to subscript and superscript in Excel 2016 with a single key stroke! The key combinations vary depending on how many buttons your QAT accommodates.
To find out the superscript and subscript shortcuts on your computer, hold the Alt key and look at the Quick Access Toolbar. For me, they are as follows:
Subscript shortcut: Alt + 4
Superscript shortcut: Alt + 5
Subscript icons to Quick Access Toolbar
The users of Excel 2016 on Office 365 subscriptions, have the ability to add the Subscript and Superscript buttons to their Quick Access Toolbar (QAT). Here are the steps for this one-time setup:
Click the down arrow next to the QAT in the upper left corner of the Excel window, and choose More Commands… from the pop-up menu.
Watch video Three Ways To Insert Superscripts And Subscripts online without registration, duration hours minute second in high quality. This video was added by user Brain Up 12 September 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,993 once and liked it 64 people.