A tip of using AutoCorret to input names quickly

This is a simple tip that most secretaries and executive assistants love. 🙂

Excel Tips - AutoCorrect0.gif

Did you ever look up someone’s full name in Outlook or email directory?  It happens especially if you are working in a multi-national company and you are working with people from around the world.  Some foreign names are really difficult to spell.  Right?

So why not we input them into AutoCorrect and let Excel/Word/PowerPoint to remember the spelling and type it lightening fast for us?  Isn’t it nice if we just need to input the initials?  

This magic is simply the AutoCorrect.

Go to File –> Option –> Proofing –> AutoCorrect Options

Excel Tips - AutoCorrect.JPG

On the “AutoCorrect” tab, input the short-form you want, and the corresponding replacement intended.

Excel Tips - AutoCorrect1.JPG

Tip: Suggest to put a special character as prefix.  In my example, I used underscore (_) so that AutoCorrect only changes “_as” but not “as” to “Anakin Skywalker”.

Repeat the above steps for different initials and names

Excel Tips - AutoCorrect2.JPG

When done, press OK.

As simple as this. 🙂

Note: AutoCorrect applies to different Office programmes like Word and PowerPoint.



How do you use AutoCorrect to speed up your work?  Please share with us by leaving your comments.




About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.