[rah44]

Is it possible to filter one column without the others changing? I am trying
to create a spreadsheet where will sometimes be 60 or so quotes and sometimes
enough to fit all data on one page (after I apply autofilter). This is a
quote that I send out to customers so I do not want the data to spill onto
another page. When there is too much data to fit in a page, I would like it
to instead show up in the next column over. I don't know how to autofilter
the first column without hiding important data in the second. -- I hope that
made sense...

[tim m]

Not sure if this is what you want from your description but you can filter
one column by 1st clicking on the column letter to highlight the column and
then autofilter as normal, it will only put the filter arrow for that one
column.

"rah44" wrote:

Is it possible to filter one column without the others changing? I am trying
to create a spreadsheet where will sometimes be 60 or so quotes and sometimes
enough to fit all data on one page (after I apply autofilter). This is a
quote that I send out to customers so I do not want the data to spill onto
another page. When there is too much data to fit in a page, I would like it
to instead show up in the next column over. I don't know how to autofilter
the first column without hiding important data in the second. -- I hope that
made sense...

[Gord Dibben]

You cannot autofilter on one column without affecting all columns.

Rows are hidden by autofilter and a row extends across all columns.


Gord Dibben MS Excel MVP

On Fri, 26 Oct 2007 13:57:01 -0700, rah44
wrote:

Is it possible to filter one column without the others changing? I am trying
to create a spreadsheet where will sometimes be 60 or so quotes and sometimes
enough to fit all data on one page (after I apply autofilter). This is a
quote that I send out to customers so I do not want the data to spill onto
another page. When there is too much data to fit in a page, I would like it
to instead show up in the next column over. I don't know how to autofilter
the first column without hiding important data in the second. -- I hope that
made sense...

[rah44]

Thank you Gord Dibben -- that was helpful

"Gord Dibben" wrote:

You cannot autofilter on one column without affecting all columns.

Rows are hidden by autofilter and a row extends across all columns.


Gord Dibben MS Excel MVP

On Fri, 26 Oct 2007 13:57:01 -0700, rah44
wrote:

Is it possible to filter one column without the others changing? I am trying
to create a spreadsheet where will sometimes be 60 or so quotes and sometimes
enough to fit all data on one page (after I apply autofilter). This is a
quote that I send out to customers so I do not want the data to spill onto
another page. When there is too much data to fit in a page, I would like it
to instead show up in the next column over. I don't know how to autofilter
the first column without hiding important data in the second. -- I hope that
made sense...