Getting rid of drop down arrows

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

Guest

Months ago, I created a drop down list for one of the columns on my
worksheet. Since then, I have decided to eliminate the list. I went in to
the place where I defined the range and deleted the name. I also deleted the
referenced range. But, when I click on a cell in this column I still get the
drop down arrow, even though the list is empty. How do I get rid of the
arrow???
 
Jayceejay,

More than likely you have the data validation still set. To turn it off, go
to the standard toolbar, hit Data -> Validation, and then hit the "Clear All"
button at the bottom left side of the dialog box.
 
Thanks Frank! I'm gonna go crawl under something now. Too simple. I
appreciate your help.
 
Back
Top