Multiple Filters on One Worksheet

SaraWitch

Board Regular
Joined
Sep 29, 2015
Messages
104
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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!
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

denzo36

Board Regular
Joined
Sep 22, 2019
Messages
151
Office Version
  1. 365
Platform
  1. Windows
Unfortunately yes, you can only have one filter per worksheet - I've encountered this myself many times. It is very annoying!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
62,252
Office Version
  1. 365
Platform
  1. Windows
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.
 
Solution

SaraWitch

Board Regular
Joined
Sep 29, 2015
Messages
104
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
🤭 Thought you may say that! Thank you, Fluff ;)

And thank you, Denzo :)
 

denzo36

Board Regular
Joined
Sep 22, 2019
Messages
151
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
62,252
Office Version
  1. 365
Platform
  1. Windows
Glad to help & thanks for the feedback.
 

SaraWitch

Board Regular
Joined
Sep 29, 2015
Messages
104
Office Version
  1. 365
  2. 2010
Platform
  1. Windows

ADVERTISEMENT

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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,950
Office Version
  1. 365
Platform
  1. Windows

SaraWitch

Board Regular
Joined
Sep 29, 2015
Messages
104
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
I didn't know this! Thank you, Joe4!! My, this will be useful in future! 😁
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,950
Office Version
  1. 365
Platform
  1. Windows
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.
 

Forum statistics

Threads
1,141,073
Messages
5,704,135
Members
421,328
Latest member
mippy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top