Method 3 – Apply Keyboard Shortcut Select cellC6. Highlight3in theFormula Bar. PressCtrl + 1to openFormat Cells. PressAlt + BforSubscript. ClickOK. Repeat for “–” andSuperscript. If you have followed the steps correctly, your dataset will look like this. Method 4 – From Quick Acce...
6. Using CHAR Function in Google Sheets As mentioned, Google Sheets will not have superscript/subscript options as part of text formatting menu. Unfortunately, alt code shortcuts also will not work properly in Sheets. In this case, you can use CHAR function to insert subscript and superscript ...
Note: If the Developer tab is not available in your Excel ribbon, use the keyboard shortcut Alt + F11 to open the Visual Basic Editor window.After selecting the Module option, a window called Module1 will appear.Insert the following code in the module and click the Save button....