Topic 9 – Notes
After completing this lesson, you should know:
- How Autocorrect will correct text as you type
- How to add your own entries to the list for future use
- How to use the spell checker in Excel
How Autocorrect works:
This feature can change the way Excel corrects text as you type.
To see the Autocorrect Options: File g Options g Proofing g AutoCorrect Options
Look at the top word in the list above: If the user types “abbout”, Excel will replace it with “about” automatically.
Add your own entries to the list:
You can also add your own entries to the existing list for future use.
You are using the name “City of Cape Town” often in your workplace. Instead of typing the long term every time, add it to the Autocorrect list.
- Type a shortcut you don’t use elsewhere on the computer in the box below Replace.
- Type the correct term in the box below With.
- Click Add to save it in the Autocorrect list.
- Type “ci” in any cell in Excel
- Press Enter
- The term City of Cape Town will display.
Excel can check the spelling in the document.
Review ribbon tab → Proofing group → Spelling (Shortcut: F7)
- Click in cell A1 (to start the spell check from the top)
- Use any method to start the spell checker.
- The first “error” will show with possible suggestions. Excel cannot find the word “Emp” in the dictionary and suggests “Imp” etc. We want to keep Emp as the shortcut for Employee and therefore we click on Ignore Once (for only this occurrence) or Ignore All (for all occurences).
- The second error will show. Enginering is the wrong spelling and we are going to accept the suggestion at the bottom of the window. Click on Change (to change this occurrence only) or Change All (to change all the occurrences of the wrong spelling).
- Carry on until all the spelling problems are sorted out.