Superscript and subscript buttons for Excel 2003/2007/2010/2013/2016
Office Excel 2003: By default, the add-in adds the
new Superscript, Subscript, and Symbol Font buttons
on the Formatting
toolbar between the Underline and Align Left
buttons (see picture). If you wish, you can copy or move them to any
toolbar using the toolbar customization mode. If you accidentally
delete those buttons, just restart Microsoft Excel to recreate them.
Office Excel 2007: The add-in adds the new Superscript, Subscript,
and Symbol Font buttons on the Home
tab of the ribbon between the Font and Alignment groups.
If you wish, you can add them also the Quick Access Toolbar (QAT)
Excel 2010, 2013, and 2016: By default, the
add-in adds the new Superscript, Subscript, and Symbol
Font buttons on the Home
tab of the ribbon between the Font and Alignment groups
(see picture below). If you wish, you can hide this button group and/or
them to any custom group on the ribbon using the ribbon customization
mode or to the Quick Access Toolbar (QAT).
new buttons do not work when editing
text in text boxes and shapes (including texts on Excel charts) from
Microsoft Office Excel 2007 to Microsoft Excel 2016 version 1703.
However, there are rarely known built-in keyboard shortcuts
for superscript and subscript when editing charts and text boxes —
actually the same as in Microsoft PowerPoint: try the + key of
the main keyboard with Ctrl and Ctrl+Shift.
Accessing cell formatting during 3D selection makes Microsoft
Excel unstable. Therefore these add-in buttons and keyboard shortcuts
are disabled if multiple
worksheets are selected at the same time. Do not worry, they will be
re-enabled when you enter the edit mode!
Undo is possible only for the most recent Superscript /
Subscript / Symbol Font operation. It is not possible to undo older
changes after using any of the functions provided by this add-in.
Starting from Microsoft Excel 2016 version 1704 (released only
Office 365 subscribers in May 2017), Superscript and Subscript buttons
and corresponding keyboard shortcuts of this add-in work without
any of these limitations.
If you have enabled multiple input languages and/or keyboard layouts
(usually you see the language indicator on the Windows Taskbar in that
case), some keyboard shortcuts (e.g. Ctrl+=
) may not work on
Excel (or in other Office applications). The default key combinations
for switching languages and keyboard layouts might be the reason for
that. Try disabling those key sequences:
- Open text input control panel by pressing Windows+R,
typing control.exe input.dll and clicking OK.
- If necessary, in the advanced settings, click the link Change
language bar hot keys..., which opens the Text
Services and Input Languages dialog.
- Change the key settings by clicking Change Key Sequence...
button and disabling both key sequences there.
If this does not help, consider removing all extra input languages from
the text input control panel leaving only the one your are actually
using. That will help for sure.
If you are using a non-English version of Excel, you might
like to change the button tooltips and context menu texts so that they
work properly in your language. This can be
achieved simply by editing the file \Program Files
Detailed information about adding new languages can be found in the
file itself. For consistency, it is recommended to check the texts
related to the Superscript, Subscript, and Symbol
Font functions in
Microsoft Word and use the same
texts in Excel, too.
You can add a language just for your own fun but if you want to help
send your updated ExcelSuperSubToolbar.ini to email@example.com with
a short cover message.
If you do not like to default keyboard shortcuts, you may try to
changing them by editing the ExcelSuperSubToolbar.ini, too.
Note that only the last character counts in the shortcut string:
pressing Ctrl (and possibly Shift, depending on the
chosen character) is implied by the add-in.
To remove the buttons from
your Microsoft Excel, uninstall the add-in using Add/Remove Programs
(Programs and Features) in the Windows Control Panel.
- 1.5.1 (1.2.2018)
- Fixed issue of version 1.5 preventing editing/viewing cell
comments if the add-in was enabled. Replaced custom routines with the
built-in superscript/subscript functions removing all limitations of
those features on this add-in (when used on Excel 2016 version 1704 or
- 1.5 (30.1.2018)
- Enabled Undo also when formatting complete cells (i.e.
not in edit mode). Disabled add-in functions
during 3D selections (except in edit mode) to avoid interference.
Changed to "standard" keyboard shortcuts Ctrl++ (superscript)
and Ctrl+= (subscript) because other shortcuts exist for their
original functionality. Updated Bulgarian
- 1.4.2 (28.4.2017)
- New shortcut Ctrl+. for subscript to avoid problems on
Excel 2016 with some keyboard layouts (like FI). Included keyboard
shortcut hints in the translatable strings to allow e.g. German Strg+Umschalt+Q
instead of Ctrl+Shift+Q.
- 1.4.1 (1.2.2016)
- Fixed problem of ribbon buttons and shortcuts not working on
Excel 2013 (again). My mistake. Sorry for that.
- 188.8.131.52 (1.1.2016)
- Added Danish and German translations. No changes in the add-in
- 1.4 (4.12.2015)
- New button: Symbol Font. Implemented real keyboard
shortcuts Ctrl+? (superscript), Ctrl+= (subscript), and
Ctrl+Shift+Q (Symbol Font).
- 1.3 (8.9.2015)
- Added tricks necessary for proper operation on Excel 2013's SDI.
- 184.108.40.206 (28.8.2014)
- Added Bulgarian and Spanish translations. No changes in the
- 220.127.116.11 (12.8.2013)
- Included a library file needed for Excel 2013 compatibility.
Thanks Luis for pointing this out. No changes in the add-in
- 18.104.22.168 (29.6.2013)
- Added Finnish and Italian translations. No changes in the add-in
- 1.2.2 (10.5.2013)
- Added support for different user interface languages. Changed
keyboard shortcut for Subscript to avoid conflict with Expand
Formula Bar menu item.
- 1.2.1 (23.4.2013)
- Fixed ribbon button problems (superscript and subscript
constantly disabled) on non-English Microsoft Excel and/or Windows.
Thanks Holger for testing.
- 1.2 (19.4.2013)
- Added support for the ribbon of Microsoft Office Excel 2007 and
later. Included buttons in the Formula Bar context menu, too.
- 1.1.4 (14.1.2011)
- Fixed superscript/subscript buttons appearing initially enabled
if Microsoft Excel is started without a workbook (e.g. by
double-clicking on a Microsoft Excel add-on).