98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Finding errors in excel worksheets
Finding errors in excel worksheets
Resolved · Low Priority · Version 2003
Fri 10 Jul 2009, 16:20Delegate 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:37Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Do a fast scrollIn 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. |
