Hi Confused - hopefully not for long!

With filters, the visible lines can be above the dropdown arrows of the
filters or below the selection that was filtered.
I'm assuming that your subtotals are at the bottom of your data, in
which case getting the subtotals to always show, is done by selecting
the range before applying the autofilter (nb actual filter, not just
filter criteria).

To always show another row you may need to (shortcuts may work
depending on version of Excel):
*Remove the autofilter eg [alt + d + f + f],
(My understanding is that if you insert the row while there is an
existing autofilter the new row would be incorporated into the filter
range therefore I remove it first.)
*Insert a row between your subtotal & data eg [alt + i + r],
*Select the range to filter excluding the subtotal row & the new row
above it (depending on layout maybe able to use, [ctrl + home], [ctrl +
shift + end], [shift + up arrow + up arrow])
*Replace autofilter eg [alt + d + f + f], and
* you should be away laughing!

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=554005