Difference between revisions of "Documentation/FAQ/Calc/Formatting/How do I insert superscript or subscript text in my spreadsheet?"
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Formatting
(New page: {{DISPLAYTITLE: How do I insert superscript or subscript text in my spreadsheet?}} <section begin=question/> '''How do I insert superscript or subscript text in my spreadsheet?''' <sectio...) |
m |
||
Line 10: | Line 10: | ||
#* Click on the cell with the text | #* Click on the cell with the text | ||
#* At the input line above the spreadsheet, select the characters to be altered | #* At the input line above the spreadsheet, select the characters to be altered | ||
− | # Select | + | # Select {{menu|Format|Character}} from the menu |
# Click on '''Font Position''' | # Click on '''Font Position''' | ||
− | # Click '''Superscript''' or '''Subscript'''. You can optionally change the character reduction ratio but usually the default value will work fine. | + | # Click '''Superscript''' or '''Subscript'''. You can optionally change the character reduction ratio, but usually the default value will work fine. |
Line 19: | Line 19: | ||
#* Click on the cell with the text | #* Click on the cell with the text | ||
#* At the input line above the spreadsheet, select the characters to be altered | #* At the input line above the spreadsheet, select the characters to be altered | ||
− | # For Superscript, press | + | # For Superscript, press {{key|CTRL|SHIFT|P}}<br>For Subscript, press {{key|CTRL|SHIFT|B}} |
− | + | Notes: | |
* Cell height may require an adjustment to accommodate the new character. | * Cell height may require an adjustment to accommodate the new character. | ||
* These commands also work for the word processor. | * These commands also work for the word processor. |
Latest revision as of 16:40, 16 May 2021
How do I insert superscript or subscript text in my spreadsheet?
Using the Menu
- Select the individual character(s) to be made superscript/subscript:
- Click on the cell with the text
- At the input line above the spreadsheet, select the characters to be altered
- Select Format → Character from the menu
- Click on Font Position
- Click Superscript or Subscript. You can optionally change the character reduction ratio, but usually the default value will work fine.
Using the Keyboard
- Select the individual character(s) to be made superscript/subscript:
- Click on the cell with the text
- At the input line above the spreadsheet, select the characters to be altered
- For Superscript, press CTRL + ⇧ Shift + P
For Subscript, press CTRL + ⇧ Shift + B
Notes:
- Cell height may require an adjustment to accommodate the new character.
- These commands also work for the word processor.