support.apu.edu

Using AutoCorrect in Microsoft Excel

Are there words that you consistently misspell, you can use AutoCorrect in Excel to automatically fix your mistakes. You can also create your own Auto Correct or Auto Update entries in Microsoft Excel. For example you can create an Autocorrect entry that when you type in *APU* it autocorrects to Azusa Pacific University. 

To do this in Microsoft Excel 2007 or Microsoft Excel 2010 - Go to the Office button (2007) or the File Menu (2010) Select Excel Options or Options

Excel 2007                                                                             Excel 2010

Screen_Shot_2014-02-24_at_3.50.53_PM.png     Screen_Shot_2014-02-24_at_4.08.08_PM.png

Select Proofing then click on the AutoCorrect Options... button

Screen_Shot_2014-02-24_at_3.52.05_PM.png

 

Type in the commonly misspelled word or other text that you would like to be replaced. In the "With:" section type the correctly spelled word. Then click on the Add button. You may add additional words or press OK

Screen_Shot_2014-02-24_at_3.52.55_PM.png

 

Microsoft Excel 2011 for Mac

Go to Excel on the menu bar then Preferences

Screen_Shot_2014-02-24_at_3.56.24_PM.png

 

Choose AutoCorrect

Screen_Shot_2014-02-24_at_3.56.36_PM.png

Enter the information:

You can click on Add then add additional entries or press OK

Screen_Shot_2014-02-24_at_3.57.02_PM.png

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Article is closed for comments.