Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How do you apply the automatic filter to one cell?
Thanks |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
A tiny trick:
If you click on a single header cell and apply AutoFilter, it will be applied to all the header cells, but if you click on the column and apply AutoFilter, it will be applied to only the single cell. -- Gary''s Student - gsnu200902 "Dave" wrote: How do you apply the automatic filter to one cell? Thanks |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Do you mean you want to apply data|filter|autofilter to a single column?
If yes, then select the column in your range and then apply the filter. Dave wrote: How do you apply the automatic filter to one cell? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |