| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If A1=dog or A2=cat in wrkbk1 sheet1, then copy row to wrkbk2 shee | Excel Worksheet Functions | |||
| Advanced filter and a list | New Users to Excel | |||
| Is there a way to link Auto Filter values to a Cell | Excel Worksheet Functions | |||
| Sorting and copying automatically between worksheets | New Users to Excel | |||
| Excel startup switches | Excel Discussion (Misc queries) | |||
Hybrid Mode
