While Microsoft Word provides a straightforward subscript button on its toolbar, Excel requires a few more steps to achieve the same formatting. This can make the task of formatting text as subscript in Excel seem a bit more complex. However, with the right approach, you can easily apply subs...
Every time you want to format text in Excel, open theFormat Cellsdialog 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 normall...
This tutorial demonstrates how to make subscripts and superscripts with text formatting in Excel. Make a Cell Subscript To make the text in a cell subscript, follow these steps: Select the cell(e.g., B2) andright-clickit, then chooseFormat Cells. ...
Before we start, you must know that applying either subscript or superscript in Excel is different for text values and numeric values. You can’t apply superscript to a text value like SpreadsheetoTM the same way you apply the format to a number value of 123. ...
How to Enter a Subscript in Excel. Properly formatting expressions such as "H2O" in your Excel spreadsheet requires the use of subscripts. Subscript formatting makes a letter or number appear smaller and slightly below the rest of the text. Adding subscr
Press“Enter”to convert the text into a subscript. As a result, the text will be H2SO4. How to do Subscript in Excel? Example #1: Using the Shortcut Method Let us use subscript to change the number 2 in this sentence to subscript: “H2O is the chemical formula for water.” ...
Learn how to apply superscript and subscript formats in Excel using various methods, including formulas, custom formatting, and keyboard shortcuts.
3 best methods how to add subscript in excel? (6 best methods) how to apply the accounting number format in excel? (3 best methods) how to apply different indents to each individual line in a cell? in some cases, you may want to apply different indents to each line in the cell. as...
Mixing text and numeric data in formulas is a recipe for frustration.Getty Subscript, or sub, letters are important when writing math or chemistry formulas because, without these letters, the formulas would be unintelligible. Excel was designed to write and use math or chemistry equations, so it...
In Excel, you can subscript letters by applying Format Cells function. 1. Double click at the chemical formula cell you need, and then select one number that you want to subscript, see screenshot:2. Then right click to select Format Cells from the displayed context menu, and in the Format...