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

A Shortcut for Switching Focus

Word provides keyboard shortcuts for lots of things, but it doesn't provide one for switching to the desktop and back to ...

Discover More

Comparing Strings

As your macro is processing information, there will doubtless be times that it will need to compare information in ...

Discover More

Counting with PivotTables

One of the ways you can use PivotTables is to generate counts of various items in a data table. This is a great technique ...

Discover More

Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!

More ExcelTips (ribbon)

Printing Only Non-Blank Worksheets

If you have a workbook containing many worksheets, you might want to print only those worksheets that have some sort of ...

Discover More

Specifying Print Quantity in a Cell

When you print a worksheet, you can specify in the Print dialog box how many copies you want printed. If you want the ...

Discover More

Hiding a Hyperlink on a Printout

Hyperlinks can be real handy in a workbook, but you may not always want them visible when you send the workbook to 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 six more than 8?

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.