Multiple Filters on One Worksheet

[SaraWitch]

Hello peeps,

I see that @biglb79 posted something similar in March (currently no answers), so forgive me if this is too similar...

I have a worksheet with four different sections and I want to put a filter on each section. However, when I put the filter on the second section they are removed from the first.

I have tried to make each section a table (highlight section, insert table), but I cannot merge my merged cells in this format and if I convert to range to merge, I lose the filter option for all sections.

Is there only the ability to have one filter on a worksheet, or does anyone know how I can have more?

Ta muchly, folks!

 

[denzo36]

Unfortunately yes, you can only have one filter per worksheet - I've encountered this myself many times. It is very annoying!

 

[Fluff]

The only way to have more than one filter per sheet would be to use tables.
Also merged cells are an abomination & should be avoided like the plague. Get rid of them & convert your ranges to tables, problem solved.

 

[SaraWitch]

? Thought you may say that! Thank you, Fluff

And thank you, Denzo

 

[denzo36]

Tables will work but you would need to stack your tables vertically - if you have them side by side and filter one table, the other table also gets filtered as they are sharing the same rows

If you stack them vertically so that each table isn't sharing any rows with another table, you can have filters on each of the tables

 

[Fluff]

Glad to help & thanks for the feedback.

 

[SaraWitch]

Thanks, Denzo.

My sections/tables are vertical. However (and I know this is abhorrent, Fluff! ), but I need my merged cells. So it will have to be a manual filter insert when needed...

Thank you, both...

 

[Joe4]

My sections/tables are vertical. However (and I know this is abhorrent, Fluff! ), but I need my merged cells.

Are you sure?
If you are just merging multiple columns across individual rows, you can achieve the EXACT same visual effect without all the issues that merge cells cause by using the "Center Across Selection" formatting option.
See: Tom’s Tutorials For Excel: Using Center Across Selection Instead of Merging Cells – Tom Urtis

 

[SaraWitch]

I didn't know this! Thank you, Joe4!! My, this will be useful in future! ?

 

[Joe4]

I didn't know this! Thank you, Joe4!! My, this will be useful in future! ?

You are welcome!

If you are able to implement this, it could save you from a lot of the aggravation merged cells can cause down the road.