June 9, 2008

Excel – Make It Fit the Page

Do you have an MS Excel worksheet that is sized just barely over the width of a page? If so, if you need to print it on one page only, that extra width is a problem, isn't it?

So, what did you do?

Maybe you went back to the worksheet and started adjusting the column widths or maybe you started changing the margins to accommodate your printing needs.

Whatever you did, I bet it was a painful process and maybe even impossible.

How would you like a method with just one setting that ensures the worksheet will print on exactly the number of pages you require?

Interested?

Yeah, I thought you might be!

If you're using older versions of MS Excel, what you're looking to do is make a quick change in the Page Setup window. You can get there through the File menu, Page Setup choice.

  • Now, you're looking for the Page tab.

  • In the center section (the Scaling section), you need the "fit to" choice.

  • When you make that selection, you have a couple of settings to change. If you look closely, you'll notice it actually says "fit to # page(s) wide by # tall." The number of pages is what you need to change.

    If you want the worksheet to print on a single page, just set it to 1 page wide by 1 tall. If the printed data columns are long, you may need 1 page wide by 2 tall. You get the idea. Excel then scales everything down to fit on exactly the number of pages you've specified, with no column width changes required!

  • Once you've entered your settings, click OK to save the changes and return to the worksheet. Or, you can choose Print Preview to take a look at your handy work.

For those of you working with Excel 2007, you'll need to look in best price generic propecia a slightly different place. What you need is on the Page Layout ribbon.

  • You're specifically looking for the Scale to Fit section.

  • In that section, you'll find a setting for both Width and Height. Each of them have a drop down list where you can set the maximum number of pages for printing in whichever direction you need.

  • Make a choice and Excel will then adjust your worksheet immediately.

I love this one. It certainly beats column width and/or margin changes anytime!

Permalink • Print • Comment

Leave a comment

You must be logged in to post a comment.

Made with WordPress and an easy to use WordPress theme • Sky Gold skin by Denis de Bernardy