How to Filter with Merged Cells in Excel | Cannot Filter Merged Cells - Filter Only Shows First Row

In this Microsoft Excel video tutorial I explain how to filter using merged cells. If you want to retain the look of your data, using merged cells, but still want to be able to filter - this is your solution.
#exceltips #exceltricks #exceltutorial

[@trisbane4086]

All hail the Excel guru. 🙌🙌

[@pluto_dp]

Geez Mr. Tugwell, this one is hot! Thanks for sharing 🙏🏻

[@mohamed_yahya_1]

usefull way, tanks bro.

[@ScHAmPi]

Thanks! I also noticed that if you change the value of a merged cell after you do this, behind the scenes it's changed in both source cells. This is a good thing or otherwise you'd end up with messed up results if you change the values after the operation.

[@BlueDattebayo]

thanks for this! does this still work even when i continue adding onto that list? i.e. more lines of data in "MID"

[@soniccheese01]

Fantastic Chester, how on earth did you discover that little gem?

[@ChesterTugwell]

I have a terribly boring life spent discovering these things😁

[@pluto_dp]

@@ChesterTugwell haha that's two of us