I was working on my data sheet and countered with one problem
I required filters in two row ranges on being specific I want the first filter to be placed for data range from Row no. 1 to 200 and the second one I want for Row no. 210 to 350.
So I try to do it with filter options that are available in Excel 2007 & Excel 2010 but not getting it but whenever I put the filter on second range first filter goes disappear so with the help of search on various options I got the answer for this problem. And it is here for your help also this we can do without macros
First Go to Insert ribbon in MS Excel 2007
Click on Table A "Create Table" Window will open Select the data range and Mark My Table has headers option
And repeat the same function for another range you will get the desired results.
Regards
Hemant
for more you can refer this book.
https://amzn.to/2SFxDv4
I required filters in two row ranges on being specific I want the first filter to be placed for data range from Row no. 1 to 200 and the second one I want for Row no. 210 to 350.
So I try to do it with filter options that are available in Excel 2007 & Excel 2010 but not getting it but whenever I put the filter on second range first filter goes disappear so with the help of search on various options I got the answer for this problem. And it is here for your help also this we can do without macros
First Go to Insert ribbon in MS Excel 2007
Click on Table A "Create Table" Window will open Select the data range and Mark My Table has headers option
And repeat the same function for another range you will get the desired results.
Regards
Hemant
for more you can refer this book.
https://amzn.to/2SFxDv4
thanks! this info solved my problem right away! :D
ReplyDeleteThank you also - this also worked great for me! ( :
Deletechanged my day! thanks!
DeleteThank you ! Easy Way & Big Help.
DeleteThank you. This was a big help.
ReplyDeleteThank you it really helped
ReplyDeletethank you!!!!
ReplyDeleteGreat Help!! Thank You
ReplyDeleteThank Q.
ReplyDeleteThanks Buddy!! You saved me a lot of time.....................
ReplyDeleteAsolole brotha, nice works
ReplyDeleteThanks U!!!!!!
ReplyDeleteWell done Hemant...many thanks.
ReplyDeletethats a great help Hemant. Thank you
ReplyDeleteDear Hamant can you please show the same by images or video
ReplyDeletebecause i could not understand like this -:(
or plz send the details by mail on this email address anees20040@gmail.com
Thank you in advnce
Anees
Do you know how to do this in excel 2010?
ReplyDeleteThanks a lot! really usefull
ReplyDeleteDo you know how to create new filter in different tables in a sheet which have data before?
ReplyDeleteWorks just as I need. Such a simple solution and instructions. Thanks.
ReplyDeleteThanks a lot..:)
ReplyDeleteThanks..
ReplyDeletethank you.
ReplyDeleteThanks! Perfect solution!
ReplyDeleteBIG THANKS ;)) (Y)
ReplyDeleteGREATT!!
Such a simple and elegant solution...works perfectly. Thanks!
ReplyDeletethaaaaaanks a a lot!
ReplyDelete7 years later and this saved me a lot of time and trouble. Thank you!
ReplyDeleteWow. that was really quick and easy. Thanks.
ReplyDeletety... can there be a filter option which is related to, other filters. For example in a table i filtered the data & then the rest two other filtered tables shows result accordingly....
ReplyDeleteThat's a very good article. It helps to save time and operate it with more ease. Thank you so much for your useful article.
ReplyDeleteCtrl + ' (apostrophe) To Fill Cell Formulas Down From The Adjacent Cell Above
ty!!
ReplyDeletethank you
ReplyDelete