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 the top and all the rest are filtered out. However, an additional drop down arrow appears and covers up the original Filter drop down arrow which means I will now need to Clear the filter in order to get the whole sheet back. This 'additional drop down' does not provide any information within it, it is blank always.
When I filter using the drop down in a different column that same 'additional drop down' shows up in Column A.
Now, when I filter the sheet and have multiple items returned, those multiple items come to the top and the 'additional drop down' shows up in the last item cell of Column A. It appears that this 'additional drop down' will show up at the bottom of item that is filtered.
I am not using Data Validation, but I've went ahead and "Cleared" it anyway, the whole sheet.
I've copied Column A and did a Past Values. Did not have any effect.
I've Copied Column A, did a Past Values on a different sheet, deleted all of Column A then inserted the Copied values back into the sheet. Did not have any effect.
I've asked someone else to open and try filtering and they had same result as myself.
I've tried everything I know to try. I'm at a loss now and could use some help.
6 Replies
- The issue you're experiencing with the extra blank drop-down arrow in Excel filters can be frustrating. This usually happens when there's some leftover formatting or data validation applied to the filtered column. To resolve this problem, you can try the following steps:
Clear Data Validation:
Select the entire column where you are experiencing this issue (Column A).
Go to the "Data" tab.
Click "Data Validation" and select "Data Validation" from the dropdown.
In the "Data Validation" dialog box, switch to the "Settings" tab.
Check if there is any data validation applied to this column. If so, clear it.
Remove Filter and Reapply:
Remove the filter in Column A.
Clear the filter in any other column where you see the extra drop-down arrow.
Reapply the filter in Column A.
Clear All Filters:
If the issue persists, you can try clearing all filters in your worksheet.
Go to the "Data" tab, and click "Clear" in the "Sort & Filter" group.
Choose "Clear" to remove all filters.
Check for Hidden Rows:
Sometimes, hidden rows can cause issues with filters. Unhide any hidden rows within your data.
Check Conditional Formatting:
Check for any conditional formatting rules applied to the filtered column. They can sometimes affect the filter functionality. Remove any unnecessary formatting.
Review Custom Views:
Check if there are any custom views applied to your worksheet. Custom views can sometimes conflict with filtering. You can access custom views through the "View" tab and then "Custom Views."
Workbook Analysis Tools:
In some cases, Excel's built-in Workbook Analysis tool can help identify issues with the workbook. Go to the "File" tab, select "Options," then go to "Add-Ins." At the bottom of the window, select "COM Add-ins" from the dropdown and click "Go..." Enable "Inquire" and "Workbook Analysis."
Excel Repair:
If none of the above steps work, it's possible that the Excel workbook itself might have some corruption. In this case, you can try opening the file on a different computer or repairing the Excel installation.
VBA Code Check:
If there is any VBA code in the workbook, check if it is causing any unexpected behavior.
After trying these steps, you should be able to resolve the issue with the extra drop-down arrow in your Excel filters.- 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.- Can you share the link to view the file ?
