Microsoft Office: Modify auto-correct

By J. Carlton Collins, CPA

Q. Is there a way to turn off the auto-correct function for certain abbreviations or character strings in Outlook, Word, and other Office programs? For example, when I enter the ticker for Accenture, ACN, Word incorrectly autocorrects my entry to CAN.

A. Word's AutoCorrect function contains corrections for many commonly misspelled or mistyped words. You can remove a particular AutoCorrect setting in Word by selecting File, Options, Proofing, AutoCorrect Options, and in the resulting AutoCorrect dialog box, entering acn in the Replace box to find the unwanted entry, and then with the offending entry highlighted, clicking the Delete button, as indicated in the screen shot below.

This action will remove the unwanted Auto­-Correct setting for all Microsoft Office applications.

techqa-5

About the author

J. Carlton Collins (carlton@asaresearch.com) is a technology consultant, a CPE instructor, and a JofA contributing editor.

Note: Instructions for Microsoft Office in “Technology Q&A” refer to the 2007 through 2016 versions, unless otherwise specified.

Submit a question

Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to jofatech@aicpa.org. We regret being unable to individually answer all submitted questions.

VIDEO

Excel walk-through: Sparklines

Want to liven up your spreadsheets with some color and graphical elements? Kelly L. Williams, CPA, Ph.D., shows how to use Excel sparklines, which illustrate data trends and patterns via small charts that fit in a single Excel cell.

PODCAST

What’s next for potential CPA licensure changes

A new model proposed by NASBA and the AICPA is designed with an eye on the future for newly licensed CPAs. The AICPA's Carl Mayes, CPA, provides background on the project and a look ahead to 2020.