Allow CTRL+ and CTRL SHIFT + to set superscript and subscript
All of the other office applications support this function. Hold down CTRL and + and you get subscript, hold down CTRL, Shift and + you get superscript. While not too many people know this, for those of us in the chemical fields, these shortcuts are indispensable. Excel already supports the basics of bold, italic, etc. Please expand it to include these.
Thanks to Jeffrey for suggesting the shortcut keys to format text as subscript or superscript. I can see that this would be useful and consistent with the other applications. As with all the requests, voting helps move the request up in our priority list, so keep the votes coming if this is important to you.
Steve K (Microsoft)
If you are using Office 365, CTRL+ is false. Apparently, Microsoft eliminated this keyboard shortcut. That is the big mistake, I wish Microsoft would put that shortcut back on.
YES, I very much need this shortcut to type chemical formulas
John Peloquin commented
This should be the default. The table of keyboard shortcuts should also be user-configurable; if it was, this and other unfortunate shortcut choices would be less of a problem.
If you are on Office 365 and already have the built-in superscript and subscript buttons on Excel (released in May 2017), my add-in just adds the standard keyboard shortcuts (Ctrl++ and Ctrl+=) to them. It is designed just for this purpose to avoid bloating the Excel UI with even more functionality and possibly slowing it down.
This is a one way to go before real built-in shortcuts are available:
http://www.panuworld.net/utils/excel/ (I am sorry, only 32-bit Excel supported)
(For "Excel less than version 1704" users the add-in also adds the ribbon/toolbar buttons for Superscript and Subscript.)
Excel Team = lazy and ignorant.
GOOD JOB GUYS! DON'T LET GO!
Yes, this is needed. It's good to see the ribbon buttons are now being added (as of 10 May 17), but the Shortcut keys are still needed for:
# Large jobs & keyboarders - particularly when there is a large amount of subscript/superscript to do, shortcuts are the most efficient method by far
# Save mouse clicks - for those with hand/arm repetitive strain type injuries like me (or whatever they call RSI now)
# consistency through Office apps.
I downloaded an Addon for it before my laptop crashed. Now this is again the first thing I get stuck with in Excel. Fix it Microsoft!
Those in the engineering fields would appreciate superscript and subscript shortcuts as well... I remember being a teenage in high school and wanting this feature. I completed 10 years of academic studies before this feature was implemented in Excel. I can't really see any unwanted side-effect in implementing this... So, please just do it!
Paul Skaar commented
Sad that Excel is so far from common usage on subscript and superscript control keys...makes me want to find another app...
Gareth Hayter commented
Until Microsoft adds the buttons to Excel, the FormulaDesk add-in adds them for you (works with Excel 32 bit and 64 bit): https://www.formuladesk.com/productivity-tools
The keyboard shortcuts are:
Excel needs Subscript and superscript!!!
Ryan I completely agree, please ensure CTRL +, for inserting, and CTRL -, for deleting, cells, rows and columns remains functional if the superscript/subscript functionality is implemented.
ALT codes are very handy for for common superscript/subscript characters. IE ALT+248=°, ALT+0179=³, ALT+0178=², etc.
Drives me crazy to open the full menue every time
Strongly agree with Ryan
I also want subscript and superscript shortcuts, but please don't break Ctrl + for inserting rows, columns, and cells. I use it 50 times a day.
Ctrl Plus should make a superscript ONLY when I am editing a formula or text. Ctrl Minus or Ctrl Shift Plus should make a subscript when I am editing text.
I wondered why it is so hard to use these functions in Excell since I use this software :) So hopefully soon we will have shortcuts for these :)
Kenneth Barber commented
Yeah, superscripting and subscripting are a pain in Excel. I don't know how many times I've come across m3 (cubic meters) or CO2 (carbon dioxide). Of course, in those cases, it is best to use the superscript/subscript characters rather than the formatting.