File/ Page Setup/ Page/ fit to 1 page tall?
--
David Biddulph

"Jimbob" wrote in message
...
I don't think that's working. Let me try another example so you can
understand what i mean.

In cell J62 i have "SUM(J1:J61)"

If i then add in 10 additional rows of figures on that page the sum
formula
is pushed down to cell J72. Which when I print out hard copies has pushed
my
total on to the next page, which is no good.

I want the "SUM" formula in cell J62 to remain fixed in cell J62 no matter
what happens above it.

Does that make sense ???

If this is what the offset function does I can't make it work.

"David McRitchie" wrote:

You want to use the OFFSET Worksheet Function, see
http://www.mvps.org/dmcritchie/excel/offset.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jimbob" wrote in message
...
I have a spreadsheet that totals up a column at the bottom of each page
(using SUM) so that when it's printed off a total is at the bottom of
each
page. However when I edit that sheet and add or delete items, the total
figure is pushed up or down the page and I have to recalculate the
total.
When you've got 20 pages in one sheet and you alter page 1 it's a pain
when
it messes up every following page.

How can i fix a cell or row of cells so that no matter what i add or
delete
above it, that row stays fixed.

e.g with my current page setup (A4 size) row 62 is the bottom row of
the
first page, with 124 being the second page and so on. I want to fix row
62 so
that the SUM function in those cells never moves no matter how many
additonal
rows i add in above it ?