1

How to subscript or superscript in Google Sheets? The Doc's shortcut (ctrl+, / ctrl+.) is not working there.

2

It looks like Google Sheets doesn't offer this formatting option; it's limited to bold/italic/underline/strikethrough.

Your best bet is to use Unicode superscript/subscript characters, but not all of them are available. This Stack Overflow answer lists a couple of them, though whether they render correctly may depend on your OS and browser:

Consolidated for cut-and-pasting purposes, the Unicode standard defines complete sub- and super-scripts for numbers and common mathematical symbols ( ⁰ ¹ ² ³ ⁴ ⁵ ⁶ ⁷ ⁸ ⁹ ⁺ ⁻ ⁼ ⁽ ⁾ ₀ ₁ ₂ ₃ ₄ ₅ ₆ ₇ ₈ ₉ ₊ ₋ ₌ ₍ ₎ ), a full superscript Latin lowercase alphabet except q ( ᵃ ᵇ ᶜ ᵈ ᵉ ᶠ ᵍ ʰ ⁱ ʲ ᵏ ˡ ᵐ ⁿ ᵒ ᵖ ʳ ˢ ᵗ ᵘ ᵛ ʷ ˣ ʸ ᶻ ), a limited uppercase Latin alphabet ( ᴬ ᴮ ᴰ ᴱ ᴳ ᴴ ᴵ ᴶ ᴷ ᴸ ᴹ ᴺ ᴼ ᴾ ᴿ ᵀ ᵁ ⱽ ᵂ ), a few subscripted lowercase letters ( ₐ ₑ ₕ ᵢ ⱼ ₖ ₗ ₘ ₙ ₒ ₚ ᵣ ₛ ₜ ᵤ ᵥ ₓ ), and some Greek letters ( ᵅ ᵝ ᵞ ᵟ ᵋ ᶿ ᶥ ᶲ ᵠ ᵡ ᵦ ᵧ ᵨ ᵩ ᵪ ). Note that since these glyphs come from different ranges, they may not be of the same size and position, depending on the typeface.

0

SUPERSCRIPT characters:

  • you can either use this generator: https://lingojam.com/SuperscriptGenerator
  • or one of these CHAR codes:

    • A =CHAR(7491)
    • B =CHAR(7495)
    • C =CHAR(7580)
    • D =CHAR(7496)
    • E =CHAR(7497)
    • F =CHAR(7584)
    • G =CHAR(7501)
    • H =CHAR(688)
    • I =CHAR(7588)
    • J =CHAR(690)
    • K =CHAR(7503)
    • L =CHAR(737)
    • M =CHAR(7504)
    • N =CHAR(8319)
    • O =CHAR(7506)
    • P =CHAR(7510)
    • R =CHAR(691)
    • S =CHAR(738)
    • T =CHAR(7511)
    • U =CHAR(7512)
    • V =CHAR(7515)
    • W =CHAR(695)
    • X =CHAR(739)
    • Y =CHAR(696)
    • Z =CHAR(7611)
    • 0 =CHAR(8304)
    • 1 =CHAR(185)
    • 2 =CHAR(178)
    • 3 =CHAR(179)
    • 4 =CHAR(8308)
    • 5 =CHAR(8309)
    • 6 =CHAR(8310)
    • 7 =CHAR(8311)
    • 8 =CHAR(8312)
    • 9 =CHAR(8313)
    • + =CHAR(8314)
    • - =CHAR(8315)
    • = =CHAR(8316)
    • ( =CHAR(8317)
    • ) =CHAR(8318)

SUBSCRIPT characters:

  • you can either use this generator: https://lingojam.com/SubscriptGenerator
  • or one of these CHAR codes:
    • A =CHAR(8336)
    • E =CHAR(8337)
    • I =CHAR(7522)
    • O =CHAR(8338)
    • R =CHAR(7523)
    • U =CHAR(7524)
    • V =CHAR(7525)
    • W =CHAR(7525)&CHAR(7525)
    • X =CHAR(8339)
    • Y =CHAR(7527)
    • 0 =CHAR(8320)
    • 1 =CHAR(8321)
    • 2 =CHAR(8322)
    • 3 =CHAR(8323)
    • 4 =CHAR(8324)
    • 5 =CHAR(8325)
    • 6 =CHAR(8326)
    • 7 =CHAR(8327)
    • 8 =CHAR(8328)
    • 9 =CHAR(8329)
    • + =CHAR(8330)
    • - =CHAR(8331)
    • = =CHAR(8332)
    • ( =CHAR(8333)
    • ) =CHAR(8334)

fraction characters:

  • 1/4 =CHAR(188)
  • 1/2 =CHAR(189)
  • 3/4 =CHAR(190)
  • 1/3 =CHAR(8531)
  • 2/3 =CHAR(8532)
  • 1/5 =CHAR(8533)
  • 2/5 =CHAR(8534)
  • 3/5 =CHAR(8535)
  • 4/5 =CHAR(8536)
  • 1/6 =CHAR(8537)
  • 5/6 =CHAR(8538)
  • 1/8 =CHAR(8539)
  • 3/8 =CHAR(8540)
  • 5/8 =CHAR(8541)
  • 7/8 =CHAR(8542)

spreadsheet containing first 174000 characters

  • row number = CHAR code
  • tofu 𚯵 character = given font does not support such character
  • To use these 'Char' wouldn't i have to keep referring the character code? This might become a tough task. – Alex Jul 3 at 21:18
  • not sure what you mean by "referring"... if you mean this: ="H"&CHAR(8322)&"O" then yeah > H₂O – user0 Jul 3 at 21:23
  • Yeah. I mean the numbers that are inside the brackets. I am new to these reference numbers. So I might need to mug up them to use quickly. – Alex Jul 3 at 21:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.