Print the Entire Excel Workbook Instead of Only Printing Your Excel Spreadsheet.

Posted on December 24, 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.

As talked about in last Friday’s Excel Tip and Trick about setting your print area we are now taking it a little bit further.  

 

The next Excel Tips and Tricks article is for speeding things up a bit.

 

If you are working in Microsoft Excel and you press the print button or hit CTRL+P, the print defaults are that you only print the Excel Spreadsheet that you are working in.

If you only work on one Spreadsheet this isn’t a problem but if you are working with let’s say 10 sheet at the same time this could be an issue.

 

There are two options besides opening and printing each Excel Sheet.

 

The first is go to file, select print and then select the Entire Workbook in the dialog box (or press CTRL+P).

 

Excel Tip Trick

 

The Second option is to select the first sheet tab, hold down the Shift key, select the last sheet tab, and then click the Print tool on the toolbar (or again press CTRL+P).

Now your entire workbook will be printed.

 

I hope you liked this Excel Tip, talk to you all tomorrow!!

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

2 Responses to “Print the Entire Excel Workbook Instead of Only Printing Your Excel Spreadsheet.”

  1. ArahMan7 on December 25th, 2007 4:20 am

    Ho! Ho! Ho!

    May the Blessings of Christmas bring you Peace and Joy throughout the New Year.

    Greetings and lotta loves from Malaysia.

  2. Vincent on December 25th, 2007 2:57 pm

    Thank you ArahMan7. And the same for you, I wish you and your family all the best and good health for 2008.

Leave a Reply