Superscript Text

Question

How do I use CTRL-H to change the "st" in a cell&nbsp; - i.e. "1st issue" to superscript?

olaf hubel · Answer

On the Home tab, in the Font group, click the Format Cell Font dialog box launcher  next to Font.

Keyboard shortcut&nbsp;&nbsp;You can also press CTRL+SHIFT+F or CTRL+1 to quickly display the Font tab of the Format Cellsdialog box.

Under Effects, select the Superscript or Subscript check box.

deleted · Answer

Sorry, does not solve the problem I posted. Your solution superscripts the entire cells contents. I'm looking for a hot key solution like CTRL-H to make 2 characters in a cell of many characters superscript.

olaf hubel · Answer

You are able to select just the two latter ST or RD, .. and make them superscript in a cell this way too.&nbsp;

deleted · Answer

I tested your suggestion and it does work even though when you select the letters you want to superscript, they are not highlighted. But this solution is the "manual" method of changing the desired letters to superscript for "one cell" only. The keystrokes needed have to be used for every cell you want to change.&nbsp;With CTRL-H, you enter what you want to change, select Find All, then select Replace All and your are done. This "automatic method" is great when you need to change several thousands cells. Unfortunetly, when you select Format, Superscript for the Replace With data, it superscripts the "whole cell", not just the 2 letters you enter in the Replace With box.

Forum Discussion

Superscript Text

4 Replies

Resources