autofilter with summary row

[Monkey-See, Monkey-Do]

Does anyone know how (or whether it's even possible) to setup an autofilter
while excluding the last row. I have a worksheet with columns of data which
I'd like to use the standard autofilter on but the last row of my spreadsheet
contains certain summaries (e.g. sales totals) which I'd like to remain
visible even when I use the autofilter drop downs at the top of the sheet.

Any advice would be appreciated.

Cheers.

 

[Monkey-See, Monkey-Do]

Perfect - thanks

Hi


Insert a emtpy line above the Summaries, and set the row height for this
line to 1.

Now you can filter the lines above the empyt line and summaries will alvays
show.

Hopes this helps.