Page break dosen't break


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?
 
Ad

Advertisements

G

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?
 
I

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.
 
G

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...
 
Ad

Advertisements

I

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top