Menu
Format text as subscript with Kutools for Excel. The Kutools for Excel's Superscript / Subscript tool makes it easy to format text as a superscript or subscript in a cell. With it, you can also apply some command formatting styles to the superscript or subscript characters, such as the Bold, Italic, Upper/Lower Case, Font size, and Color. Superscript and Subscript ribbon buttons Is there any way of getting the Subscript & Superscript buttons into Excel 2013 the same as they are in Word 2013? When you have a lot of text in hundreds of cells which includes m2 and m3 it's not particularly efficient.
I have 2 ways: 1. If you are using only the '1', '2' and '3' digits in superscript, you can change them to these characters:. character ¹: in your keyboard: alt+0185 / US-International Keyboard: altgr+1. character ²: in your keyboard: alt+0178 / US-International Keyboard: altgr+2.
character ³: in your keyboard: alt+0179 / US-International Keyboard: altgr+3 1.1. Note: In alt+#### and similar combos, you have to hold alt and then hit the digits from numpad number keys (not the ones above letters), i.e., alt+0185 = hold alt, press numpad 0, press numpad 1, press numpad 8, press numpad 5, release alt 1.2. Note: I'm not sure about the name of 'US-International Keyboard', but in a lot of keyboards I used (one had a similar name) that combos (altgr+1, 2 or 3) worked. You can use another character font. Some fonts are designed for math, so: 2.1. Install one of these fonts:. (and its variants - Sans: normal, condensed, light, mono / Serif: normal, condensed): I think it is the more known of my list.
Cambria Math. Candara.
Consolas. Constantia. Corbel. Lucida Sans Unicode.
Segoe UI 2.2. Open your excel file, select cells containing legend text and change font to one of these 2.3. Use Windows Charmap (Start Run Charmap) or Office Insert Symbol menu to copy and paste or insert superscript (or subscript) characters you want on the contentes of these cells 2.4. Double click on graph, select the legend and change font to the chosen one 2.5. See an example in my Google Docs using DejaVu Sans: HOT TRICK!!!!!!!
If can only copy-paste following characters (including letters) in superscript and subscript. Do it in your Excel file.
I just ran into the same problem and came up with a quick and easy solution. Go to Tools, Customise Keyboard. Then select format, from here scroll down to the bottom where it has superscript and subscript. Here you can assign a new keyboard short cut for each. After many attempts to find a set of keys not already assigned to anything else, I found 'Option key with F5' works and 'Option key with F6'.
It is now quicker than if they where in the tool bar:) PS. I am running on a Mac. So your key selection may differ.