![how to do subscripts excel how to do subscripts excel](https://www.tech-recipes.com/wp-content/uploads/word_for_mac.png)
If you'd like to apply strikethrough to just part of a cell, select the text you'd like to format in the formula bar, or, in the cell itself. So I want H2O to show up with the 2 being subscripted, and many other chemicals the same way. If you'd like to apply strikethrough formatting to the entire contents of a cell, just select the cell, access the Format Cells dialog, and check the Strikethrough box. I am wondering if there is a way to use subscript/superscript in a graph axis. The process for applying strikethrough formatting is similar. To remove superscript or subscript formatting, select the cell, and then access the Format Cells dialog box. However, when you edit a cell directly you will see the formatting clearly. Note that the formula bar doesn't show any indication that superscript or subscript formatting has been applied.
![how to do subscripts excel how to do subscripts excel](https://support.content.office.net/en-us/media/119e8a0d-0248-4715-981e-2ca0e61521d7.png)
Then use Format Cells to apply Superscript or Subscript as you like. As before, carefully select the text you'd like to format. The second option is to select a cell and work directly in the formula bar. On the Font tab, check the format you want, and press OK to confirm. Then, select the text you'd like to format and access the Format Cells dialog box. The first option is to double-click a cell, or select the cell and press F2 to enter edit mode. There are two ways to apply subscript or superscript. To give yourself maximum flexibility when using footnotes in Excel reporting, use the functions in the table earlier to add superscript numbers to text cells that can be used below cells or as part of an Excel chart.
#How to do subscripts excel manual
If you do, you'll see that all text in a cell is affected, which is almost certainly not what you want. They do not automatically resize if the chart is resized and require more manual sizing to ensure that all the text appears. You can't just select a cell normally and apply one of these formats. However, if youre always appending a 1 to each Greek letter, I. Then, when you write out variable, you would parse the string, remove the tags and set the font.Subscript property accordingly. To apply either subscript or superscript, you need to follow a particular process. You could use inline tags, like in HTML, to indicate where the subscript begins and ends. Instead, they're located on the Font tab of the Format Cells dialog box in the Effects group. Right-click on the selected text, scroll down the list and click on 'Format.' Navigate to the pop-up box.
#How to do subscripts excel how to
In the first example, we’ll show you how to use a short macro to apply the subscript shortcut effectively. We always support the faster way to solve a problem. Click twice on the text that needs to be formatted. If you want to use other ways to apply subscript in Excel, you can do that.
![how to do subscripts excel how to do subscripts excel](https://i.ytimg.com/vi/FzxsNLq3VCA/maxresdefault.jpg)
If you need to apply subscript or superscript formatting, you won't find these options on the ribbon. Follow these steps to insert subscripts in your Excel spreadsheet. In this lesson we'll look at how to apply subscript, superscript, and strikethrough formatting.