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

Double-Clicking to Widen Columns Won't Work

One way you can widen the columns in a worksheet to fit whatever is in the column is by double-clicking the right edge of ...

Discover More

Adding Serial Commas in a Sentence

Part of the job of an editor is to apply standards of grammar to text written by someone else. One standard that may need ...

Discover More

Determining the MAC Address for a Network Device

MAC addresses are used to uniquely identify devices attached to your network. If you need to figure out what MAC address ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More ExcelTips (ribbon)

Changing Orientations within a Single Printout

Excel allows you to print out information in either portrait or landscape orientation, but what if you need both types of ...

Discover More

Printing Multiple Pages On a Piece of Paper

If you want to save paper on a printout, you might consider printing multiple pages on a single piece of paper. This can ...

Discover More

Out of Kilter Borders

Borders not printing properly? It could be any one of a number of reasons causing the problem. This tip provides some ...

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 1 + 3?

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.