Often an Excel worksheet is just a bit too wide to print on one page. You could change it to Landscape orientation, so more will fit across, but you may prefer to keep it in Portrait orientation, especially if it's a long list.
In Excel's Page Setup dialog box, you can adjust the scaling so the sheet will fit across on one page.
- On the Page tab, click the 'Fit to' option for Scaling.
- Enter 1 as the number of page(s) wide.
- Clear the box for the number of pages tall, then click OK.
This will limit the file to printing one page across, but won't limit the number of pages down. You don't have to guess the number of pages required, just leave it blank and Excel will figure it out for you.
_____________
Cool, I didn't know you could clear the box. I always put an extremely high number like 1000.
I thought the same thing as Saul, 'cept I never used a high number... can't recall what I have done in the past, I would try to adjust until the desired results were seen.
Thanks