Cleaning up Worksheets

[Guest]

I have a worksheet with a lot of vlookup's and calculations in it. I would like to remove all error fields (such as #VALUE, or #N/A) at once without having to go in and delete each field. Can this be done?

 

[Ron de Bruin]

Hi Brad

F5
Special
Formulas>Errors
Ok

Then delete the selection

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)

I have a worksheet with a lot of vlookup's and calculations in it. I would like to remove all error fields (such as #VALUE,

or #N/A) at once without having to go in and delete each field. Can this be done?

 

[Guest]

Thanks Ron

Big hel

----- Ron de Bruin wrote: ----

Hi Bra

F
Specia
Formulas>Error
O

Then delete the selectio

--
Regards Ron de Brui
(Win XP Pro SP-1 XL2000-2003
www.rondebruin.n

I have a worksheet with a lot of vlookup's and calculations in it. I would like to remove all error fields (such as #VALUE

or #N/A) at once without having to go in and delete each field. Can this be done

 

[Ken Wright]

Silly question, but the errors are meaningless yes?? You no longer have
formulas in these cells.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

Thanks Ron!

Big help

----- Ron de Bruin wrote: -----

Hi Brad

F5
Special
Formulas>Errors
Ok

Then delete the selection

would like to remove all error fields (such as #VALUE,