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!

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!

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!

When you click on Data/ Vaidation this should open a dialog box which contains
Settings - --- imput message ---- error alert
this should have a box in bottom left hand corner that says Clear All
--
grizz


"Bons" wrote:

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!

Hi Bons,

It sounds like you have put a filter on your worksheet. Go to
HomeEditingSort&Filter and select "Filter". This should remove the filter
from your worksheet. Also the keyboard shortcut is ALT-D-F-F.

rzink

If this is helpful, please click "Yes"

"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!

THANKS!!! That was the problem---I was playing around with it b4 I came back
in here and actually found it up there in the Sort/Filter
area----experimented with it and it worked!! Was going to post for
others---but found you had posted it here --- this site is so great for
helping others back and forth! Thanks again!!

"rzink" wrote:

Hi Bons,

It sounds like you have put a filter on your worksheet. Go to
HomeEditingSort&Filter and select "Filter". This should remove the filter
from your worksheet. Also the keyboard shortcut is ALT-D-F-F.

rzink

If this is helpful, please click "Yes"

"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!

Bons,

Glad to hear you were able to solve the problem. I know this site has been
a HUGE help for me to. Thanks for the feedback!

rzink

"Bons" wrote:

THANKS!!! That was the problem---I was playing around with it b4 I came back
in here and actually found it up there in the Sort/Filter
area----experimented with it and it worked!! Was going to post for
others---but found you had posted it here --- this site is so great for
helping others back and forth! Thanks again!!

"rzink" wrote:

Hi Bons,

It sounds like you have put a filter on your worksheet. Go to
HomeEditingSort&Filter and select "Filter". This should remove the filter
from your worksheet. Also the keyboard shortcut is ALT-D-F-F.

rzink

If this is helpful, please click "Yes"

"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!