"Excel 2007 Printing - Use the Easy Method to Print in Microsoft Excel 2007!"


This tutorial shows you how to use the Excel 2007 printing tool to print your Excel worksheets.

The printing in Excel 2007 is easy if you just want to use Excel's default print settings to print all the cells in the current worksheet.

If you already add the Quick Print button to the Quick Access toolbar (by clicking Customize Quick Access Toolbar button and then clicking Quick Print on its drop-down menu), then just click on the button will print out the worksheets.

This fast method of printing will print a single copy of all the information in the current worksheet, including any charts and graphics but not comments you add to cells. If you want more copies, or just a cell selection within a particular worksheet, then you need to print using the normal way - the Print dialog box.


To print using the Print dialog box

  • From the Office Button, click on Print or press the keyboard shortcut: Ctrl + P.
  • Excel 2007 print dialog box

  • From the Print dialog box displayed, there are several options:

    All - Selecting this option will print all the pages in the document.
    Page(s) - Allow you to choose range of pages to print. To reprint a single page, enter its page number in both the From and To text boxes (same).
    Selection - Print the cells that are currently selected in the workbook.
    Active Sheet(s) - If you select to print multiple worksheets, use this option.
    Entire Workbook - Print all the data in each of the worksheets in your workbook.
    Table - Print only the data range that is formatted as a table.
    Number of Copies - enter the number of copies you want to print in this box.

Note: Do remember to check the printer name - the printer name that attached to the PC and driver is preinstalled.

After finish choosing all the options, just click the OK or press Enter will send the job to the printer for printing. However, it's good to open the report in Excel 2007 Print Preview window for last-minute checking before sending it to the printer.

When you finish previewing the report, the Print Preview tab offers several options. One of the option is the ability to print out the spreadsheet with the Print command. Click on the button/icon will display the Print dialog box and print the report from the normal worksheet view.


Related Topics:

Excel 2007 Print Preview Feature, Using Print Preview Before Printing

How to Print Excel Worksheet and Printing Multiple Areas of a Workbook?

Guide on Printing Multiple Worksheets from a Workbook in Microsoft Excel?



Can't find what you're looking for? Try Google Search!

Custom Search


Back to Top

You're viewing the Excel 2007 printing info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007



***z-amazon-excel2007book.shtml***



XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.