Auto Filter Single Column

[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?

 

[Guest]

FIltering applies to the entire row because otherwise the rows would miss-align

 

[Pete_UK]

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