Microsoft Excel is able to automatically correct several misspelled terms by mistake, thanks to the AutoCorreo feature. Thus, cells with a ", tdo" or nono "can be changed to sem, whole and ours, respectively. However, what appears to be an advantage, can hinder acronyms and abbreviations.
Integrated with the main software configurations, the AutoCorrect system can have some of its functions deactivated, as well as receive new terminology to correct. Check out how to access this tool in Excel and what are the main customization options that can be enabled or disabled in the following tutorial.
10 advanced Excel tips and tricks
Ready spreadsheets in Microsoft Excel to enjoy the holidays
Want to buy cell phones, TV and other discounted products? Meet Compare TechTudo
Step 1. With Microsoft Excel open, click on the File tab to access the menu with the software settings;
Click on the File tab Photo: Reproduo / Daniel Ribeiro
Step 2. In the File tab menu, select the option Options to open the window for controlling the main Excel settings;
Press on Options Photo: Reproduo / Daniel Ribeiro
Step 3. In the Site Options window, select the Text Review tab and click the AutoCorrect Options button to activate the customization of this system;
In the Text Review tab, click AutoCorrect Options Photo: Reproduo / Daniel Ribeiro
Step 4. In the first tab of the AutoCorrection window, there are four configuration options for control of uppercase letters and one with the terminological replacement;
In the AutoCorreo tab there are the five main alternatives for configuring the system Foto: Reproduo / Daniel Ribeiro
Step 5. At the bottom of the AutoCorrection tab, it is possible to delete or add items to the terminological repertoire so that the automatic corrections system follows this replacement ratio;
The lower part of the AutoCorrection tab allows you to add or delete automatic correction terms Foto: Reproduo / Daniel Ribeiro
Step 6. Still in the AutoCorrection window, in the Automatic Mathematics Correction tab, it is possible to check shortcuts to complex mathematical symbols and operations, as well as to add or remove new terms;
In the Automatic Mathematics Correction tab, you can add or delete shortcuts to symbols and mathematical operations Photo: Reproduo / Daniel Ribeiro
Step 7. In the Automatic Formatting on Typing tab, it is possible to configure the activation of three options: hyperlink control, the inclusion of rows and columns in the spreadsheet and the formula transposition system.
The Automatic Formatting on Typing tab has three more general configuration options for the spreadsheet Photo: Reproduction / Daniel Ribeiro