Format as table, no drop down list to sort and filter

**Cheesecube** · 06-06-2019, 04:21 AM

I have a range which is formatted as table, only thing is that I don't see the usual drop down list in the header row which enables me to sort and filter each column.

Under Table Tools > Design, the Filter Button is greyed out.

How do I enable this?

**jomaor1** · 06-06-2019, 06:56 AM

Hello,

I usually get this problem too, it's kinda annoying,
I got two solutions, sometimes neither work, so here it is:

Select EXACTLY all your Header, and go to "Data" Tab and click "Filter"
or
Select EXACTLY all your Table, and go to "Data" Tab and click "Filter"

Format as table, no drop down list to sort and filter

LinkBack

Thread Tools

Rate This Thread

Display

Format as table, no drop down list to sort and filter

Re: Format as table, no drop down list to sort and filter

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Drop-down list from table w/Data Validation copy format of table too?

[SOLVED] VBA to Amend the Filter Selection on a Pivot Table Based on a Drop Down List

Sort and filter with drop-down list

Filter table based on drop down list and show on another sheet

Show items in pivot table filter's drop-down list based on other filters of the same table

Sort the information within a filter list alphabetically (not the data in pivot table)

i cannot filter the values from drop down list from a pivot table report

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions