Filters with Merge&Center cells

New Contributor

Hi all,

I would like to find a solution to use the filter in a column that has merged cells, how can this be done?
The filter now only works on the first row where the value is entered in that cell.

Same matter about 

2 Replies


You may unmerge cells and instead apply Canter Across Selection 


Visually it'll be the same. Merging is always not a good idea except very few scenarios. 

Thank you Sergei.
The merge cells come from a paginated report by Power BI.
Center Across Selection works on column so with the cells alligment the prolem can't be solved: