Hi All,
A colleague has a problem in Excel XP which has completely stumped me! When she applies AutoFilter to a list the filter is not applied to the bottom row of data. We've formatted the row so it's identical to the ones above - no luck. We have even copied a row from above and pasted the data into the bottom row - still no luck. We've tried highlighting the whole spreadsheet and then applying the AutoFilter - again, no luck.
The bottom row doesn't seem to be included in the AutoFilter range as when the data is filtered the row number does not turn blue and the row is visible whether the row meets the criteria or not. If we go into Advanced Filter the default range always stops one row above the final row.
Anyone know how this happens and how to correct it?
Thanks.
A colleague has a problem in Excel XP which has completely stumped me! When she applies AutoFilter to a list the filter is not applied to the bottom row of data. We've formatted the row so it's identical to the ones above - no luck. We have even copied a row from above and pasted the data into the bottom row - still no luck. We've tried highlighting the whole spreadsheet and then applying the AutoFilter - again, no luck.
The bottom row doesn't seem to be included in the AutoFilter range as when the data is filtered the row number does not turn blue and the row is visible whether the row meets the criteria or not. If we go into Advanced Filter the default range always stops one row above the final row.
Anyone know how this happens and how to correct it?
Thanks.