AutoFilter.

  • Thread starter Thread starter GEM
  • Start date Start date
G

GEM

Can the autofilter be applied to only 1 column??? I don't want the small
autofilter dropdown arrows to appear on all the columns where I have data,
only on one.

Is this possible??
 
When I select the column it autofilters the data I have on the top, I want to
autofilter data that starts on row 20, row 20 are the headers and from row 21
and on is where the data is. From row 10 - 19 I have absolutly no data at all.

Is it possible to place an autofilter on one column starting on row 20??
 
Select the Cells, R-click, Select Filter.
When I select the column it autofilters the data I have on the top, I want to
autofilter data that starts on row 20, row 20 are the headers and from row 21
and on is where the data is. From row 10 - 19 I have absolutly no data at all.

Is it possible to place an autofilter on one column starting on row 20??

:
Click to expand...
 
I selected the cell where I want to place the autofilter and right clicked...
I don't have any filter option. When I select the column first and then
select the autofilter option it begins the autofilter at the very top of the
spreadsheet, where it first finds data. I want my autofilter to begin at B20.

How do I do this??
 
In that case, pre-select range B20 down to end of data then Autofilter.

There is no right-click>filter


Gord Dibben MS Excel MVP
 
Back
Top