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.
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:
