View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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?