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!

[@aishwaryajoseph49]

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

[@ps3jlmp]

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

[@laurenschwarze8426]

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

[@aliraza-uw2oh]

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

[@saiabhilash3151]

Great video sir .Saved lot of time in my day

[@zaidhf3748]

Very useful ❤

[@berthaabreu]

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

[@MuhamadSyazwanAzmi]

very helpful. thanks.

[@jmjeyco]

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

[@yamigaruza1159]

Thank you so much for this tutorial!

[@monishshaji6014]

Very important for me thanks very much

[@TheTranspoter3]

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

[@KumuduDissanayake-eq8bm]

This is so helpful 🤗

[@luissilva5815]

It worked !! Thank God !

[@shaharyarkhan6789]

how did you merge the cells in the first place?

[@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?

[@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.

[@blank0004]

AMAZING TUTOR.. THANKS!!!!

[@afaisaliqbal]

Very well good keep it up, love u

[@MyLisZa]

this surprisingly works! thanks!

[@sargamchhabra1835]

Amazing tutorial! Thanks.

[@Rajairusu]

Very useful for me. Thank you..

[@shweyee2695]

Thanks a lot mate. I subscribed

[@enkhbayarganbold1971]

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

[@CNsongs]

Exactly what I needed. Thank you very much

[@salmanraza5391]

Amazing technique

[@indrasukmawan8259]

Thanks, you save my day

[@victormonga8976]

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

[@sarfauzles2224]

Thank you so much, this is very helpful!

[@penzi_sa]

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

[@lifeofentertain9293]

Super, i learn new tool

[@yellowyin]

Nice! How would you do that in google sheets?

[@babk08]

LEGEND!!!

[@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

[@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?

[@mohanudaya4685]

Too much useful

[@samuelkusnierik3702]

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

[@pandaLu25]

amazing. thanks !

[@KBL1974]

you saved me thank you

[@jdescario]

Lifesaver!!

[@rexbk]

Thank you

[@smregretterien]

THANK YOU SO MUCH!

[@akkyc1617]

Thank you..!!!!🙏

[@avevae3ddesigner84]

Thanks lot of time save

[@negisushils]

Thnks a lot

[@Mr-dj6ul]

Thank You So much

[@nagendrapatchpulusu]

how does it works same in Google Sheets?

[@qurratulainibrahim412]

Awesome

[@rounakmalhotra5553]

What if merge cells are of different size

[@vijufriend7029]

How to calculating i am merged to colum

[@aakashcommerceclasses]

thnku so much

[@pedrovalencia4060]

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

[@dalahhomsi3631]

Thank youuu

[@quantumblur_3145]

__
"Only ranges can have merged cells-"
*[header with filter buttons]*
"IT'S A TABLE?! HOW?!"

[@innduz]

NOT CLEAR

[@sunnybhalerao6381]

EXCELLANT....

[@jnunyabizio5169]

I can't follow this. I hate my life

[@salmanraza5391]

Amazing technique

[@souyhengchoung2577]

thank you so much

[@komalkul]

Thank you so much!

[@TheSupraRegistry]

THANK YOU!!!!