Exponent on Google Sheets
Pierr10 Posted messages 13775 Registration date Status Modérateur Last intervention -
Hello,
How can you put a superscript on Google Sheets? (on a Chromebook)
On a real PC, you can do it with the ASCII using Alt 0178 or 0179.
But on Chromebooks, there's no option to do that.
So right now I'm searching for superscripts on Google and then copying and pasting special.
I looked online and normally there should be an option with Format > Text > Superscript, but on an English Google.
When I look on mine, I don't see any superscript option, how can I do it please?
Do I need to add an extension?
Windows / Chrome 126.0.0.0
3 réponses
Hello,
On a "real" PC, ASCII combinations only work if there is a numeric keypad, which is not always the case.
Like in Google Docs, to test (I don't have Chrome OS and I'm not familiar with it)?
https://defkey.com/fr/google-docs-chrome-os-raccourcis-clavier
Hello,
There is no simple solution, as Google Sheets does not support subscripts and superscripts.
You might think of typing your expression with subscripts or superscripts in Google Docs (or elsewhere) and then copying and pasting it into Google Sheets: unfortunately, that doesn't work! The subscripts and superscripts become normal characters again.
The only solution is to fetch the superscripts and subscripts from the character map.
It's a bit tedious. It’s quicker to open a website that offers the subscripts and superscripts and do some copy-pasting.
So open this website at the same time as Google Sheets:
https://symbl.cc/en/collections/superscript-and-subscript-letters/
You can quickly access the subscripts and superscripts and copy them to paste into your spreadsheet.
What is well conceived is clearly stated,
And the words to say it come easily.
(Boileau)
And on a real PC without ASCII and copy-pasting, how do we access it in the Format > text menu, please?
It's hard to find the "solution" because superscripts or subscripts are only useful in a spreadsheet if they are literal text, and because the people who engage in this kind of manipulation make sure to buy a PC equipped with a numeric keypad or to purchase an external USB one.
You can find it everywhere, but I believe incorrectly the manipulation you mentioned, Format and Superscript or Subscript, because it only works in Google Docs.
An alternative is to create these characters in Google Docs either using those formats or the appropriate keyboard combinations, and then to copy and paste them.
You can also copy and paste them from the character map of a font, such as Segoe UI Symbol, but in limited quantity, or from any website displaying them.
The last option is the CHAR function in Google Sheets, but it's a bit of a tricky workaround since unless you memorize the few that you always use, you have to look up the corresponding code, and there's no guarantee that all formats exist.
https://www.benlcollins.com/spreadsheets/superscript-in-google-sheets/
Regarding your original question and these formats in Chrome OS without a numeric keypad, at least a certain number would be accessible by a combination like CTRL+SHIFT+U, but nothing indicates that this works only in Google Docs.
https://www.groovypost.com/howto/type-special-characters-chromebook-accents-symbols-em-dashes/
Thank you, I will try it on Monday.