How to Print Workbook in Excel

This topic has been explained in great detail in the video shown below, to learn this topic just play the video and the notes are mentioned below the video.


How to Print Workbook in Excel






Print a worksheet or workbook in Excel

The Video above explains how to Print a Workbook Worksheet in  Excel. The Text below is from a Microsoft Excel Support Blog

You can print entire or partial worksheets and workbooks, one at a time, or several at once. And if the data that you want to print is in a Microsoft Office Excel table, you can print just the Excel table.
You can also print a workbook to a file instead of to a printer. This is useful when you need to print the workbook on a different type of printer from the one that you originally used to print it.

Print a partial or entire worksheet or workbook

  1. Do one of the following:
    • To print a partial worksheet, click the worksheet, and then select the range of data that you want to print.
    • To print the entire worksheet, click the worksheet to activate it.
    • To print a workbook, click any of its worksheets.
  2. Click Microsoft Office Button Office button image , and then click Print.Keyboard shortcut  You can also press CTRL+P.
  3. Under Print what, select an option to print the selection, the active sheet or sheets, or the entire workbook.

    NOTE: If a worksheet has a defined print area, Excel will print only the print area. If you don’t want to print a defined print area, select the Ignore print areas check box.

TIP: To print quickly or to preview the printout before you print, click Microsoft Office Button Office button image , click the arrow next to Print, and then click Quick Print or Print Preview.

 

Print several worksheets at once

  1. Select the worksheets that you want to print.How to select multiple worksheets
    To select Do this
    A single sheet Click the sheet tab.

    Active sheet tab

    If you don’t see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab.

    Tab scrolling buttons

    Two or more adjacent sheets Click the tab for the first sheet. Then hold down SHIFT while you click the tab for the last sheet that you want to select.
    Two or more nonadjacent sheets Click the tab for the first sheet. Then hold down CTRL while you click the tabs of the other sheets that you want to select.
    All sheets in a workbook Right-click a sheet tab, and then click Select All Sheets on the shortcut menu.

    Tip    When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.

  2. Click Microsoft Office Button Office button image , and then click Print.Keyboard shortcut  You can also press CTRL+P.

TIP: To print quickly or to preview the printout before you print, click Microsoft Office Button Office button image , click the arrow next to Print, and then click Quick Print or Print Preview.

 

Print several workbooks at once

All workbook files that you want to print must be in the same folder.

  1. Click Microsoft Office Button Office button image , and then click Open.Keyboard shortcut  You can also press CTRL+O.
  2. Hold down CTRL and click the name of each workbook that you want to print.
  3. On a computer that is running Windows Vista
    • Right-click the selection, and then click Print.On a computer that is running Microsoft Windows XP
    • In the Open dialog box, click Tools, and then click Print.

 

Print an Excel table

  1. Click a cell within the table to activate the table.
  2. Click Microsoft Office Button Office button image , and then click Print.Keyboard shortcut  You can also press CTRL+P.
  3. Under Print what, select Table.

 

Print a workbook to a file

  1. Click Microsoft Office Button Office button image , and then click Print.Keyboard shortcut  You can also press CTRL+P.
  2. In the Name box, select the printer on which you want to print the file.
  3. Select the Print to file check box, and then click OK.
  4. In the Print to File dialog box, under Output File Name, type a name for the file that you want to print.

NOTE: If you print a workbook to a file so that you can later print the file on a different type of printer from the one that was originally used to print the document, the page breaks and font spacing may change.








Our Other Services




Read Free Ebooks

myeboook.com

Myebook has 1000's of free ebooks for you. On productivity, health, online income, learning, music and many more, it's free of course!



Buy Excel Course

myelesson.org/product

Become an Excel Guru, Buy the best Excel course. Learn on your mobile, tv & laptop without internet. For COD, Call 9752003788



Create Best Looking Resume

http://www.makecv.org/

At Makecv.org you get to create a amazingly professional looking resume in just 3 steps with our intuitive resume builder!


Download Excel Crash Course


This Excel Crash Course contains the list of topics that cover the most important and used features and formula of Excel . This Excel Crash Course lists 43 major topics in Excel so that you can start using Excel like a pro in the shortest possible time.



Learn Photoshop Web Designing


You can Buy the Photoshop Course to learn Photoshop and start a career in Web Designing and Photo Editing. .



Learn HTML CSS


You can Buy the HTML CSS Course to learn HTML CSS and start a career in Web Designing and Photo Editing. .


Download Full list of Excel Shortcuts


This Excel Shortcuts Complete list is to help you become save time and use Excel like a Master level user. Excel is best used when you know the Keyboard shortcuts because the use of keyboard shortcuts in Excel helps you in completing tasks faster.

I have created a Excel Shortcuts complete list for you to use Excel better, this list has 242 excel keyboard shortcuts which means that it covers almost everything that can be done using shortcuts in Excel.




Full List of Excel Formulas

This is a complete alphabetical list of all the Formula in Excel with a description. You can learn all these formulas on www.Myelesson.org




Convert Numbers to Text in Excel

Now easily convert numbers to Text in Excel with this inbuilt sheet from myelesson.org .  Many times we need the amount in figures to be converted into words. This is a typical requirement for writing checks or any other financial reports. Microsoft Excel does not have standard function available for this requirement. Just download this sheet and then you can convert any number to text in Excel.




List of Most Commonly Asked Excel Questions in Interviews

Here is the list of most asked excel related questions in interviews.  Prepare for this excel questions and you would be able to most of the excel interviews. This list of excel questions covers excel formula, excel analysis, excel reporting, excel charts and more.





Myelesson © 2010 - 2014. All rights reserved.

Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok
Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok