"Using the Excel 2007 Print Preview to Preview Spreadsheets Before Printing"


Imagine that you had been asked to print out a report. You can use the Excel 2007 Print Preview feature before you print any worksheet, section of worksheet, or entire workbook.

Print Preview shows you exactly how the worksheet data will be paged when printed and you can make last minute changes to the page settings or even the spreadsheet contents before sending it to the printer when everything looks okay.

Note: The keyboard shortcut for Print Preview: Ctrl + F2.


To switch to print preview

  • Click the Office Button and then point to Print and click on the Print Preview command.
  • Excel displays the first page of the report in a separate window with its own Print Preview contextual tab.
  • When finished previewing, click Close Print Preview.


Excel 2007 Print Preview Commands

As you can see, the print preview window contains several icons:

Excel 2007 print preview options

  • Print - Opens the Print dialog box. Clicking this icon while in Print Preview will returns to the Normal view.
  • Page Setup - Opens the Page Setup dialog box.
  • Zoom - Changes the size at which your worksheet is previewed.
  • Next Page - Previews the next page of your worksheet.
  • Previous Page - Previews the previous page of your worksheet.
  • Show Margins - Displays or hides sheet margins.
  • Close Print Preview - Returns to Normal view.

When Excel displays a full page in the Print Preview window, you can barely read its contents; so you can increase the view to actual size if you need to verify some of the information.


To zoom on Excel 2007 print preview

  • Click the Zoom icon in the Print Preview tab can zoom up to 100% (actual size) or
  • Click once on the previewed page with the magnifying-glass mouse pointer.
  • Press the keyboard PgUp and PgDn keys to scroll up or down the page, respectively
  • Press Ctrl + PgUp and Ctrl + PgDn to scroll left and right, respectively.


Related Topics:

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

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 print preview 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




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.