It's handy to know if you copy some new data under data in a sheet
which already has filters set up - if you do not leave a blank row then
the filter range will automatically include the extra records. Pity it
doesn't automatically extend named ranges which you might have set up
with the first lot of data (unless they are dynamic) - I suppose we get
used to these inconsistencies !! <bg

Pete

Bob Phillips wrote:
I also tend to put totals at the top, far more robust. That Excel is damn
smart isn't it?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Pete_UK" wrote in message
ups.com...
I discovered this in the dim and distant past, as I now put totals on
the top row. It seemed that Excel maintains an "active range" over
which the filters apply, and if you add anything to any cell in the
blank row below this, then the filter range gets extended.

Pete

Bob Phillips wrote:
"Pete_UK" wrote in message
ups.com...
Apply a filter to your data, then move to the bottom of the data.
Leave
at least ONE blank row (ensure that the filter is not active for this
row, by checking the colour of the row indicator), and click the SUM
icon in the appropriate cell below this blank row - this will
automatically convert to SUBTOTAL(9, ...) and as it is outside the
range used by the filter it will always be available.

So there you go! I didn't know that. Can't see me ever using it, but at
least I know now <G