Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Filter in Column
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? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 (Beta) Auto Filter | Excel Worksheet Functions | |||
filter options in excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Beta Advanced Filter Performance | Excel Discussion (Misc queries) | |||
Excel 2007 PivotTable Named Sets as a filter | Excel Discussion (Misc queries) | |||
Excel 2007 PivotTable Report Filter area not working | Excel Discussion (Misc queries) |