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

How To Print Just A Small Section Of Your Worksheet

So you've spent hours getting your spreadsheet just the way you want it. All 10 pages of it. Now you need to print out a small part of the spreadsheet but you really don't want to print all ten pages. What do you do? Do you mess around with your PrintArea and print settings and hope that you can remember how to set them back?

A quick and risk-free way to print part of your spreadsheet without changing any PageSetup settings is by using the Print Selection option.

Here’s how:

  1. Select the range of cells you want printed;
  2. from the File menu select Print...;
  3. in the 'Print' dialog box select Selection and click OK.
Go ahead try it now. See how easy this is?

Can you think of how many times you could have used this in the past?

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.