Please Note: This article is written for users of the following Microsoft Excel versions: 2007 and 2010. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Printing Only Selected Pages.

Printing Only Selected Pages

by Allen Wyatt
(last updated February 5, 2016)

10

Excel provides several controls that help you control exactly what you print. Normally when you print, you would print the entire worksheet. However, Excel allows you to specify that only specific pages of the worksheet be printed. This comes in handy if you have used Page Break Preview or Print Preview to look at your worksheet, and you determine that you don't need all the pages that Excel would otherwise print.

To print only selected pages, follow these steps if you are using Excel 2007:

  1. Display the Print dialog box. (See Figure 1.) The easiest way to do this is to just press Ctrl+P.
  2. Figure 1. The Print dialog box.

  3. In the Pages area of the dialog box, indicate the page numbers that you want to print.
  4. Click on OK.

When you specify the pages to print, in step 2, you can separate page numbers by commas. Thus, if you wanted to print pages 4 and 7, you should enter "4,7" (without the quote marks) in the Pages area of the dialog box. You can also specify ranges of pages to print. This means if you wanted to print pages 3 through 5 and page 9, you would enter "3-5,9" (again without the quote marks).

All of this works just fine, to this point, in Excel 2007. If you are using Excel 2010, things are different. When you press Ctrl+P you see the printing options on the File tab of the menu, but there is no "Pages" box (step 2). Instead, the options allow you to specify a beginning and ending page range for printing. If you try to get fancier and enter something like "3-5,9" then Excel removes the dash and command and ends up trying to print page 359.

This "simplification" in Excel 2010 is, unfortunately, a step backwards in flexibility when compared to earlier versions of the program.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12467) applies to Microsoft Excel 2007 and 2010. You can find a version of this tip for the older menu interface of Excel here: Printing Only Selected Pages.

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

Shortcut for Selecting a Data Range

Want to select all the data in a contiguous section of a worksheet? The shortcut discussed in this tip makes it very easy.

Discover More

EOMONTH Function is Flakey

Some users have reported problems using the EOMONTH function in later versions of Excel, beginning with Excel 2007. The ...

Discover More

Using a Single-Column Heading in a Multi-Column Layout

Want different numbers of columns all on the same page? Word makes it easy to use, for instance, a heading that uses a ...

Discover More

Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!

More ExcelTips (ribbon)

Adding Page Borders to a Printout

Need a full-page border on your Excel printouts? It's not as easy to get one as you might wish. There are a few ways you ...

Discover More

Selecting a Paper Source

When you print a worksheet, you may want to specify that the printout be done on a particular paper tray in a particular ...

Discover More

Creating a Multi-Worksheet Report

It is not uncommon to use Excel to print out regular reports. If your report needs to span multiple worksheets, here's ...

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}] 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 9 - 4?

2018-03-15 16:00:17

len richard

All fine and dandy. How about showing an example for 2007. do you enter 4,7 in the first window .... where


2016-04-21 12:38:29

Willy Vanhaelen

This tip is wrong. Print only specific pages eg: 1-5,15,17-20 works in Word but not in Excel.

In Excel you can only print a range of contiguous pages: from starting page to end page.


2016-04-21 03:26:21

Ather

i am unable to print specified pages in excel 2003.Could i anticipate answer from your end


2016-02-16 07:47:51

Lasse

Those who have problems with the comma separation, try a semi-colon ";".

It seems that it is only in US that commas are working as a separator, the rest of us needs to use ";"

I need to change the commas each time to semi-colon if I copy a formula.


2015-10-16 06:00:36

GailJ

Excel 2013: I want to print only specific pages eg: 1-5,15,17-20. I don't mind using commas all the way through but the pages X to X does not allow commas as in older versions of Excel. Alternatively, if the rows on certain pages are 'hidden' how do print the visible rows only.


2013-02-11 05:25:47

JohnM

I have Excel 2007 and get the error message "integer not valid".


2013-02-10 21:37:25

Colin

This issue is explained in the 4th last para beginning "All of this works just fine,.." and the following para.


2013-02-10 15:55:45

Bart

So I take it then Allen that it is impossible to print only selected pages in Excel 2010 ??? One can only print a range of pages.


2013-02-09 19:17:03

JohnM

I get the same


2013-02-09 15:19:01

HalV

When I try to follow this tip, printing pages 1 & 3 using the entry method in either or both pages boxes from & to, I get an error message saying "integer not valid."


This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu 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.