| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
Show the Auditing Toolbar (View-Toolbars)
One of the buttons there is "circle invalid data" Have fun! Quote:
|
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cleanout invalid data | Excel Discussion (Misc queries) | |||
| Data Validation: Printing Invalid Data Circles | Excel Discussion (Misc queries) | |||
| Data Validation not preventing invalid entries | Excel Discussion (Misc queries) | |||
| Data Validation, Invalid Data Imput | Excel Discussion (Misc queries) | |||
| how can i locate duplicate data in an excel data table? | Excel Worksheet Functions | |||
Hybrid Mode
