Most Microsoft Excel users have noted that it is very frustrating to use superscript or subscript formatting in Microsoft Excel. Such formatting is not available on any toolbar or ribbon tab; even adding them there by customizing the toolbars/ribbon is not possible (on the Windows® version of Microsoft Excel). The only way to use superscript and subscript effects is to go through the Format Cells dialog each time you need to change the style.
There are several macros and add-ins available in the Internet that
try to solve this shortage of Microsoft Excel. Many simple macro-based
buttons allow only the whole cell to be formatted in
superscript or subscript, which is basically useless! Other popular
provide awful custom "edit dialog" with superscript and subscript
buttons. However, this kind of approach has poor usability
in daily use.
PanuWorld provides you an easy-to-use solution to this
problem: PanuWorld's unique ExcelSuperSubToolbar COM add-in adds
real Superscript and Subscript buttons on the
of Microsoft Excel. These buttons can be used to format not only entire
cells but also change the text style during in-cell editing (while
the cell contents, a.k.a. edit mode).
The new buttons work like the built-in Superscript and Subscript buttons in Microsoft Word and Microsoft PowerPoint®: For example, they reflect the text style of the current selection or insertion point. — The buttons work correctly with AutoShapes* with text and textboxes*, too!
Also, extra context menu buttons are available while you are editing cell contents, either directly or in the Formula Bar. This is a workaround for the fact that no buttons can be added on the floating Mini Toolbar. — Right-click with mouse or press the Menu key (or Shift+F10) on your keyboard to open the context menu.
You can also use keyboard shortcuts** to access the superscript and
subscript formatting while entering cell contents: Press Menu+E
to toggle superscript on/off and Menu+S to toggle subscript.
Microsoft Office Excel 2003: By default, the add-in adds the new Superscript and Subscript 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.
Microsoft Office Excel 2007: The add-in adds the new Superscript and Subscript (plus Strikethrough) 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) manually.
Microsoft Excel 2010 (and 2013?) (32-bit versions only): By default, the add-in adds the new Superscript and Subscript (plus Strikethrough) buttons on the Home tab of the ribbon between the Font and Alignment groups (see picture). If you wish, you can hide this button group and/or add them to any custom group on the ribbon using the ribbon customization mode or to the Quick Access Toolbar (QAT).
If you are using this add-in on Excel 2013, please send email and tell
if the add-in works or not!
If you are using a non-English version of Excel, you might like to change the button tooltips, context menu texts, and keyboard shortcuts so that they work properly in your language. This can be achieved simply by editing the file \Program Files (x86)\PanuWorld\ExcelSuperSubToolbar\ExcelSuperSubToolbar.ini with Notepad.
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 and Subscript buttons in Microsoft Word and use the same texts in Excel, too.
You can add a language just for your own fun but if you like you can
send your updated ExcelSuperSubToolbar.ini to firstname.lastname@example.org with
a short cover message.
To remove the Superscript and Subscript buttons from your Microsoft Excel, uninstall the add-in using Add/Remove Programs (Programs and Features) in the Windows Control Panel (and then delete any remaining toolbar buttons in Microsoft Office Excel 2003).
* Superscript and Subscript buttons work with shapes on Microsoft Office Excel 2003 only.
** Menu key is not working on Microsoft Office Excel 2003. The Menu key may be missing on some keyboards, too. Keyboard shortcuts may vary depending on the Excel user interface language.
This add-in has been tested on Microsoft Office Excel 2003, 2007 and Microsoft Excel 2010. It may work on other versions supporting 32-bit COM add-ins, anyway.
Microsoft, Excel, PowerPoint and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.