Finding errors in excel worksheets

Resolved · Low Priority · Version 2003

Fri 10 Jul 2009, 16:20 Delegate Tim said...

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?

Mon 13 Jul 2009, 10:37 Trainer Carlos said...

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

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips