Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select specific column for auto filter
Hi,
Is there a way to select a specific column for autofilter? When I turn auto-filter on, it creates an auto filter on all the columns (A1- E1) instead of say, A1, C1, E1. There has to be a way to do this. I already tried highlighting and turning Autofilter on but it didn't work. Thx. Sargum |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select specific column for auto filter
If you highlight a range of entire adjacent columns, Autofilter will turn on
only on highlighted columns. Regards, Stefi €ť ezt Ă*rta: Hi, Is there a way to select a specific column for autofilter? When I turn auto-filter on, it creates an auto filter on all the columns (A1- E1) instead of say, A1, C1, E1. There has to be a way to do this. I already tried highlighting and turning Autofilter on but it didn't work. Thx. Sargum |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select specific column for auto filter
On Oct 1, 9:50 am, Stefi wrote:
If you highlight a range of entire adjacent columns, Autofilter will turn on only on highlighted columns. Regards, Stefi " ezt írta: Hi, Is there a way to select a specific column for autofilter? When I turn auto-filter on, it creates an auto filter on all the columns (A1- E1) instead of say, A1, C1, E1. There has to be a way to do this. I already tried highlighting and turning Autofilter on but it didn't work. Thx. Sargum- Hide quoted text - - Show quoted text - I see ... I wasn't highlighting the entire column...it works as you mentioned. Thx. S |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select specific column for auto filter
You don't need to highlight the entire column - suppose you have
headers in row 3 with subtotals above: you might want your filters to start from row4 onwards, in which case highlight from row3 across and down. The important thing is to highlight adjacent columns. Hope this helps. Pete On Oct 1, 5:03 pm, wrote: On Oct 1, 9:50 am, Stefi wrote: If you highlight a range of entire adjacent columns, Autofilter will turn on only on highlighted columns. Regards, Stefi " ezt írta: Hi, Is there a way to select a specific column for autofilter? When I turn auto-filter on, it creates an auto filter on all the columns (A1- E1) instead of say, A1, C1, E1. There has to be a way to do this. I already tried highlighting and turning Autofilter on but it didn't work. Thx. Sargum- Hide quoted text - - Show quoted text - I see ... I wasn't highlighting the entire column...it works as you mentioned. Thx. S- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select specific column for auto filter
Yes, that's a useful addition to my post.
Regards, Stefi €žPete_UK€ť ezt Ă*rta: You don't need to highlight the entire column - suppose you have headers in row 3 with subtotals above: you might want your filters to start from row4 onwards, in which case highlight from row3 across and down. The important thing is to highlight adjacent columns. Hope this helps. Pete On Oct 1, 5:03 pm, wrote: On Oct 1, 9:50 am, Stefi wrote: If you highlight a range of entire adjacent columns, Autofilter will turn on only on highlighted columns. Regards, Stefi " ezt mrta: Hi, Is there a way to select a specific column for autofilter? When I turn auto-filter on, it creates an auto filter on all the columns (A1- E1) instead of say, A1, C1, E1. There has to be a way to do this. I already tried highlighting and turning Autofilter on but it didn't work. Thx. Sargum- Hide quoted text - - Show quoted text - I see ... I wasn't highlighting the entire column...it works as you mentioned. Thx. S- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I select cells within a column that contain a specific word | Excel Worksheet Functions | |||
Is it possible to use auto filter to select more than 2 criteria? | Excel Discussion (Misc queries) | |||
Using Hide, Unhide, and auto filter - select all on a protected sh | Excel Worksheet Functions | |||
how do i select all the visible cells only when using auto filter | Excel Discussion (Misc queries) | |||
I need a specific value in auto filter to fill a combo box and than match the select value in 2 other columns. | Excel Worksheet Functions |