How to Use Spell Check in Excel

In this video, you'll learn how to use Spell Check in Excel.

Here are the two ways you can access Spell Check in Excel:
-- Go to Review Tab and Click on Spellings
-- Press F7 Key from the keyboard

There are many options available in the Spell Check Dialogue Box:
-- IGNORE ONCE: If spell check encounters a word it identifies as an error, but you want to keep it that way, you can click on Ignore Once. This will ignore that error once.

-- IGNORE ALL: If excel identifies a word as error, but you want to keep all instances of that word (as is), click on Ignore All.

-- ADD TO DICTIONARY: If Excel flags a word as error but it is the correct word to be used (maybe it’s a name or abbreviation that you use in your company), then you can add it to the dictionary. When such a word is flagged as error and you click on Add to Dictionary, Excel will make that a part of acceptable words and won't flag it again. Note that this word is now part of Excel dictionary and would never be flagged in any of the workbooks.

-- CHANGE: When Excel highlights an error, it also shows some suggestions (for example it suggests Good in place of Goood). There can be one or more that one suggestion. Select the suggestion that you want to use and click on Change to apply that.

-- CHANGE ALL: If you click on this button, it will change all the occurrence of the misspelled word with the selected suggestion.
AutoCorrect: This option will change the misspelled word with the selected suggestion, and also add it to the auto correct list. This means, that next time you type the same misspelled word, excel would automatically convert it into the suggestion that you selected.

-- DICTIONARY LANGUAGE: You can change the dictionary language using this drop down.

Read More -- trumpexcel.com/using-spell-check-in-excel/




Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/

⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: youtube.com/user/trumpexcel?sub_confirmation=1

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial