Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with filtering columns in Excel 2007
I'm trying to filter out blanks from a particular column but when I select
that with auto-filter, only the first 246 lines are filtered, The remaining columns are still displaying blanks. Before applying the filter I make sure that all filters were cleared. I also checked that the unfiltered cells did not contain any invisible spaces. I would be grateful if anyone can through any light on the problem! Thanks! -- Richard in Chester |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with filtering columns in Excel 2007
Before activating the autofilters, make sure you entire range of info is
selected. It sounds like XL is only including the first 246 rows of data in the dataset to be filtered. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Richard" wrote: I'm trying to filter out blanks from a particular column but when I select that with auto-filter, only the first 246 lines are filtered, The remaining columns are still displaying blanks. Before applying the filter I make sure that all filters were cleared. I also checked that the unfiltered cells did not contain any invisible spaces. I would be grateful if anyone can through any light on the problem! Thanks! -- Richard in Chester |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering in Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 Filtering range | Excel Discussion (Misc queries) | |||
Filtering in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Filtering Problem | Setting up and Configuration of Excel | |||
Excel 2007 - Filtering and copying | Excel Discussion (Misc queries) |