| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Filter Single Column
You could apply autofilter to a single column by clicking on the
column identifier to highlight the column, then Data | Filter | Autofilter. If you do not require the entire column, just highlight the range you want the filter to apply to (eg C3:C25) then Data | Filter | Autofilter. The filter pull-down will now appear in C3. Hope this helps. Pete On Mar 16, 4:44 pm, Dustin wrote: I want to be able to filter a single column in my spreadsheet. When I select the cell and choose auto filter, it applies the filter to the entire row. Is there a way to apply it to a single column? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Filter does not show all the data in the column | Excel Worksheet Functions | |||
| Search /Filter vertical Numeric pattern (down single column) | Excel Worksheet Functions | |||
| How do I use auto filter on only 1 column in a spreadsheet? | Excel Worksheet Functions | |||
| Column character width on auto filter | Excel Discussion (Misc queries) | |||
| The Auto Filter button lost the column specified option. | Excel Worksheet Functions | |||
Hybrid Mode
