See all Microsoft Excel tips
Strategy: Set up an AutoCorrect entry to replace JJJS with John Jacob Jingleheimer Schmidt.
From the menu, select Tools – AutoCorrect options. In the Replace section, type JJJS. In the With section, type the complete name, click Add, as shown in Fig. 150.
Result: Typing “JJJS”, as shown in Fig. 151, will cause the just the replacement word to appear. After typing a Space or hitting Enter to finish the cell, “JJJS” will change to the complete name, as shown in Fig. 152.
Summary: Using Tools – AutoCorrect and adding a shortcut for a long or difficult word will cause AutoCorrect to fill it in for you.
Commands Discussed: Tools – AutoCorrect Options
See all Microsoft Excel tips