Yes if you split the window you can have subtotals at the bottom visible.
I wouldn't call that replicate though

--
Regards,

Peo Sjoblom

(No private emails please)


"John_Carty" <JohnCarty@discussions.microsoft.com> wrote in message
news:98F7AB84-C28B-41F1-A711-128A6A7DB378@microsoft.com...
>I find that difficult to believe since the autofilter capability, subtotal
> function, etc. are sill accessible. What about splitting the window to
> display the bottom of the spreadsheet where the subtotals do exist?
>
> "Peo Sjoblom" wrote:
>
>> You can't
>>
>> --
>> Regards,
>>
>> Peo Sjoblom
>>
>> (No private emails please)
>>
>>
>> "John_Carty" <JohnCarty@discussions.microsoft.com> wrote in message
>> news:FEE2CC1F-046F-49F3-BB5F-DAD87205F8F2@microsoft.com...
>> > How can I replicate the Excel 2003 LIST function in an earlier version
>> > of
>> > Excel, say 2000? I want to keep subtotals visible at the bottom of the
>> > worksheet at all times and to dynamically update when filters change.
>> > Although I am not concerned about inserting new rows...
>> >
>> > Any help is much appreciated.
>> >
>> > Regards,
>> >
>> > JC
>>
>>