Print An Excel Sheet On One Page

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.

  1. On the Page tab, click the 'Fit to' option for Scaling.
  2. Enter 1 as the number of page(s) wide.
  3. Clear the box for the number of pages tall, then click OK.

PageSetupTall

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.

_____________

2 comments to Print An Excel Sheet On One Page

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>