How to filter merged cells in excel|Filter not working for merged cell in Excel

[@daftafter]

Soy de San Luis Potosí ,MX . Im from Mx...you just have saved my spreadsheet with this way to filter the data. Gracias amigo!!! Thanks a lot!! suscribed!

[@almaebeatrice7866]

I've been looking for this for hours!! OMG, Thank you so much for saving my time!

[@aliraza-uw2oh]

1 munth se search kar raha tha ye formula ab jake mile tyanks

[@ps3jlmp]

This is super super helpful! Thank you so much this video has made my job so much easier

[@aishwaryajoseph49]

Oh my goodness! You have no idea how much this video helped me! in the right time. God bless you

[@laurenschwarze8426]

I am super impressed! Despite it being a handful of steps, it was super easy to follow. Thank you!!!

[@TheTranspoter3]

What if we want new item in that column . What is solution for adding new item to the list will it be filtered ?

[@saiabhilash3151]

Great video sir .Saved lot of time in my day

[@shaharyarkhan6789]

how did you merge the cells in the first place?

[@berthaabreu]

Just what I was looking for!!! Thank youuuuu!

[@jmjeyco]

Thank you for sharing this trick. Found it very useful.

[@abdellatifboudelal167]

Can you please show how to merge cells in a table as the one that you are showing here. The merge option disappear when i format the sheet cells into table format !

[@Richslavedolph]

Are you using the filter option? Or are you selecting data then use create table?

[@luissilva5815]

It worked !! Thank God !

[@zaidhf3748]

Very useful ❤

[@KumuduDissanayake-eq8bm]

This is so helpful 🤗

[@penzi_sa]

Question, does this solution make it possible to pivot the data? I've struggled pivoting merged cells

[@blank0004]

AMAZING TUTOR.. THANKS!!!!

[@MuhamadSyazwanAzmi]

very helpful. thanks.

[@sargamchhabra1835]

Amazing tutorial! Thanks.

[@yamigaruza1159]

Thank you so much for this tutorial!

[@Rajairusu]

Very useful for me. Thank you..

[@MyLisZa]

this surprisingly works! thanks!

[@jibinjames1088]

Great. It saved my day. Thank you so much.

[@venicsseyoBBmvip]

Hi, this is very useful to me. what about if I adding a new column, would this automatically can be filtered?

[@waqarjawaid]

HAVE YOU FOUND ANY SOLUTION FOR NEW COLUMN.

[@monishshaji6014]

Very important for me thanks very much

[@afaisaliqbal]

Very well good keep it up, love u

[@Richslavedolph]

When insert a new row it doesn’t come with the same constraints, how can i fix that?

[@yanzebiloable]

Did u find the solution?

[@CNsongs]

Exactly what I needed. Thank you very much

[@HIKAJO]

I'm using a list for the merged cell, when I change the content of the merged cell, only the top one changes, the bottom cells remain the same, any suggested solution so that it automatically fills the bottom cells with the updated top cell?

[@TheSupraRegistry]

Mine was doping that. I just had to manually put it into each cell and then do =B2 etc after and it worked. I think it was something about the formatting of my cells

[@samuelkusnierik3702]

Hello. I need to sort the cells from Z to A. From Chapter 6 to Chapter 1. But Excel refuses to do it.

[@enkhbayarganbold1971]

Wonderful. It worked dough the microsoft made me unnecessary steps...

[@salmanraza5391]

Amazing technique

[@nagendrapatchpulusu]

how does it works same in Google Sheets?

[@victormonga8976]

This was very helpful, thank you so much!!!

[@indrasukmawan8259]

Thanks, you save my day

[@yellowyin]

Nice! How would you do that in google sheets?

[@sarfauzles2224]

Thank you so much, this is very helpful!

[@shweyee2695]

Thanks a lot mate. I subscribed

[@lifeofentertain9293]

Super, i learn new tool

[@babk08]

LEGEND!!!

[@jdescario]

Lifesaver!!

[@vijufriend7029]

How to calculating i am merged to colum

[@pandaLu25]

amazing. thanks !

[@rounakmalhotra5553]

What if merge cells are of different size

[@mohanudaya4685]

Too much useful

[@KBL1974]

you saved me thank you

[@rexbk]

Thank you

[@smregretterien]

THANK YOU SO MUCH!

[@negisushils]

Thnks a lot

[@akkyc1617]

Thank you..!!!!🙏

[@pedrovalencia4060]

whilst the tutorial is useful, the Excel feature is not friendly itself.

[@Mr-dj6ul]

Thank You So much

[@avevae3ddesigner84]

Thanks lot of time save

[@qurratulainibrahim412]

Awesome

[@aakashcommerceclasses]

thnku so much

[@dalahhomsi3631]

Thank youuu

[@sunnybhalerao6381]

EXCELLANT....

[@innduz]

NOT CLEAR

[@jnunyabizio5169]

I can't follow this. I hate my life

[@salmanraza5391]

Amazing technique

[@komalkul]

Thank you so much!

[@souyhengchoung2577]

thank you so much

[@TheSupraRegistry]

THANK YOU!!!!