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

Linking to Slides in PowerPoint

If you are preparing a document that references a presentation you created in PowerPoint, you may want to reference in ...

Discover More

Changing Huge Numbers of Hyperlinks

Need to change the various targets of a group of hyperlinks? Getting at the underlying link can seem challenging, but it ...

Discover More

Labeling X-Y Scatter Plots

Figuring out how to get the data points in an X-Y scatter plot labeled can be confusing; Excel certainly doesn't make it ...

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 (ribbon)

Specifying an Order for Page Printing

If a printout of your worksheet requires multiple pages, you may want to specify the order in which Excel prints those ...

Discover More

Showing Print Preview for the Current Page

The Print Preview feature in Excel can be quite helpful. You might think it would be more helpful, though, if it ...

Discover More

Changing Cell Values while Printing

When printing mulitiple copies of the same worksheet, you may have a need to change something simple for each 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 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 three less than 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.