Playback starts YouTube’s embedded player (privacy-enhanced mode).
How To Do Spell Check In Excel
ChannelMy E-LessonDescription from the creator
Are you a new Excel user? Learn how to use the inbuilt Spell Check option in Excel. Watch the video for a detailed explanation.
Check spelling in a Excel worksheet
To check spelling for any text on your worksheet, click Review - Spelling.
TIP: You can also press F7.
Here are some things that happen when you use the spelling checker in Excel
If you select a single cell for spell check, Excel checks the entire worksheet, including the comments, page headers, footers and graphics.
If you select multiple cells, Excel checks spelling only for those cells.
To spell check words in a formula bar, select the words.
NOTE: Excel doesn’t check spelling in cells that contain formulas.
Correct spelling as you type
Both AutoComplete and AutoCorrect can help fix typing errors on the go.
AutoComplete, on by default, helps to maintain accuracy as you type by matching entries in other cells and does not check individual words in a cell, AutoComplete can be handy when creating formulas.
AutoCorrect fixes errors in a formula’s text, worksheet control, text box, and chart labels. Here’s how to use it:
Click File - Options.
Under the Proofing category, click AutoCorrect Options, and check the most likely typing errors.
NOTE: You can’t use AutoCorrect for text in a dialog box.
Additional resources
You can also check out Research, Thesaurus and Translate for more help with spelling and language.
Spelling, thesaurus and translate options
To watch more videos and download the files visit : myelesson.org
To Buy a Excel Course DVD visit : bit.ly/1CgLhku
Subscribe to the channel : bit.ly/1tpIjXZ
Like us on Facebook : facebook.com/excelmadeasy
Follow us on Twitter : twitter.com/Excelmadeasy 10 Most Used Formulas MS Excel
youtube.com/watch?v=KyMj8HEBNAk
Learn Basic Excel Skills For Beginners || Part 1
youtube.com/watch?v=3kNEv3s8TuA
10 Most Used Excel Formula
youtube.com/watch?v=2t3FDi98GBk
**Most Imporant Excel Formuls Tutorials**
Learn Vlookup Formula For Beginners in Excel
youtube.com/watch?v=vomClevScJQ
5 Excel Questions Asked in Job Interviews
youtube.com/watch?v=7Iwx4AMdij8
Create Speedometer Chart In Excel
youtube.com/watch?v=f6c93-fQlCs
Learn the Basic of Excel for Beginners || Part 2
youtube.com/watch?v=qeMSV9T1PoI
Create Pareto Chart In Excel
youtube.com/watch?v=2UdajrDMjRE
How to Create Dashboard in Excel
youtube.com/watch?v=RM8T1eYBjQY
Excel Interview Questions & Answers
youtube.com/watch?v=Zjv1If63nGU
Check spelling in a Excel worksheet
To check spelling for any text on your worksheet, click Review - Spelling.
TIP: You can also press F7.
Here are some things that happen when you use the spelling checker in Excel
If you select a single cell for spell check, Excel checks the entire worksheet, including the comments, page headers, footers and graphics.
If you select multiple cells, Excel checks spelling only for those cells.
To spell check words in a formula bar, select the words.
NOTE: Excel doesn’t check spelling in cells that contain formulas.
Correct spelling as you type
Both AutoComplete and AutoCorrect can help fix typing errors on the go.
AutoComplete, on by default, helps to maintain accuracy as you type by matching entries in other cells and does not check individual words in a cell, AutoComplete can be handy when creating formulas.
AutoCorrect fixes errors in a formula’s text, worksheet control, text box, and chart labels. Here’s how to use it:
Click File - Options.
Under the Proofing category, click AutoCorrect Options, and check the most likely typing errors.
NOTE: You can’t use AutoCorrect for text in a dialog box.
Additional resources
You can also check out Research, Thesaurus and Translate for more help with spelling and language.
Spelling, thesaurus and translate options
To watch more videos and download the files visit : myelesson.org
To Buy a Excel Course DVD visit : bit.ly/1CgLhku
Subscribe to the channel : bit.ly/1tpIjXZ
Like us on Facebook : facebook.com/excelmadeasy
Follow us on Twitter : twitter.com/Excelmadeasy 10 Most Used Formulas MS Excel
youtube.com/watch?v=KyMj8HEBNAk
Learn Basic Excel Skills For Beginners || Part 1
youtube.com/watch?v=3kNEv3s8TuA
10 Most Used Excel Formula
youtube.com/watch?v=2t3FDi98GBk
**Most Imporant Excel Formuls Tutorials**
Learn Vlookup Formula For Beginners in Excel
youtube.com/watch?v=vomClevScJQ
5 Excel Questions Asked in Job Interviews
youtube.com/watch?v=7Iwx4AMdij8
Create Speedometer Chart In Excel
youtube.com/watch?v=f6c93-fQlCs
Learn the Basic of Excel for Beginners || Part 2
youtube.com/watch?v=qeMSV9T1PoI
Create Pareto Chart In Excel
youtube.com/watch?v=2UdajrDMjRE
How to Create Dashboard in Excel
youtube.com/watch?v=RM8T1eYBjQY
Excel Interview Questions & Answers
youtube.com/watch?v=Zjv1If63nGU
About this tutorial
My E-Lesson published this 1:19 video tutorial on October 26, 2011. It has been watched 422,114 times on YouTube.
- Channel
- My E-Lesson
- Category
- Education
- Duration
- 1:19
- Published
- October 26, 2011
- Views
- 422,114
- Likes
- 1,392
Tags
Share
This tutorial in other languages
- FRComment faire la vérification orthographique Dans Excel
- ESCómo hacer que el Corrector ortográfico En Excel
- PTComo fazer a verificação ortográfica Em Excel
- ITCome fare Spell Check In Excel
- DEHow To Do Rechtschreibprüfung in Excel
- NLHow To Do spellingcontrole in Excel
- RUКак это сделать Проверка орфографии в Excel
- PLJak zrobić sprawdzanie pisowni w programie Excel
- JAどのようにするために行うには、Excelでスペルチェック
- ARكيفية القيام التدقيق الإملائي في Excel
- HIकैसे करने के लिए क्या वर्तनी जाँच Excel में
- IDCara Do Spell Check In Excel