Filtering merged cells

[maywal]

Hi

I have a table covering B2:AR718. Column B and column C are all merged cells, each category merging 5 cell rows each. Columns E to AR are not merged and need to stay as 5 separate rows per cat.

I would like to filter the whole table from Column B, however it tells me that it cannot filter unless merged cells are the same size?

How can I do this without getting rid of my merged cells.

Thanks

 

[Joe4]

Welcome to the Board!

If you want to filter, I think you will need to unmerge the cells.
If you have merged multiple rows within a single column, see this for details: Workaround for sorting and filtering of merged cells

Note that merged cells are very problematic and really should be avoided at all costs. They wreak havoc with things like sorting, filtering, and VBA. If you are "stuck" with them (i.e. this is how the data is sent to you), it will often be necessary to do some data clean-up and unmerge the data before working with it.