Cleaning up Worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Hi Brad

F5
Special
Formulas>Errors
Ok

Then delete the selection

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




Brad said:
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,
Click to expand...
or #N/A) at once without having to go in and delete each field. Can this be done?
 
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



Brad said:
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
Click to expand...
or #N/A) at once without having to go in and delete each field. Can this be done
 
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 :-)
----------------------------------------------------------------------------



Brad said:
Thanks Ron!

Big help

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

Hi Brad

F5
Special
Formulas>Errors
Ok

Then delete the selection
Click to expand...
would like to remove all error fields (such as #VALUE,
 
Back
Top