AutoFilter.

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??
 
G

GEM

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??
 
B

Bob I

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??

:
 
G

GEM

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??
 
G

Gord Dibben

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
 
G

GEM

Thank you!!!!!

Gord Dibben said:
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
 

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

Top