You can add or remove words from the list (more on this in an example below). That is because it has been specified in the list in this option. For example, if you type (c), it automatically gets converted into the copyright symbol. Replace text as you type: This is where Excel already has some commonly misspelled words (or shortcodes for some symbols).For example, if you enter hELLO, it will automatically change it to Hello. Correct accidental use of Caps lock key: In case you have the Caps lock on and you write a sentence, it will automatically correct the text and disable the Caps lock.For example, wednesday would be changed to Wednesday. Capitalize names of days: This will automatically change the first letter of the day name if you enter in lowercase.how are you?’, it will be autocorrected to ‘Hello. Capitalize first letter of sentences: When enabled, this option ensures that a new sentence starts with a capital letter.For example, if you type ‘HEllo’, it will automatically change it to ‘Hello’ Correct two initial capitals: This option when enabled will automatically correct the two capital initials in Excel.When this option is enabled, you see the autocorrect options in MS Word or MS PowerPoint (as shown below). Show Autocorrect Options buttons: This one is not relevant for Excel but it is for other MS applications.In the Autocorrect Options tab, there are some options that are enabled by default and take care of some common issues. Let me explain the different tabs in the Autocorrect dialog box and the options in these. This will open the Autocorrect Options dialog box. In the Proofing options, click on the Autocorrect Options. In the Excel Options dialog box, click on Proofing.
To get the autocorrect options, click on the File tab. It also allows you to get some more control when using Excel (as we will see in the examples later in this tutorial).īut let’s first understand where are the autocorrect options and what is available by default.
How to Undo Autocorrect Changes in ExcelĪutocorrect was created to help you iron out small issues you may face while typing in Excel or while doing data entry (such as replacing some commonly misspelled words with correct words).How to Disable/Replace Some Words from Getting Autocorrected.
Example 3: Write Formulas Faster with Autocorrect.Example 2: Insert Symbols Quickly (such as Degree or Delta).Example 1: Use Autocorrect to Complete Abbreviations.How to Add Your Own Words to Excel Autocorrect?.
0 kommentar(er)
