Excel’s AutoCorrect feature corrects common spelling errors, such as accomodate and recieved, as you type. But – unlike in Outlook, Word and PowerPoint – it doesn’t show potential spelling errors with a red squiggly line, so you might never spot, for example, that accomodation is misspelled.
Even worse … by default, Excel only checks the spelling of your active sheet. But although it might prompt you to continue checking at the beginning of the sheet if you didn’t have your cursor in cell A1 (CTRL + HOME, anyone?) it won’t warn you to check the rest of your sheets. OK, right at the end it tells you the spelling check is complete for the entire sheet rather than for the workbook, but who would notice that?!
So you’ll have to check the spelling of your text manually and you have to specifically tell it to check the spelling of all worksheets.
Here’s how:
1. Right-click any of your sheets and select Select All Sheets.
2. Press F7. (Or click on the Spelling button in the Proofing group on the Review tab.)
As you most probably know, possible spelling errors are flagged up in a separate dialogue box from where you select the appropriate action - Ignore, Add, Change or AutoCorrect. If you always misspell, say, accomodation I strongly recommend to click on AutoCorrect. This will replace the flagged entry (accomodation) with the entry that is selected or typed (accommodation) and adds the entry to the AutoCorrect dictionary. In short, in future it will always automatically change accomodation to accommodation.
Finally, as I have configured Outlook to automatically check for spelling mistakes I will now be prompted to change the deliberate typos in this message as soon as I hit the Send button.
Related tips
How to get people to open your email (Microsoft Outlook)
Stop AutoCorrect from capitalizing text following specific abbreviations (Microsoft Office)
Restricting cell entries to specific entries in a list (Microsoft Excel)
Course | Date | Price |
Tue 04 Jun | £ 197.00 | |
Wed 05 Jun | £ 115.00 | |
Thu 06 Jun | £ 197.00 | |
Mon 10 Jun | £ 197.00 | |
Mon 17 Jun | £ 225.00 | |
Wed 19 Jun | £ 225.00 | |
Thu 20 Jun | £ 115.00 | |
Tue 25 Jun | £ 197.00 | |
Wed 26 Jun | £ 197.00 | |
Tue 09 Jul | £ 115.00 | |
Tue 09 Jul | £ 115.00 |
All prices are per person and exclusive of VAT.
Book more than one person from your organisation on the same course, on the same date, and you get 10% off. Quote TEAM to get your discount.
The course fee includes a handout with exercise files and a month free support on the topics learned.
3 June 2019
Karen Roem offers software training and support through her company Roem Ltd. Contact her by email (Karen@roem.co.uk) or visit her website at www.roem.co.uk