|
One Click Filter in Excel2007
In Excel 2003, selecting a cell in a table then clicking on the filter
icon (funnel) would automatically filter for the item(s) selected. In Excel 2007 there does not appear to be this same kind of shortcut- am I missing something? |
One Click Filter in Excel2007
I don't use xl2007, but in xl2003, you actually customized a toolbar to show
that funnel icon. Maybe (????) you can do the same thing in xl2007??? SteveF wrote: In Excel 2003, selecting a cell in a table then clicking on the filter icon (funnel) would automatically filter for the item(s) selected. In Excel 2007 there does not appear to be this same kind of shortcut- am I missing something? -- Dave Peterson |
One Click Filter in Excel2007
Hi Steve/Dave
In Excel 2007 you can add this icon to the QAT but it only Toggle AutoFilter. You can right click on the cell in Excel 2007 and choose Filterby selected cell value -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in message ... I don't use xl2007, but in xl2003, you actually customized a toolbar to show that funnel icon. Maybe (????) you can do the same thing in xl2007??? SteveF wrote: In Excel 2003, selecting a cell in a table then clicking on the filter icon (funnel) would automatically filter for the item(s) selected. In Excel 2007 there does not appear to be this same kind of shortcut- am I missing something? -- Dave Peterson |
One Click Filter in Excel2007
Yep, you can put it in the QAT (Quick Access Toolbar), click the big ugly
office icon top left, select excel options customize, from the dropdown in the "Choose Commands From" select "commands not in the ribbon", find the autofilter funnel and add it -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Dave Peterson" wrote in message ... I don't use xl2007, but in xl2003, you actually customized a toolbar to show that funnel icon. Maybe (????) you can do the same thing in xl2007??? SteveF wrote: In Excel 2003, selecting a cell in a table then clicking on the filter icon (funnel) would automatically filter for the item(s) selected. In Excel 2007 there does not appear to be this same kind of shortcut- am I missing something? -- Dave Peterson |
One Click Filter in Excel2007
Hi Peo
I see that the AutoFilter icon in Data use the same icon as "commands not in the ribbon", find the autofilter funnel and add it -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Peo Sjoblom" wrote in message ... Yep, you can put it in the QAT (Quick Access Toolbar), click the big ugly office icon top left, select excel options customize, from the dropdown in the "Choose Commands From" select "commands not in the ribbon", find the autofilter funnel and add it -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Dave Peterson" wrote in message ... I don't use xl2007, but in xl2003, you actually customized a toolbar to show that funnel icon. Maybe (????) you can do the same thing in xl2007??? SteveF wrote: In Excel 2003, selecting a cell in a table then clicking on the filter icon (funnel) would automatically filter for the item(s) selected. In Excel 2007 there does not appear to be this same kind of shortcut- am I missing something? -- Dave Peterson |
One Click Filter in Excel2007
Hi Ron,
I saw that too, it seems it works the same way although it is called "Filter" there Of course one can also use the keyboards Ctrl + Shift & L to toggle autofilter Peo "Ron de Bruin" wrote in message ... Hi Peo I see that the AutoFilter icon in Data use the same icon as "commands not in the ribbon", find the autofilter funnel and add it -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Peo Sjoblom" wrote in message ... Yep, you can put it in the QAT (Quick Access Toolbar), click the big ugly office icon top left, select excel options customize, from the dropdown in the "Choose Commands From" select "commands not in the ribbon", find the autofilter funnel and add it -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Dave Peterson" wrote in message ... I don't use xl2007, but in xl2003, you actually customized a toolbar to show that funnel icon. Maybe (????) you can do the same thing in xl2007??? SteveF wrote: In Excel 2003, selecting a cell in a table then clicking on the filter icon (funnel) would automatically filter for the item(s) selected. In Excel 2007 there does not appear to be this same kind of shortcut- am I missing something? -- Dave Peterson |
One Click Filter in Excel2007
Not the same Peo
The one in the Data tab only toggle Autofilter and the one from "commands not in the ribbon" filter on the selected cell value -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Peo Sjoblom" wrote in message ... Hi Ron, I saw that too, it seems it works the same way although it is called "Filter" there Of course one can also use the keyboards Ctrl + Shift & L to toggle autofilter Peo "Ron de Bruin" wrote in message ... Hi Peo I see that the AutoFilter icon in Data use the same icon as "commands not in the ribbon", find the autofilter funnel and add it -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Peo Sjoblom" wrote in message ... Yep, you can put it in the QAT (Quick Access Toolbar), click the big ugly office icon top left, select excel options customize, from the dropdown in the "Choose Commands From" select "commands not in the ribbon", find the autofilter funnel and add it -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Dave Peterson" wrote in message ... I don't use xl2007, but in xl2003, you actually customized a toolbar to show that funnel icon. Maybe (????) you can do the same thing in xl2007??? SteveF wrote: In Excel 2003, selecting a cell in a table then clicking on the filter icon (funnel) would automatically filter for the item(s) selected. In Excel 2007 there does not appear to be this same kind of shortcut- am I missing something? -- Dave Peterson |
One Click Filter in Excel2007
You are correct, I didn't even test that
Peo "Ron de Bruin" wrote in message ... Not the same Peo The one in the Data tab only toggle Autofilter and the one from "commands not in the ribbon" filter on the selected cell value -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Peo Sjoblom" wrote in message ... Hi Ron, I saw that too, it seems it works the same way although it is called "Filter" there Of course one can also use the keyboards Ctrl + Shift & L to toggle autofilter Peo "Ron de Bruin" wrote in message ... Hi Peo I see that the AutoFilter icon in Data use the same icon as "commands not in the ribbon", find the autofilter funnel and add it -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Peo Sjoblom" wrote in message ... Yep, you can put it in the QAT (Quick Access Toolbar), click the big ugly office icon top left, select excel options customize, from the dropdown in the "Choose Commands From" select "commands not in the ribbon", find the autofilter funnel and add it -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Dave Peterson" wrote in message ... I don't use xl2007, but in xl2003, you actually customized a toolbar to show that funnel icon. Maybe (????) you can do the same thing in xl2007??? SteveF wrote: In Excel 2003, selecting a cell in a table then clicking on the filter icon (funnel) would automatically filter for the item(s) selected. In Excel 2007 there does not appear to be this same kind of shortcut- am I missing something? -- Dave Peterson |
One Click Filter in Excel2007
Thanks, Ron- it's not quite as good as one-click, but I guess you can't
have everything Peo Sjoblom wrote: You are correct, I didn't even test that Peo "Ron de Bruin" wrote in message ... Not the same Peo The one in the Data tab only toggle Autofilter and the one from "commands not in the ribbon" filter on the selected cell value -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Peo Sjoblom" wrote in message ... Hi Ron, I saw that too, it seems it works the same way although it is called "Filter" there Of course one can also use the keyboards Ctrl + Shift & L to toggle autofilter Peo "Ron de Bruin" wrote in message ... Hi Peo I see that the AutoFilter icon in Data use the same icon as "commands not in the ribbon", find the autofilter funnel and add it -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Peo Sjoblom" wrote in message ... Yep, you can put it in the QAT (Quick Access Toolbar), click the big ugly office icon top left, select excel options customize, from the dropdown in the "Choose Commands From" select "commands not in the ribbon", find the autofilter funnel and add it -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Dave Peterson" wrote in message ... I don't use xl2007, but in xl2003, you actually customized a toolbar to show that funnel icon. Maybe (????) you can do the same thing in xl2007??? SteveF wrote: In Excel 2003, selecting a cell in a table then clicking on the filter icon (funnel) would automatically filter for the item(s) selected. In Excel 2007 there does not appear to be this same kind of shortcut- am I missing something? -- Dave Peterson |
One Click Filter in Excel2007
As Ron said if you get the one in the "commands not in the ribbon" it works
the same way as the icon in previous version and filter on the cell that is selected with one click -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "SteveF" wrote in message ups.com... Thanks, Ron- it's not quite as good as one-click, but I guess you can't have everything Peo Sjoblom wrote: You are correct, I didn't even test that Peo "Ron de Bruin" wrote in message ... Not the same Peo The one in the Data tab only toggle Autofilter and the one from "commands not in the ribbon" filter on the selected cell value -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Peo Sjoblom" wrote in message ... Hi Ron, I saw that too, it seems it works the same way although it is called "Filter" there Of course one can also use the keyboards Ctrl + Shift & L to toggle autofilter Peo "Ron de Bruin" wrote in message ... Hi Peo I see that the AutoFilter icon in Data use the same icon as "commands not in the ribbon", find the autofilter funnel and add it -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Peo Sjoblom" wrote in message ... Yep, you can put it in the QAT (Quick Access Toolbar), click the big ugly office icon top left, select excel options customize, from the dropdown in the "Choose Commands From" select "commands not in the ribbon", find the autofilter funnel and add it -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Dave Peterson" wrote in message ... I don't use xl2007, but in xl2003, you actually customized a toolbar to show that funnel icon. Maybe (????) you can do the same thing in xl2007??? SteveF wrote: In Excel 2003, selecting a cell in a table then clicking on the filter icon (funnel) would automatically filter for the item(s) selected. In Excel 2007 there does not appear to be this same kind of shortcut- am I missing something? -- Dave Peterson |
| All times are GMT +1. The time now is 10:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com