Skip to main content
  1. Tech
  2. Gadgets & Tech
  3. Tech Gear

Excel Tip: How to Scale Printing

See also

Many Excel spreadsheets can use multiple pages of paper to print. However, when you scale the printing, you can print much more, using much less paper. This Excel tip will show you how to scale printing using various versions of Excel.

Excel spreadsheets can get very large, very quickly. And, how do you fit all of that information on one page? Well, you may need more than one page, but Excel allows you to scale your data as much as you need.

Excel 2007 & 2010 & 2013:

Click on the Page Layout Tab

In the Scale to Fit area, change the percentage to a smaller number or use the "Width" and "Height" fields to select the number of pages to force Excel to scale the printing.

Excel 2003 and older:

To scale your spreadsheet, follow these steps:

Choose File | Page Setup

Select the "Page" Tab (Should be the Default Tab)

In the Scaling area of the dialog window, specify how you would like to scale the document. You have the option to scale to a percentage or fit to a certain number of pages that you wish.

Once you have chosen the Scaling options, I recommend to click on the Print Preview button to make sure the spreadsheet will print how you would like.

Should you need to make changes, simply Close the Print Preview window and you will return to the Page Setup to make any necessary adjustments prior to printing.

NOTE: I do not recommend scaled printing for final presentations. Many people will not be able to read the smaller print. However, scaled printing is a great option while working on a current spreadsheet or to use when you simply need back-up documentation.

I hope this Excel tip has helped your spreadsheets look nicer.

For more of tips like this, Subscribe to Go Ask Debbie on Examiner.

Advertisement

Don't Miss

  • Unity
    'Assassin's Creed Unity' preview: Ubisoft comes home to its urban origins
    Games Preview
  • Smart vending machine
    This smart vending machine will recommend drinks for you based on your gender and age
    Video
    Tech Buzz
  • Destiny
    The 'Destiny' beta: 7 things we absolutely love about Bungie's new franchise
    Games Feature
  • Wi-Fi
    Find out how to stretch your Wi-Fi signal where it has never gone before
    Tech Tips
  • Far Cry
    'Far Cry 4' exclusive: Animals, avalanches, oxygen, side content and much more
    Games Interview
  • Gamer ghost
    Gamer finds and plays with ghost of deceased father on a classic game
    Video
    Headlines