HELP I need to locate invalid data and I don't know how!
 

how do you locate invalid data on a worksheet?!?! I've searched in
Excel help and all over google and I can't find an anser!

HELP I need to locate invalid data and I don't know how!
 

On Jun 3, 12:41 pm, wrote:
how do you locate invalid data on a worksheet?!?! I've searched in
Excel help and all over google and I can't find an anser!

p.s. I've found info on how to use it in 2007, but I'm using 2003 so
that doens't work.

HELP I need to locate invalid data and I don't know how!
 

How would Excel know the difference between valid or invalid?

First you must identify what "invalid data" means.

Then you use any number of functions to look over the sheet to find the inavlid
data.

Can you give us a hint?


Gord Dibben MS Excel MVP

On Sun, 03 Jun 2007 09:41:30 -0700, wrote:

how do you locate invalid data on a worksheet?!?! I've searched in
Excel help and all over google and I can't find an anser!

Show the Auditing Toolbar (View-Toolbars)
One of the buttons there is "circle invalid data"

Have fun!