Subscript and superscript in Excel: a tutorial

Subscript and superscript in Excel: a tutorial

How to type subscript and superscript in Excel is an essential skill, especially for students. Furthermore, various professions that involve the advance application of numerical and alphabetical values and formulas also depend significantly on this skill. How to do subscript and Excel superscript can be achieved through a simple tutorial, and learning their simple keyboard shortcuts.

subscript in Excel

Image: pexels.com
Source: UGC

As a Microsoft Office user, have you ever faced the challenge of typing a subscript or superscript in Excel? Despite both formats being present in the Word dashboard, they tend to lack in Excel. The good news is that you can quickly learn how to superscript and how to do subscript in Excel through the below step by step tutorial that contains shortcuts.

Superscript in Excel

Superscript refers to any small numerical or alphabetical text formatting that is typed above the baseline. Its main application is in disciplines that involve equations such as math or subjects that include formulas such as chemistry. When typing a superscript in an Excel cell where a text precedes, it tends to appear on the upper side of the typed characters.

Flash Fill Excel: Find out how to use it quite easily

Subscript in Excel

On the other hand, subscript refers to any small character that is typed below the normal text baseline. It is often applied in writing down equations in mathematical topics and writing down formulas in the chemical calculation.

An Excel subscript and superscript added by basically formatting the typed text in the spreadsheet cells. As a result, achieving any of the two will significantly depend on the “Format Cells” options provided by this Microsoft Office software program. Go through the below step by step tutorial for better understanding.

How do I add a superscript in Excel?

superscript in Excel

Image: legit.ng
Source: Original

  1. Identify the specific text that you would want to format. Select the text by double-clicking on the particular cell that contains the text
  2. Right click on the selected character to open the dialogue box
  3. Select the Format Cells option to access additional commands
  4. Select the Font icon
  5. Scroll down and click on the Superscript option
  6. Press OK
Master the concept of how to multiply in Excel with our easy guide

READ ALSO: How to split cells in Excel: An easy tutorial

What is the shortcut for superscript in Excel?

The shortcut involves you accessing the “Format Cells” dialogue box by simply pressing on a combination of keyboard shortcut keys.

  1. Identify the text of interest and select such that it appears to be highlighted
  2. Press Ctrl + 1 keyboard keys that will open up the Fond dialogue box
  3. Scroll down and select the Superscript icon
  4. Press OK

Superscript shortcut: (Ctrl + 1), followed by (Alt + E), and finally (Enter)

How do you put a subscript in Excel?

  1. Double Click on the specific cell of interest
  2. Select the particular value you want formatted
  3. With the cursor still on the value, right click
  4. Select “Format Cells" option to access the dialogue box
  5. Select the Font icon
  6. Click on the subscript option that appears below the “Effects”
  7. Press OK
How to add in Excel: Simple instructions to follow

What is the shortcut for subscript in Excel?

how to type a subscript

Image: legit.ng
Source: Original

  1. Select the text of interest in the specific cell group
  2. Click on Ctrl + 1 to access the Font dialog box
  3. Select the subscript Excel option
  4. Click OK

Subscript shortcut: (Ctrl + 1), followed by (Alt + B), and finally (Enter)

It is important to note that the formatted changes will be visible on the selected texts in the cells, unlike the above-positioned formula bar.

For individuals who are looking for a different option on how to type a subscript or superscript on Excel, that does not require memorizing the shortcut keys on the keyboard; you can achieve your superscript editing by clicking on the down-facing-arrow. This will immediately open the Font dialogue box that is located on the furthest bottom left side of the “Font” icon that is present on the Excel ribbon.

Learning how to subscript and superscript in Excel involves short steps that are either easily crammed or practically performed. Since learning how to subscript and superscript are essential in most student school life and professional records, chemical formulas, and advanced calculation, it is crucial for you to learn and practice using the above-demonstrated manual.

Top tips on how to add error bars in Excel in Windows and Mac

READ ALSO: How to find and remove duplicates Excel: tutorial

Source: Legit Newspaper

Online view pixel