View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Excel 2007 Filter in Column

You can remove the check mark from Select All, then check the value that
you want.

Steve300 wrote:
The default filters are no longer usable because when you open the filter all
choices are selected and you can only un-select one at at time. For a long
list this is impractical. Even worse, if you click a row you may accidentally
clear it's selection so the result will be all of the rows except the ones of
interest.

Does anyone know of a way to quickly filter on a single value?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html