Thanks for getting back to me so quickly----but that doesn't seem to work---i
clicked on a drop down and went up to data on the bar and found the
validation---but there was a "clear validation circle"---that didnt
work---could not find a "clear all" ---am i having a senior blonde moment
here????

"grizzly6969" wrote:

go to the drop down you want to get rid of then go to data / validation/
clear all
--
grizz


"Bons" wrote:

We have a spreadsheet that we sorted some of the inner rows. But now there
are drop down boxes on the first row of the data. How do we get rid of these
boxes?? They don't show on the print prieview, but we don't want them to
show at all. Thanks for any light you can shed on this---I KNOW one of you
can help!