Forum Discussion
Filters with Merge&Center cells
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...
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:
