Validation - removal of over an entire spreadsheet

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

MS Excel 2002 SP3
What is the easiest way of clearing multiple validation points off a
work sheet?
I have a spreadsheet with many validation points spread all over.
I wish to use the sheet for other purposes, but rather than recreate
the work sheet, I could remove the validation drop downs.
How can this be done?
Regards
Roger
 
Roger,
There is a "Clear All" button on the Validation Form...
Data | Validation
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Roger" <[email protected]>
wrote in message MS Excel 2002 SP3
What is the easiest way of clearing multiple validation points off a
work sheet?
I have a spreadsheet with many validation points spread all over.
I wish to use the sheet for other purposes, but rather than recreate
the work sheet, I could remove the validation drop downs.
How can this be done?
Regards
Roger
 
Roger,
There is a "Clear All" button on the Validation Form...
Data | Validation
--
Jim Cone
San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"Roger" <[email protected]>
wrote in message MS Excel 2002 SP3
What is the easiest way of clearing multiple validation points off a
work sheet?
I have a spreadsheet with many validation points spread all over.
I wish to use the sheet for other purposes, but rather than recreate
the work sheet, I could remove the validation drop downs.
How can this be done?
Regards
Roger
Click to expand...

Gosh.....simple when you know how isn't it....thanks
 
Back
Top