Excel has a built-in spelling checker you can use to correct mistakes and identify words or terms that are spelled correctly but don’t appear in Excel’s dictionary.
- [Instructor] Even the best writers can occasionally misspell a word, which can make it difficult to interpret the author's intent. Excel has a built-in spelling checker that you can use to correct mistakes and identify words or terms that are spelled correctly but do not appear in Excel's dictionary. In this movie, I will demonstrate how to check spelling in Excel 2019. My sample file is the spelling workbook and you can find it in the chapter 10 folder of the exercise files collection. This workbook contains a number of inquires listed by state, and I want to see there are any spelling errors.
To start that process, I will go to the Review tab at the ribbon, and then at the far left of the tab I'll click Spelling. Doing so displays the spelling dialog box, and it has found a misspelling and indicated the cell where the misspelling occurred, here in cell A4. It's highlighted. And I see that the state of Colorado is misspelled. It should be C-O-L-O instead of C-O-L-A. I have a number of options now: I can either ignore this particular error, I can ignore every occurrence of this error so it would be skipped over any time Excel's spell checking within this worksheet, also I can add it to my dictionary.
And one thing to note about adding words to dictionary is if you add them then they go in immediately, and you have to go in to the dictionary that is at the address here below add words to, to make any changes. So only add it if you're absolutely certain. You can also change based on suggestion. If there's more than one suggestion in the suggestions list you can click the one you want. In this case, Colorado's the only one.
But then I have Colorado, and I can click Change, I can click Change All, or I can add it as an AutoCorrect entry. In this case, I know that I do want to change it, and I'll just click the Change button one time. Next I see that Oregon has been misspelled as Oregone, so I'll click change. I'm asked if I want to continue checking at the beginning of the sheet. That's because I started before cell A1 or in a different cell than A1. I'll click yes.
And the spell check's complete. I'm good to go. As you can see, spell checking is a fairly straightforward process. The only trick to watch out for is to make sure that you don't accidentally add a misspelling to the dictionary because you'll just have to take it out later.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.