Unit 9. Spelling correction (I)

We are going to look at the Excel Autocorrect tool and how the program automatically corrects certain errors often made at the time of writing text into a worksheet, and how to manage the spelling correction in order to leave our worksheets free of errors and keep them as presentable as possible.


Configuring the autocorrection


This tool help us by automatically correcting the most habitual writing errors. To visualize and then be able to modify any of the autocorrection options assigned by default, follow these next steps:


Select the Tools menu.

Situate yourself over the button to extend its menu.

Select the Autocorrect options... option.



menú Herramientas - Opviones de Autocorrección...

The Autocorrect dialog box seen below will appear.

If you activate the Correct TWo INitial CApitals box, this permits that when writing a word the first two letters appear in uppercase and the rest in lowercase. This is a frequent mistake made when writing, and its probably a good idea to leave it activated.

If you activate the Capitalize first letter of sentences, Excel checks at the time of writing a sentence that the first letter is a capital, and if not automatically changes it. If we write the entire sentence in capital letters it will not be changed. It is also best to leave this option activated.

If we activate the Capitalize names of days, then when Excel comes across a word corresponding a day of the week it will automatically make the first letter a capital letter. This option is not always in our interest to have activated.

If we activate the Correct accidental use of cAPS LOCK key, then if Excel comes across a word with the first letter in lowercase and the rest of the word in capitals it deduces that the CAPS LOCK key was activated by accident, and automatically corrects the text and deactivates the key. It is best left activated.

The Replace text as you type option activates the list of subtitutions in the bottom part of the dialogue box, where many of the common elements to substitute are found, and in this way Excel replaces the text that coincides with any in the column on the left for the text that appears in the column to the right.

If you want to add some element to the list it will be enough to write the frequent error that we want automatically corrected in the Replace: box, then in the With: box write the correction to perform, and clic on OK.


If you want to delete some element from the list select it from the list and clic on the Delete button.

And finally, when we have configured the autocorrection box we clic on the OK button to accept the changes and close the dialogue box.




Page 9.1

Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited.