Forum Discussion
Unwanted Drop Down
I have a Worksheet that currently has 111 columns and 3152 rows. There are filters across the top row. When I use the filter in cell A1 and type the item into the search box that item does come to ...
Thank you for your quick reply.
I tried each one of these suggestions and had no luck. I also found that when I filtered so that I had 9 units returned that four of these filtered items had the additional unnecessary drop down. One at the bottom of the list and three more grouped together third from the top.
I've also removed the filter then reapplied the filter to everything but Column A. Still have the problem.
I tried each one of these suggestions and had no luck. I also found that when I filtered so that I had 9 units returned that four of these filtered items had the additional unnecessary drop down. One at the bottom of the list and three more grouped together third from the top.
I've also removed the filter then reapplied the filter to everything but Column A. Still have the problem.
Can you share the link to view the file ?
- As you can see below I cannot share the data.
This issue continues and grows. I think somehow it may have something to do with the fact that the worksheet has many cell with 'Notes'. When I open the Selection pane there is a few hundred "Comment #####" listed. When I Hide All the problem goes away, but it comes back within minutes.
Any more ideas? - I was able to turn off the unwanted drop-downs.
I used 'Find & Select' > Selection Pane. Everything listed, and there were a lot, were Visible. I clicked Hide All and the problem went away.
Now I need to know why this happened in the first place and how do I Clear all these unnecessary Drop Downs. - I can't unfortunately. Proprietary information.
When have a moment I'll see if I can generate a copy with some dummy info in it.