Microsoft Office Tutorials and References
In Depth Information
Five Excel Oddities
in which Jim allegedly put a macro on Dwight s computer that auto-
matically changed the typed word Dwightto Diapers. However, this
doesn t require a macro. From Excel Options, choose the Proofing
Category and then click the AutoCorrect Options button. On the
AutoCorrect tab, you can type new correction pairs. In this example,
you would type Dwight
Diapers into the With
box. The next time someone types Dwightand then a space, the word will
automatically change to Diapers. You can also remove correction
pairs by selecting the pairs and then pressing Delete. For example, if
you hate that Microsoft converts (c) to ©, you can delete that entry
from the list.
Dwight into the Replace box and Diapers
Search JabSto ::

Custom Search