Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

finding errors excel worksheets

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Finding errors in excel worksheets

Finding errors in excel worksheets

ResolvedVersion 2003

Tim has attended:
Excel Introduction course

Finding errors in excel worksheets

I there a quick check for identifying errors in text etc on the excel workbooks, without having to scrutinise each row and column?

RE: Finding errors in excel worksheets

Hi Tim

If by identifying errors you mean checking for spelling errors then all you need to do is:

1. Select the Tools menu

2. Click Spelling

If on the other hand you have formulas that are showing errors then:

1. Select Tools

2. Click Error Checking.

This allows you to see how the error came about, the values involved in the formula and so, fix the formula.

Hope this helps

Carlos

Excel tip:

Selecting blank cells within a range of data

Select the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.46 secs.