Select specific column for auto filter

  • Thread starter Thread starter sargum
  • Start date Start date
S

sargum

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
 
If you highlight a range of entire adjacent columns, Autofilter will turnon
only on highlighted columns.

Regards,
Stefi

,,[email protected]" ezt írta:





- Show quoted text -

I see ... I wasn't highlighting the entire column...it works as you
mentioned. Thx.

S
 
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
 
Yes, that's a useful addition to my post.
Regards,
Stefi


„Pete_UK†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top