See all characters in font set

  1. Enter =CHAR(ROW()) in row 1
    1. =ROW() return the row you're in. =ROW() entered in cell G23 returns 23.
    2. =CHAR(97) returns the 97th character in the character set for that font, usually a lowercase "a" (picture fonts like Wingdings or Webdings return something else).
  2. Fill down to row 255.
  3. Easy to see things like ●, ¢, £:
Book image
  1. When you see that "●" is in row 149, you can then know that holding Alt while typing 0149 on the numeric keypad will create this character as soon as you let go of the Alt key! And this holds true for all of Office, not just Excel! You can copy/paste special characters for the character(s) you want, and you can then copy the resulting character from the formula bar.

Tip 74: Bringing the selection into view

It's possible you've selected some areas of cells and the scrolled away so you can't see it any more. CTRL/Backspace brings that selection into view, and shift/Backspace brings selection into view as well but reduces the selection to the active cell. So, if this is the before picture:
Book image

Then shift/backspace will simply have cell B3 selected.