AutoFilter.
Thank you!!!!!
"Gord Dibben" wrote:
In that case, pre-select range B20 down to end of data then Autofilter.
There is no right-clickfilter
Gord Dibben MS Excel MVP
On Sat, 21 Mar 2009 07:58:01 -0700, GEM
wrote:
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??
"Bob I" wrote:
Select the Cells, R-click, Select Filter.
GEM wrote:
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??
"Bob I" wrote:
Select the column first.
GEM wrote:
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??
|