{"id":391,"date":"2011-10-10T20:40:44","date_gmt":"2011-10-10T20:40:44","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=391"},"modified":"2023-12-30T23:13:36","modified_gmt":"2023-12-30T23:13:36","slug":"excel-2010-autocorrect-options","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/excel-2010-autocorrect-options\/","title":{"rendered":"Excel 2010: AutoCorrect Options"},"content":{"rendered":"<p>AutoCorrect entries simply replace a text error or shortcut with the correct or longer version. For example, typing &#8220;teh&#8221; will automatically correct to &#8220;the&#8221;. This feature has a long list of entries which you may wish to change, remove or add to.<\/p>\n<p>Select the <strong>File<\/strong> tab, <strong>Options<\/strong> and go to the <strong>Proofing<\/strong> tools page. Click on <strong>AutoCorrect Options<\/strong> to see the dialog box and list, and the <strong>Replace<\/strong> and <strong>With<\/strong> boxes to add your own. Whatever is typed in the Replace box in the future will be automatically changed to your With entry, unless you switch the feature off with the <strong>Replace Text As You Type<\/strong> check box half way down the page.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/AutoCorrect.jpg\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-392\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/AutoCorrect.jpg\" alt=\"AutoCorect list\" width=\"412\" height=\"404\" \/><\/a> If this feature is left switched on, certain <strong>Exceptions<\/strong> can be added to the rules with the button on the right, as these examples show.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/ACExceptions.jpg\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-393\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/ACExceptions.jpg\" alt=\"AutoCorrect Exceptions\" width=\"362\" height=\"235\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>AutoCorrect entries simply replace a text error or shortcut with the correct or longer version. For example, typing &#8220;teh&#8221; will automatically correct to &#8220;the&#8221;. This feature has a long list of entries which you may wish to change, remove or add to. Select the File tab, Options and go to the Proofing tools page. Click [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[60,173,376,397],"class_list":["post-391","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-autocorrect","tag-excel-2010","tag-mjw","tag-office-shortcuts"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=391"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/391\/revisions"}],"predecessor-version":[{"id":6770,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/391\/revisions\/6770"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}