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)

9

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

Editing Individual Cells

Need to edit the data within a cell? There are any number of ways you can perform the edit; this tip documents them all.

Discover More

Writing a Macro from Scratch

Recording macros is a great approach to getting started with macros, but at some point you'll need to create one from ...

Discover More

Counting Odds and Evens

If you have a series of values in a range of cells, you may wonder how many of those values are even and how many are odd. ...

Discover More

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!

More ExcelTips (ribbon)

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 be ...

Discover More

Printing Workbooks in a Folder

This tip presents two techniques you can use to print multiple workbooks all at the same time. Both techniques involve ...

Discover More

Printing Selected Worksheets

When you accumulate quite a few workbooks in folder, you might need to print out selected worksheets from all of the ...

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 8Mpixels. 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 7 - 0?

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.