How to define a drop down row filter in cell C2 for cells C3:C27 ?
I have seen a couple of times Excelsheets where drop down filters exist in e.g. cell C2
for the range of cells from C3:C27. So when in den cells C3:C27 value appear like aaa bbb ccc aaa bbb bbb aaa .... ccc and I select the drop down menu in C2 then all available values should appear when I select then "aaa" only those rows should remain which contain value "aaa". How do I achieve such a row filtering? Claudia |
How to define a drop down row filter in cell C2 for cells C3:C27 ?
In xl2003 menus:
Select C2:C27 Data|Filter|Autofilter You may want to select more columns so that you could filter them, too. Claudia d'Amato wrote: I have seen a couple of times Excelsheets where drop down filters exist in e.g. cell C2 for the range of cells from C3:C27. So when in den cells C3:C27 value appear like aaa bbb ccc aaa bbb bbb aaa ... ccc and I select the drop down menu in C2 then all available values should appear when I select then "aaa" only those rows should remain which contain value "aaa". How do I achieve such a row filtering? Claudia -- Dave Peterson |
How to define a drop down row filter in cell C2 for cells C3:C27 ?
I think if you highlight the row containing the titles to be filtered on, in
your example, highlight row C. Then select Data, Filter, Autofilter. I think this will give you what you are looking for if I understood your question. "Claudia d'Amato" wrote: I have seen a couple of times Excelsheets where drop down filters exist in e.g. cell C2 for the range of cells from C3:C27. So when in den cells C3:C27 value appear like aaa bbb ccc aaa bbb bbb aaa .... ccc and I select the drop down menu in C2 then all available values should appear when I select then "aaa" only those rows should remain which contain value "aaa". How do I achieve such a row filtering? Claudia |
All times are GMT +1. The time now is 08:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com