View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default 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