Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Multiple Print Areas on a Single Printed Page.

Multiple Print Areas on a Single Printed Page

Written by Allen Wyatt (last updated March 27, 2021)
This tip applies to Excel 97, 2000, 2002, and 2003


1

Ingrid set up her worksheet just the way she wanted, and then defined two non-contiguous areas on the worksheet as her print area. She first selected A1:C5, then held down the Ctrl key as she selected E3:G5. This selection was then defined as the print area (File | Print Area | Set Print Area). When Ingrid printed the worksheet, each of the selected ranges (A1:C5 and E3:G5) printed, but they printed on separate sheets of paper. Ingrid was hoping to get them on a single sheet of paper.

This happens because Excel automatically prints separate ranges on separate sheets of paper; there is no way to configure Excel to do this printing differently. There are a couple of things you can try as workarounds, however.

First, you could print multiple pages per sheet of paper. Follow these steps:

  1. Set your two ranges as your print area, as you have already done.
  2. Choose Print from the File menu. Excel displays the Print dialog box.
  3. Make sure the destination printer is properly selected at the top of the dialog box.
  4. Click the Properties button. Excel displays the Properties dialog box for the selected printer.
  5. Browse through the available tabs and controls. You are searching for one that allows you to set multiple pages per sheet of paper. Set this control so that 2 pages are printed per sheet of paper.
  6. Click OK to close the Properties dialog box.
  7. Click OK to print the worksheet.

The result, for most printers, is that Excel combines two printed pages on a single sheet of paper. It does this by reducing the size of each of the two pages and printing them in landscape mode on the page. If you cannot find a control that allows you to specify multiple pages per sheet (step 5), it may be that your printer driver doesn't offer this capability. In that case you won't be able to use this workaround and will have to try the next one.

The next solution involves simply creating a "print" worksheet. This sheet can contain references to the original data ranges, combining them on a single worksheet. You can then print the consolidation worksheet, as it will contain only the information you want sent to the printer.

A third option involves using the Camera tool. This tool allows you to capture dynamic "pictures" of different areas of your worksheet. The Camera tool is not available, by default, on any Excel toolbar. Instead, you need to add it to the toolbar. Choose Tools | Customize and make sure the Commands tab is displayed.

In the list of Categories, choose Tools, and then scroll through the Commands list until you find Camera. (Oddly enough, it has a small camera icon to the left of the command.) Drag the Camera command to a toolbar and drop it there. Close the Customize dialog box, and you are ready to use the Camera tool. Follow these steps:

  1. Select the range that you want to take a picture of. For instance, select A1:C5, the first part of the area you want to print.
  2. Click on the Camera tool. The mouse pointer changes to a large plus sign.
  3. Change to a different worksheet, preferably a blank one.
  4. Click where you want the top left-hand corner of the picture to appear. The picture is inserted as a graphic on the worksheet.
  5. Repeat steps 1 through 4, but select the other range you want printed (E3:G5).

Now you can manipulate the two pictures the same as you would any other graphic—stretch, resize, crop, or move them; whatever. The picture is not really a picture, however, even though it behaves as one. Instead, it is dynamic, meaning that if the contents of the original ranges are changed, then what is shown in the picture changes, as well. You can also print the worksheet containing the camera pictures, and they will appear on a single page.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2779) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Multiple Print Areas on a Single Printed Page.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Self-Deleting Macros

Macros are very powerful, but you may not want them to always be available to a user. Here are some ways you can limit ...

Discover More

Specifying Superscript Text

Applying different formatting to the text within a cell can seem a bit confusing. This is certainly the case when it ...

Discover More

Hyphenating a Selection

Word provides a hyphenation tool that can help you hyphenate words within a document. If you want to apply hyphenation to ...

Discover More

Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!

More ExcelTips (menu)

Printing a Single Column in Multiple Columns

Ever printed out a worksheet only to find that you have text only at the left side of each page? You can use more of each ...

Discover More

Centering Your Worksheet

Got just a small amount of worksheet data to print out? It might look better on the printed page if you center it. Excel ...

Discover More

Adding the Set Print Area Tool

Spend a lot of time defining print areas in your workbooks? You might benefit by adding a Set Print Area tool that makes ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is five more than 3?

2021-05-13 11:18:09

Stephen

Thank you for the tip about the dynamic camera function. It's great for what I need.


This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.