View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Footer on last page?

You could create a macro that would print any way you wanted--including the
special header with the totals.

But I wouldn't do this. I'd use a separate worksheet with formulas that
calculate those totals. Then just print that sheet when you wanted.

Or sort your data, then use Data|Subtotals to get counts/sums and those would
show up at the bottom.

T wrote:

Is it possible to have a footer print on the last page only of a worksheet?

We are using a spreadsheet as a signin sheet. It would be nice to have some
totals at the bottom that can be filled in manually for Total, New, Alumni,
Returning. We had envisioned just having those blanks at the bottom of the
last page and someone would do the counts and write those in.

Thanks


--

Dave Peterson