Word for Office 365 for Mac Word 2019 for Mac Word 2016 for Mac OneNote 2016 for Mac More. Less A superscript or subscript is a number, figure, symbol, or indicator that is smaller than the normal line of type and is set slightly above it (superscript) or below it (subscript).
Learning how to write subscript in excel 2010 is a valuable skill if you want to create smaller notations in your spreadsheet. Step # 1 – Selecting the Cell First, start Excel and load the sheet where you want to enter subscript. Here we are going to add a notation next to the “TOTAL” text in cell “A6”. Click in this cell, then in the formula box click to the end of the word. Step # 2 – Opening the Format Cells Window Now, make sure you are in the “Home” tab and locate the “Font” area. In the bottom right corner of the box there is a small icon that looks like an arrow and a box. This will open the “Format Cells” window, at the bottom of the window click the “Subscript” button then click “OK”.
Step # 3 – Entering the Text Now simply enter the text as you normally would. In the formula bar it will appear normal sized but in the cell it will appear smaller.
As you can see learning how to write subscript in excel 2010 is a very simple process.
If you want to apply superscript or subscript format to the text in a cell, you may not find anything for it in the ribbon. This is one of those things where you need to go a level deep to make it happen. In this tutorial, you’ll learn how to apply the superscript and subscript format in Excel. Superscript Format in Excel A superscript format is needed when you want to have 1st, 2nd, 3rd with the alphabets in the superscript format. Or When you want to enter the temperature along with the degree sign but in a superscript format. Here is how you can apply the superscript format in Excel:. Select the cell and double click on it to get into the edit mode (or press F2 to get into the edit mode).
Select the text to which you want to apply the superscript formatting. Right-click on the selected text and select Format Cells. In the Format Cells dialog box, check the Superscript option. This would make the selected part appear as a superscript. Note: There is no way to apply this formatting to text in different cells at one go. You’ll have to select the text one by one in each cell and repeat the above steps.
Subscript Format in Excel Subscript format usage is quite rare in Excel. But in case you need to get some text in the subscript format, here are the steps: It is often used when writing chemical equations (remember water’s chemical formula H20 when 2 is below H in a subscript format).
But in case you need to get some text in the subscript format, here are the steps:. Select the cell and double click on it to get into the edit mode (or press F2 to get into the edit mode). Select the text to which you want to apply the subscript formatting.
Right-click on the selected text and select Format Cells. In the Format Cells dialog box, check the Subscript option.
Again, there is no way to apply this formatting to text in different cells at one go. You’ll have to select the text one by one in each cell and repeat the above steps.
Superscript and Subscript formats are used more often in MS Word and PowerPoint and you can also add these to Quick Access Toolbar. Unfortunately, there is no option to add these in the QAT in Excel. You May Also Like the Following Excel Tutorials:.