Most valuable professional
  • Excel Book Excerpt

Excel Use AutoCorrect to Enable a Shortcut

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Use AutoCorrect to Enable a Shortcut

Problem: I work for John Jacob Jingleheimer Schmidt. It is frustrating to type this name continuously. How can I save time?

Strategy: You can set up an AutoCorrect entry to replace JJJS with John Jacob Jingleheimer Schmidt. Here’s how:

1. Select File, Options, Proofing, AutoCorrect Options or Alt+T+A.

2. On the AutoCorrect dialog, go to the AutoCorrect tab.

3. In the Replace section, type JJJS. In the With section, type the complete name. Click Add.

LE10000088.jpg 

Figure 116 Add your own shortcut as an AutoCorrect option.

Results: When you type JJJS in a cell, as shown in Figure 117, and then type a space or press Enter, Excel will replace your text with the complete text specified in the AutoCorrect list, as shown in Figure 118.

LE10000089.jpg 

Figure 117 Type the shortcut…

LE10000090.jpg 

Figure 118 …and a space to invoke the correction.

Additional Details: If you sometimes need to use the abbreviation and sometimes need to spell out the words, then set up JJJS> to be the shortcut for spelling out the words. Then, when you type JJJS, the initials will appear. When you type JJJS>, the words will appear.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: