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


You may always use to print Excel worksheet in your daily work. But sometime you just need to print a particular chart of a worksheet or print multiple areas of a workbook; do you know how to do it?

You can print noncontiguous areas of your worksheet, and this just involves little more than selecting the cells you want to print. Why you may want to print noncontiguous areas of your worksheet?

Take an example, if you have sales data for several products, that each of them is in a worksheet column, you can choose and print only the columns that are of interest to you. How to do that?

Simple. Pressing and holding down the Ctrl key as you click and drag the intended areas you wish to print. After you select areas, you set them as the print area. If you need, you can preview the worksheet before hit the print button.

Note: If you are newbie, you may interest on basic Excel printing feature, please refer another article on quick Excel 2007 Printing. This article will guide you to print excel worksheet correctly.


To print Excel worksheet - Multiple areas of a workbook

  • Press and hold the Ctrl key as you click and drag to select each area you want to print.
  • Click the Page Layout tab.
  • In the Page Setup group, click Print Area icon and from the menu appears click the Set Print Area.
  • Excel 2007 set print area

  • In the Page Setup group, click the Print Titles icon.
  • From the Page Setup dialog box displayed, click the Sheet tab.
  • Excel 2007 page setup sheet tab

  • The areas you selected in the first step are shown in the Print area: column.
  • Click and drag the columns or rows you want to repeat or type the range.
  • Click the Print Preview button.
  • The Print Preview window shows the first page of the printout containing an area you selected in the first step.
  • Click the Next Page or Previous Page icons to view subsequent or previous pages.
  • The Print Preview window shows the next or previous page of the printout containing an area you selected in the first step above.
  • Click Print icon when you are satisfied with the layout.
  • Excel prints the selected multiple areas of a workbook.
  • Click Close Print Preview icon to finish.

Note: The above steps assume that you already installed the printer driver and printer is working fine and turn on.


To add or clear the print areas

  • You can add to the print area by selecting a range and clicking the Print Area icon in the Page Layout group and then click Add to Print Area option from the menu appears.
  • In the Page Setup group, click Print Area icon and from the menu appears click the Clear Print Area. Print Areas stay in effect until you clear them.


Related Topics:

Excel 2007 Print Preview Feature, Using Print Preview Before Printing

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

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 print Excel worksheet 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.