You can't set sub-cell formatting in a formula cell, as far as I know. You could use the Unicode character U+2093 (Latin Subscript Small Letter X: ₓ), which seems to render OK in Calibri or Arial (Excel 2010, Windows 7). There is a Unicode block dedicated to superscripts and subscripts.
I just realized this has the advantage of not changing the Excel row height as well. Bonus!
These subscripts can be included in formulas using the UNICHAR function and the UTF-16 decimal numerical code as an input eg UNICHAR(8336) will return a subscript lowercase a, and UNICHAR(8339) will return a subscript lowercase x. So for the formula in the question, you would use:
=IF(J3>J2,"l"&UNICHAR(8339)&" increased",IF(J3/J2-1>=devianceThreshold,"Deviance too high",""))
It looks like not all letters are available as subscript characters in this form, but if you want to look for all the possibilities you can do something like putting =UNICHAR(A1) in column b and put increasing numbers in column A and scroll through the outputs until you find a character in column b that you like best.
I am trying to figure out if there is a better shortcut for writing subscripts/superscripts into Excel on my Mac. As of right now the best shortcut option I have is ctrl + 1 and then selecting subscript or superscript. Surely there has to be a better way? Thanks
I have Excel for Mac version 16.79.2
ETA: I checked for questions similar to mine already in the subreddit, but they are all from years ago, and I am not sure if this is a newer issue. Also, I have already googled this issue, and all the answers seem to point to the ctrl + 1 solution. I just feel like there has to be a better way I am missing.
Hey all, I just have a super simple question. In the online Excel, how can I use subscript and superscript? In the local Excel client, it works with shortcuts and such but in the online, it's not working. I even tried copying the text from Word into the online Excel and it automatically reverts the sub or superscript. Any help is appreciated.
Hello Chris,
Welcome to Microsoft Community and thank you for posting your query.
Let me assist you with Excel superscripts and subscripts key board shortcuts.
You may try the following key board shortcuts and check if it helps.
• For superscript, select the text or number that you want, and then press Ctrl, Shift, and the Plus sign (+) at the same time.
• For subscript, select the text or number that you want, and then press Ctrl and the Equal sign (=) at the same time.
You may also refer to the following link which discusses about the similar issue and check if it helps.
http://answers.microsoft.com/en-us/office/forum/office\_2007-excel/how-to-create-custom-keyboard-shortcuts/9726911c-b74b-4c07-b531-ce940582911f
I hope the above information helps. Let us know if you need further assistance.
Thank you.
Dear Raju S DAs,
The shortcuts that you have described above work in Microsoft word, but not in Excel. Are there any shortcuts that can format the text as Subscript or Superscript in a cell in Excel?