| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter only one column
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... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filter only one column | New Users to Excel | |||
| Auto Filter Single Column | Excel Discussion (Misc queries) | |||
| Filter data from one collum by looking up from another column | New Users to Excel | |||
| Filter based on a column of items | Excel Discussion (Misc queries) | |||
| How do I use auto filter on only 1 column in a spreadsheet? | Excel Worksheet Functions | |||
Threaded Mode
