Tuesday, May 29, 2018

How to filter data with merged cells in Excel: ?

Filter and view all the related data on the merged cells

I have  data in both Columns and Rows  Merged , My problem was that I need to filter the data by column  and when I do this the data showed is only for the 1st row of the merged cells.

The solution could be by simple Filtering tricks  options and  better than adding any codes


HYG How to do this 

https://www.youtube.com/watch?reload=9&v=-Udd6Nc74dY

Another Two Techniques

Tehnique 1
https://www.youtube.com/watch?v=up3ZzvjXX44&pbjreload=10

Technique 2
https://www.youtube.com/watch?v=7L8Aq8lrR1k


No comments:

Post a Comment