"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

How To Squeeze Your Worksheet To Print One Page Wide

If you have worksheets that you need to print one page wide but they are too wide there is a much easier solution than taking drastic actions like reducing your font size or making your columns too narrow. Here's what to do:
  1. From the File menu click Page Setup.
  2. Click the Page tab.
  3. For Scaling click the Fit To option
  4. Enter the scaling to be 1 page(s) wide and blank the pages tall box.
You have just set Excel to print your worksheet so that it prints only one page wide but prints however many pages tall that is necessary.

Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.