TheExcelAddict.com
Microsoft Excel "Quick Tips"

Setting The Print Area With One Click

Setting the print area using File, Print Area, Set Print Area is a task we all do frequently. Do you have the Set Print Area button on your toolbar?

Depending on which version of Excel you are using, the Set Print Area tool may or may not be included on your toolbar. If it isn't, here’s how to get it:

  1. From the View menu select Toolbars, and then click Customize.
  2. Click on the Commands tab and in the Categories box select File.
  3. In the Commands section scroll down till you see the Set Print Area button.
  4. Hold down your left mouse button and drag it on to an existing toolbar.


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 TheExcelAddict.com/Newsletter.htm and you could win a really cool t-shirt.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright © 2002 All Rights Reserved by FJH Marketing

Close this window