Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Getting rid of drop down arrows
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??? |
#2
|
|||
|
|||
Hi
'Data - Validation' -- Regards Frank Kabel Frankfurt, Germany "jayceejay" schrieb im Newsbeitrag ... 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??? |
#3
|
|||
|
|||
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. "jayceejay" wrote: 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??? |
#4
|
|||
|
|||
Thanks Frank! I'm gonna go crawl under something now. Too simple. I
appreciate your help. "Frank Kabel" wrote: Hi 'Data - Validation' -- Regards Frank Kabel Frankfurt, Germany "jayceejay" schrieb im Newsbeitrag ... 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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list question | Excel Discussion (Misc queries) | |||
How to change fonts in drop down list | Excel Discussion (Misc queries) | |||
How do you create a drop down list? | Excel Discussion (Misc queries) | |||
edit a drop down list | Excel Discussion (Misc queries) | |||
Filling drop down box | Excel Discussion (Misc queries) |