logo elektroda
logo elektroda
X
logo elektroda

How to Write Superscript (e.g., x²) in Excel Cell Names Without Calculation

damian20 72971 6
ADVERTISEMENT
Treść została przetłumaczona polish » english Zobacz oryginalną wersję tematu
  • #1 1381362
    damian20
    Level 15  
    Hello
    I have a question whether in Excel, as in Word (upper index), you can insert somehow in the names this "upper index" regarding, for example, a potent so that you can write something squared but I do not mean calculating powers, but writing
    I omit the ways of pasting characters from Word, etc., only how can it be done with only Excel open
  • ADVERTISEMENT
  • #2 1381396
    aren
    Level 28  
    I do not have Excel, but in the word it is done by pressing ctrl shift + (plus sign) and the subscript ctrl + (plus sign) may also work :)
  • ADVERTISEMENT
  • #3 1381460
    damian20
    Level 15  
    It doesn't even work out for me
  • #4 1381466
    yogibear07
    Level 16  
    For example, you write x, then press the right button on this cell and select "format cell" and then select the top index under the font tab and enter 2. And so you get x squared :)
  • ADVERTISEMENT
  • #5 1381541
    aren
    Level 28  
    it does not work for you because you must press the plus from the numeric keypad and this is supposed to be the plus which is next to the backspace
  • ADVERTISEMENT
  • #6 1382219
    bobo
    Level 29  
    yogibear07 wrote:
    For example, you write x, then press the right button on this cell and select "format cell" and then select the top index under the font tab and enter 2. And so you get x squared :)

    Cell should be in / Numbers / Text format
    Greetings
  • Helpful post
    #7 1382234
    yogibear07
    Level 16  
    bobo wrote:
    yogibear07 wrote:
    For example, you write x, then press the right button on this cell and select "format cell" and then select the top index under the font tab and enter 2. And so you get x squared :)

    Cell should be in / Numbers / Text format
    Greetings


    Not necessarily. You can leave it as it is, i.e. general and not define the format.

Topic summary

In Excel, users can insert superscripts (upper index) for text formatting, similar to Word. To achieve this, one method involves writing the desired character (e.g., "x"), right-clicking the cell, selecting "Format Cells," and then choosing the superscript option under the Font tab. Alternatively, users can utilize keyboard shortcuts, specifically pressing Ctrl + Shift + + (plus sign) for superscript and Ctrl + + (plus sign) for subscript, although success may depend on the keyboard used. It is noted that the cell format can remain as General without needing to switch to Text format.
Summary generated by the language model.
ADVERTISEMENT