Page break dosen't break

  • Thread starter Thread starter infodex
  • Start date Start date
I

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?
 
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?
Click to expand...

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?
 
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?
Click to expand...

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

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...
 
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...
Click to expand...

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