D danica.reed Jun 3, 2007 #1 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!
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!
D danica.reed Jun 3, 2007 #2 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! Click to expand... p.s. I've found info on how to use it in 2007, but I'm using 2003 so that doens't work.
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! Click to expand... p.s. I've found info on how to use it in 2007, but I'm using 2003 so that doens't work.
G Gord Dibben Jun 3, 2007 #3 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
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
M mikerickson Jun 3, 2007 #4 Show the Auditing Toolbar (View-Toolbars) One of the buttons there is "circle invalid data" Have fun!
Show the Auditing Toolbar (View-Toolbars) One of the buttons there is "circle invalid data" Have fun!
