Filtering Merged Cells

[tycasey17]

I have a dashboard but with organization personnel below it. I have merged B2:C2 and in B3:C3 I have the filter arrows turned on however when I attempt to sort by A-Z it gives me an error. Is there a way to fix this?

 

[jasonb75]

See if this helps An error message when you sort a range that contains merged cells in Excel - Office