Insert page break won't insert page break

[JoshuaHefflinger]

SO I have a modestly long excel spreadsheet, and I would like it if it were divided into 3 even chunks.

To accomplish this task, I set out to use page breaks to tell my printer to only print in these three even chunks.

That was my plan however, as when I try to insert a page break, nothing happens, and the entire document is still listed as one giant page.

I'm using excel 2002.

Also, Is there a way to get my three even chunks to enlarge themselves to consume the entire page their delegated to?

Thank you very much.

 

[zeeeeks]

SO I have a modestly long excel spreadsheet, and I would like it if it were divided into 3 even chunks.

To accomplish this task, I set out to use page breaks to tell my printer to only print in these three even chunks.

That was my plan however, as when I try to insert a page break, nothing happens, and the entire document is still listed as one giant page.

I'm using excel 2002.

Also, Is there a way to get my three even chunks to enlarge themselves to consume the entire page their delegated to?

Thank you very much.

Did you try resetting the page breaks?

 

[JoshuaHefflinger]

I have it figured out, in page settings I had accidentally set it to print 1 page wide by 1 page tall, and that was artificially limitiing what I could do with page breaks. Setting it to 1 by 3 fixed the problem.

Also, adjusting size percentage in page settings fixed the size problem as well.