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

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

I'm looking to put some text only as a footer on the last page.

The counts we use are manual only but we need some text to guide us on
those. It would be nice to put it on the last page in the footer so we don't
waste another page.



"Dave Peterson" wrote:

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

I guess I'd remove the footer, print pages 1 through n-1, apply the footer and
print page n.

T wrote:

I'm looking to put some text only as a footer on the last page.

The counts we use are manual only but we need some text to guide us on
those. It would be nice to put it on the last page in the footer so we don't
waste another page.

"Dave Peterson" wrote:

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


--

Dave Peterson