Which Rows and Columns are you Printing? Use the Print Area.

Posted on December 21, 2007 
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

  Here are a few posts the other readers recommend you check out.

Of course you can just press the print button or press CTRL+P but this isn’t always useful. If you only need a small part of your Excel Spreadsheet it’s better to use the “print area” option.

 

With the Print Area option you select a specific number of rows, columns or cells that you want to print. Everything else in your spreadsheet will not be printed.

 

To use the Print Area option you first need to select the rows, columns or cells that you want to print.

 

Then in Microsoft Excel 2003 you need to:

  • Go to File.
  • Then select Print Area.
  • Select Set or Clear.

 

Excel tip trick

 

In MS Excel 2007 you need to:

  • Go to Page layout.
  • Then select Print Area.
  • Select Set or Clear.

 

Excel tip trick

 

I hope you’ll enjoy this Excel Tip and Trick. On Monday ill show you some more advanced print options. Have a great weekend!!

Do you want to see more? This is related...

Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 3 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





Comments

One Response to “Which Rows and Columns are you Printing? Use the Print Area.”

  1. Gary R. Hess on December 22nd, 2007 8:13 pm

    Good tip! I wouldn’t have known it if I hadn’t taken accounting classes.

Leave a Reply