Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Filtering range
Hi,
I have a list in Excel 2007 that I have applied an auto-filter to. For some reason the auto filter (when I run it) only applies to a certain number of rows. At the bottom of the filtered data remnants of unfiltered data remains. Anyone experience this? I tried converting the range to a table. Making it a named range. Turning the auto-filter on and off - nothing. Any help would be appreciated. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Filtering range
Hi
If there is a empty row in the table you have this problem If you select the whole table first do you have the same problem then ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message ... Hi, I have a list in Excel 2007 that I have applied an auto-filter to. For some reason the auto filter (when I run it) only applies to a certain number of rows. At the bottom of the filtered data remnants of unfiltered data remains. Anyone experience this? I tried converting the range to a table. Making it a named range. Turning the auto-filter on and off - nothing. Any help would be appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Filtering Problem | Setting up and Configuration of Excel | |||
Filtering times in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 - Filtering and copying | Excel Discussion (Misc queries) | |||
Double Filtering in Excel 2007 | New Users to Excel |