autofilter with summary row

  • Thread starter Monkey-See, Monkey-Do
  • Start date
M

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.
 
M

Monkey-See, Monkey-Do

Perfect - thanks

Per Jessen said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top