One Click Filter in Excel2007

[SteveF]

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]

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

 

[Ron de Bruin]

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 Filter>by selected cell value

 

[Peo Sjoblom]

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)

 

[Ron de Bruin]

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

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)

 

[Peo Sjoblom]

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

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

 

[Ron de Bruin]

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

 

[Peo Sjoblom]

You are correct, I didn't even test that

Peo

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

 

[SteveF]

Thanks, Ron- it's not quite as good as one-click, but I guess you can't
have everything

 

[Peo Sjoblom]

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)