contador web Saltar al contenido

How to customize Excel's AutoCorrect feature | Managers

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

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 Photo File tab: Reproduo / Daniel RibeiroClick on the Photo File tab: Reproduo / Daniel Ribeiro

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 RibeiroPress on Options Photo: Reproduo / Daniel Ribeiro

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 RibeiroIn the Text Review tab, click AutoCorrect Options Photo: Reproduo / Daniel Ribeiro

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 RibeiroIn the AutoCorreo tab there are the five main alternatives for configuring the system Foto: Reproduo / Daniel Ribeiro

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 RibeiroThe lower part of the AutoCorrection tab allows you to add or delete automatic correction terms Foto: Reproduo / Daniel Ribeiro

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 RibeiroIn the Automatic Mathematics Correction tab, you can add or delete shortcuts to symbols and mathematical operations Photo: Reproduo / Daniel Ribeiro

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 RibeiroThe Automatic Formatting on Typing tab has three more general configuration options for the spreadsheet Photo: Reproduction / Daniel Ribeiro

The Automatic Formatting on Typing tab has three more general configuration options for the spreadsheet Photo: Reproduction / Daniel Ribeiro