Auto Filter Single Column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top