How to automatically correct spelling in Microsoft Excel

Maximize your work time on a spreadsheet. In today’s article we will tell you how to automatically correct spelling in Microsoft Excel in just a few steps.

When we do large jobs on an Excel workbook, we are very likely to make some spelling mistakes as we type. It is very tedious to have to look one by one to make it perfect.

And not only that, although Microsoft Office applications tell you when there is a spelling error, it may happen that you have unconsciously ignored some of them.

Luckily there is a way to automatically correct the spelling of everything you type in Microsoft Excel. Next, we will explain you step by step how you should do it.

However, before starting you should look for the latest available version of Office and download it from the store , or failing that, update the one you already have, because not all the features explained here come out as is in old versions.

How to select the words to automatically correct in Microsoft Excel

If you want to automatically correct your spelling in Microsoft Excel , just enter the workbook. Once inside, position yourself on one of the sheets from the tabs that you have at the bottom of the screen.

Next, you must select the part of the sheet that you want to correct. To do this, hold down the right mouse button while hovering over the section in question.

In case you want to select the whole sheet, you can press the Ctrl + E keys . If instead you prefer to correct particular cells, click on each of them while holding down the Ctrl key on your keyboard.

Once you’ve selected what you want to correct, let’s now scroll down to the Review tab The tabs are at the top of the screen. Next, you should look in this section for Spelling or Spell check , it will depend on the version you have. It is represented by the letters ABC and a tilde.

Or, you can choose a shortcut, pressing the F7 key to access Spelling. A text box will appear on the screen with all the words that have been corrected (as a recommendation, you should learn what the best Excel shortcuts are , to complement your information).

How to automatically correct spelling and grammar in Microsoft Excel

You can correct one by one with the suggestions that Excel offers you (that is, you can insert accents or accents , periods, and even correct whole words automatically). To do this, when you have found the correct suggestion, you must click on Change.

If you want to skip the error, click Skip once. The button is in the menu to the left of the box. Or by clicking Skip All to avoid correcting any spelling or grammar mistakes.

You can also add these words to the dictionary, so that errors stop appearing. You must bear in mind that only when you open the document on that desktop the error will not appear, while if you send it or open it on another computer they will continue to be.

As what we are looking for is to correct everything automatically, we are going to choose the AutoCorrect option from the menu on the left of the screen.

It will take you to a new box in which you must check what you want to correct:

  • Correct two capital letters in a row
  • Capitalize the first letter of a sentence
  • Capitalize the names of the days
  • Fix accidental use of Caps Lock
  • Replace text as you type

And to your right, you can also write the exceptions of those words that you do not want to correct themselves. To do this, click on Exceptions and type as many exceptions as you want. Or speed up writing by replacing letters with symbols from the Replace section.

As you can see, automatically correcting spelling errors in Excel is extremely simple, and best of all, you can save editing time by maximizing your writing method . If you have any questions about it, you can leave it in the comments so that we can help you as soon as possible.

Remember that in Miracomosehace.com we are publishing tutorials periodically to help you understand how to perform different procedures, such as filtering by date in an Excel table, or adding by categories in Excel, you can see how it is done by entering these links.

 

by Abdullah Sam
I’m a teacher, researcher and writer. I write about study subjects to improve the learning of college and university students. I write top Quality study notes Mostly, Tech, Games, Education, And Solutions/Tips and Tricks. I am a person who helps students to acquire knowledge, competence or virtue.

Leave a Comment