Search
  • Go Ask Debbie

Excel Tip: How to Add Superscripts and Subscripts to Cells

Julie, of Phoenix asks, “How do I type a superscript font in an Excel cell?”


Let’s face it, Excel is a spreadsheet program meant for use with numbers.


However, Excel does allow for typing specific font types within cells. Add superscripts and subscripts to a cell by following these steps.


First, type the text in the cell as usual. Make sure the cursor is in the cell in which you would like to add a superscript font.


Click in the formula bar or press the F2 key to activate the formula bar.


Click and drag the cursor to highlight the text you want to set as superscript or subscript.


**UPDATE**

In newer versions of Excel, simply right-click and click on the "Format Cells" menu item.



Excel 2003: Click on the “Format” menu and select the “Cells” option.


Select the checkbox for “Superscript” or “Subscript,” whichever you want. Click on the “OK” button to save the changes and return to the cell. Press the “Enter” key to accept the changes to the cell.


Excel 2007: Click on the arrow in the lower right corner of the “Font” area of the “Home” tab. Select the checkbox for “Superscript” or “Subscript,” whichever you want. Click on the “OK” button to save the changes and return to the cell. Press the “Enter” key to accept the changes to the cell.


HINT: Instead of pressing “Enter,” you may click on the green check mark in the formula bar to accept the changes. Follow the same steps and not only can you add superscripts and subscripts to a cell, but you may add whatever formatting you want – as long as it is available in the “Format Cells” dialog window.



0 views

©2020 by Go Ask Debbie. Proudly created with Wix.com