So, you're getting 7 pages, but the page numbers aren't there or aren't going
1 - 7 then?

If that's the cae, go to View - Header and Footer... and ensure "Page 1"
(without the quotes) is selected.

If that doesn't rfix it, then I'd start questioning your workbook...

"learningaccess" wrote:

hi kevin and sean...

I did what you said... inserting a page break beneath the row in question.
it just won't take. the page number doesn't renumber. It's not working. is
there a glitch with this function in any versions of exceL?

I have gotten it to work on a similar spreadsheet but it's not working on
this one for some reason.
--
Thanks!


"Kevin B" wrote:

Did you move to row below the point where you want to insert a page break and
click INSERT in the menu and select PAGE BREAK?

By Header do you mean repeating rows or columns, or row & column headings?
If yes you would find those on the menu under FILE, PAGE SETUP. Then click
the SHEET tab as set repeating rows or click the checkbox to indicate
row/column headings.

If you want a custom header/footer click the HEADER/FOOTER tab and make your
entry there.
--
Kevin Backmann


"learningaccess" wrote:

thanks for your advice but it did not answer my question. I need seven
separate page breaks in particular places to print out seven pages of
information that share the same header info. I'm having the problem with
inserting the page breaks where I want them. they're not inserting.

--
Thanks!


"Sean Timmons" wrote:

From worksheet view:

Page Setup

Under Page tab, scaling - Select Fit to 1 - 7 pages

Under sheet tab, Row to Repeat at Top: A:A for Row A only.

click Gridlines in Print section below.

"learningaccess" wrote:

Hi... I'm trying really hard to break a worksheet into six or seven pages - 1
wide by seven tall. Sounds simple enough, but I'm having a devil of a time
accomplishing this. Have gotten it to work in the past but it's fickle. Are
there specific chronological steps that should be taken each time?

I also need the same header row and gridlines on each page.

Please let me know.
Chris
--
Thanks!