logogugl.blogg.se

If you selected the Capitalize first letter of sentences check box, and you want to prevent AutoCorrect from capitalizing words that follow certain abbreviations (such as "appt."), click the First Letter tab. To delete a word, select the word and click Delete. To add a word to the exception list, type the word in the box and then click Add. If you selected the Correct TWo INitial CApitals check box, and you want to prevent AutoCorrect from correcting a specific word that contains mixed uppercase and lowercase letters (such as "IDs"), click the INitial CAps tab. On the AutoCorrect tab, click Exceptions, and then do one of the following: The exceptions that you set apply across all the Office programs that support the AutoCorrect feature, which means that any change you make to this list in one program also affects the other programs. You can specify exceptions to a few of the capitalization rules. Select or clear any of the following check boxes: You can enable or disable various options for automatically correcting capitalization on the AutoCorrect tab. Click a heading below to expand it and see the instructions: You can do the following things on this tab of the dialog box. If you don't like the AutoCorrect Options button that appears while you're typing, you can use this dialog box to turn it off: Clear the check box next to Show AutoCorrect Options buttons. Use the options in this dialog box to turn off or alter anything you don't like.

By default, AutoCorrect uses a standard list of typical misspellings and symbols, but you can modify the entries in this list.īy default, Excel is set up to automatically correct some common typing mistakes. You can use the AutoCorrect feature to correct typos, capitalization errors, and misspelled words, as well as automatically insert symbols and other pieces of text. To jump quickly to the information you want, click the name below that corresponds to the tab you want help on:ĪutoCorrect | AutoFormat As You Type | Actions | Math AutoCorrect AutoCorrect There are four tabs in the AutoCorrect dialog box. Use this dialog box to turn off or turn on any auto-correction or auto-formatting features in Excel. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel Starter 2010 More.