page breaks

[randall martin]

I want to insert a page break "automatially" while or after creating
rows numbered 1 to 500, in order to number 500 prewritten pages. Is
this possible?

randall martin
(e-mail address removed)

 

[Dave Peterson]

I think the answer depends on what you mean.

Do you want a page break after each row of the 500 rows? Seems kind of odd...

XL can change the print range depending on what cells you've used. If you type
something into those cells, then do a print preview, you can see where these
natural page breaks occur.

Go Huskies!