Tame your computer - scrutinise your spelling


03-06-2019
Roem Tip Time logo

In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she explains how to check the spelling of all worksheets including headers and footers (Microsoft Excel).

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.

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)

Upcoming courses

Course

Date

Price

Microsoft PowerPoint Intermediate

Tue 04 Jun

£ 197.00

Microsoft Excel Getting Started

Wed 05 Jun

£ 115.00

Microsoft Word Introduction

Thu 06 Jun

£ 197.00

Microsoft Access Introduction

Mon 10 Jun

£ 197.00

Microsoft Excel Intermediate

Mon 17 Jun

£ 225.00

Microsoft Excel Intermediate/Advanced

Wed 19 Jun

£ 225.00

Microsoft Excel Manage and summarise data

Thu 20 Jun

£ 115.00

Microsoft Word Advanced

Tue 25 Jun

£ 197.00

Microsoft Excel Introduction

Wed 26 Jun

£ 197.00

Microsoft Excel Getting Started

Tue 09 Jul

£ 115.00

Microsoft Excel Further Use

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

 

 

Independent, innovative software training company based in Cambridge. Registered supplier to local companies such as AstraZeneca, University of Cambridge, South Cambridgeshire District Council and NHS England.

Roem Limited