Page break dosen't break

[infodex]

In Excel 2003, I have a small spreadsheet (24 colums by 50 rows).

I want to print 25 rows on each page, so inserted a page break at row
26. However, when I print the sheet it all prints on one page. Looking
at it in Page Break view shows the break is indeed there, it just
doesn't work.

Any ideas why?

 

[Gordon]

In Excel 2003, I have a small spreadsheet (24 colums by 50 rows).

I want to print 25 rows on each page, so inserted a page break at row
26. However, when I print the sheet it all prints on one page. Looking
at it in Page Break view shows the break is indeed there, it just
doesn't work.

Any ideas why?

Isn't there an option in the Page Setup dialog to Fit to one page wide
by two (or however many you want) pages long?

 

[infodex]

Isn't there an option in the Page Setup dialog to Fit to one page wide
by two (or however many you want) pages long?

There is a "Pages per Sheet" option, but it doesn't make any
difference if I set it to 2 pages.

 

[Gordon]

There is a "Pages per Sheet" option, but it doesn't make any
difference if I set it to 2 pages.

No - it's on the Page Setup dialog box. (Sorry, have 2007 here so I'm
working from memory). The one that has Page, Margins, Header/Footer and
Sheet as tabs. On the Page tab there's a "Fit to" option under Scaling...

 

[infodex]

No - it's on the Page Setup dialog box. (Sorry, have 2007 here so I'm
working from memory). The one that has Page, Margins, Header/Footer and
Sheet as tabs. On the Page tab there's a "Fit to" option under Scaling...

That did it. Thanks. I was looking in the Print dialog and not finding
anything.