Subscripts & Superscripts in Excel (with Examples)

This is a comprehensive video about "subscript" & "superscript" in excel. We will take you through all the possible use cases and by the end of this video, you will be an expert in the topic.

Video Companion spreadsheet that was referred in the video is available at: https://drive.google.com/open?id=1yK_MwLeYlNShRdFzGVOIQB73bUWkCUxH

Index for this video is shown below. Feel free to move to the respective sections by clicking on the timestamp!

01:02 : Intro on Subscripts & Superscripts in Excel
01:54 : Typing Subscripts & Superscripts in Excel with 14 Live examples.
07:20 : How to move out of subscripts in excel
08:02 : Removing Subscript/Superscript formatting in excel
08:34 : How to Copy Paste superscript/subscript from one cell to another
08:46 : Formatting superscript/subscript in Excel (Change Font Size, Color, Bold, Italics)
09:35 : Custom Format with Superscript in Excel (Useful for converting whole column data to Superscript, However, works only for Degree, Superscript 1,2,3)
11:40 : Using format painter to replicate Superscript/Subscript in Excel (Works only for Degree, Superscript 1,2,3)
12:07 : Create Superscript in Excel using formula (Works only for Degree, Superscript 1,2,3)
13:27 : Find and Replace text with Superscript
14:26 : Adding Subscript/Superscript shortcuts to ribbon for easy access
15:52 : Adding Superscript/Subscript shortcuts to Excel's Quick Access Toolbar
16:34 : Superscript/Subscript Shortcuts in Excel
18:59 : Simply copy paste subscript/superscript into Excel

Superscripts/Symbol list and corresponding Decimal values are available in the below link. You can use this to type quick shortcuts (e.g. ALT + 0178 for subscript 2 etc.)
https://en.wikipedia.org/wiki/List_of_Unicode_characters#Latin-1_Supplement

The Unicode list of subscripts and superscripts are available in the below link. This is for copy pasting from this page directly to your excel
https://en.wikipedia.org/wiki/Unicode_subscripts_and_superscripts

In this video, I walk through the below examples
1. Typing positions using superscript in Excel. (1st, 2nd etc.)
2. Typing Temperatures (degree sign) using superscript in Excel. (10°C/F)
3. Typing dimensions like m² using superscript in Excel.
4. Power of a number (10² etc) using superscript in Excel.
5. Typing Chemical equations like H₂O using subscript in Excel.
6. Typing numbers with bases (23₈) using subscript in excel.
7. Typing subscript and superscript in the same cell (a²b₄) in Excel.
8. Type a word as subscript in Excel.
9. Type a letter as a subscript (aₓ) in Excel.
10. Infinity as Superscript in Excel. (10 to the power infinity)
11. Infinity as Subscript in Excel. (10 to the base infinity)
12. Double subscript in Excel (a to the base b to the base c) using using Ink Equations.
13. Double superscript in Excel (a to the power b to the power c) using using Ink Equations.
13. Type Footnotes in excel using superscript. (e.g. Note¹)

Definition of Subscript - Subscripts are small letters or numbers below the baseline.
So if you see the equations like H2O or number with a base etc. are examples of subscripts.

Definition of Superscript - Superscripts is a small number or letter or it can be a combination above the baseline. So like, 1st or it could be 10 to the power of 4 or meter squared etc are superscripts.

Subscript Implementation in Excel
Step 1: Select the text that needs to be converted into a subscript.
Step 2: Right Click
Step 3: Select 'Format Cells'
Step 4: Check 'Subscript' checkbox.
Step 5: Click OK.

Superscript Implementation in Excel
Step 1: Select the text that needs to be converted into a superscript.
Step 2: Right Click
Step 3: Select 'Format Cells'
Step 4: Check 'Superscript' checkbox.
Step 5: Click OK.

Shortcut for Subscript in Excel
1. Press and hold the ALT key, type H,F,N,B... one after the other. Release the ALT key.
2. Press and hold the CTRL key, type 1. Release the CTRL key. Press and hold the ALT key, type B. Release the ALT key and Press OK.

Shortcut for Superscript in Excel
1. Press and hold the ALT key, type H,F,N,E... one after the other. Release the ALT key.
2. Press and hold the CTRL key, type 1. Release the CTRL key. Press and hold the ALT key, type E. Release the ALT key and Press OK.

#excelsubscript #excelsuperscript #learn365club

Music: https://www.bensound.com

Видео Subscripts & Superscripts in Excel (with Examples) канала theSoftwareGuy