"How to Print Multiple Worksheets from a Workbook?"


If you have been asked to print multiple worksheets at one time, do you know how to do it? This tutorial will guide you.

By default, Microsoft Excel 2007 prints either the entire active worksheet or a selected print area within the active worksheet. However, you can select and print multiple worksheets at the same time.

To select two or more adjacent sheets for printing, hold down the Shift key and click the tab (such as Sheet 1, Sheet2, etc) for each sheet you want to print. To select several nonadjacent worksheets, hold down the Ctrl key and click the tab for each sheet you want to print.


To print multiple worksheets

  • Press and hold down the Ctrl key.
  • Click to select the individual tabs you want to print (for example Sheet 1 and Sheet 3). You can click Chart tabs, Sheet tabs, and tabs you have renamed.
  • Release the Ctrl key. You will notices that the selected tabs appear white.
  • From the Page Layout tab, click the Page Setup group launcher.
  • Excel 2007 page setup group launcher

  • From the Page Setup dialog box displayed, select the Sheet tab and click Print Preview. Each worksheet appears on its own page. The first worksheet you selected will appears first.
  • You can click the Previous Page and Next Page icons to review the selected sheets.
  • Click Print icon when you are ready to print. Excel prints the selected worksheets.


Note: You may want to print multiple worksheets if you have a workbook with data or charts on several separate sheets.


To print all worksheet in the workbook

  • Right-click any tab.
  • From the menu appears, click Select All Sheets.
  • From the Page Layout tab, click the Page Setup group launcher to open the Page Setup dialog box.
  • Do the necessary changes and hit the Print icon/button.


The Page Setup dialog box Sheet tab options

  • From the Page Layout tab, click the Page Setup group launcher will open the Page Setup dialog box.
  • Excel 2007 page setup options

  • Check the Gridlines option will print the worksheet gridlines. Black and white option will turn your colorful page to the black and white.
  • Check the Row and column headings option enable you to print row numbers and column letters on every page.
  • To print comments, select an option in the Comments field. You can print comments adjacent to their cells or gather them at the end of the report.


Note on grouping the sheets

Bear in mind that selecting multiple tabs groups the sheets. While the sheets are grouped, any data you type into any sheet or any changes you make to the structure of sheets are also typed into or changed in all the other sheets in the group.

To ungroup sheets

  • Click any unselected sheet.
  • If no unselected sheet is visible, right-click any sheet and click Ungroup Sheets from the menu appears.


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!

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



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

Custom Search


Back to Top

You're viewing the print multiple worksheets 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.