Close Window   
Free Ebook
Got an Excel Question?
Ask it in our Excel forum!
Subscribe for Free Excel tips & more!

How Do I Print Just The Odd Or Even Numbered Pages.

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I have a printer that will not duplex, and so I am trying to print the odd
number pages and then turn over the paper and print the even numbered pages.
Can anyone tell me how to accomplish this. I thought it would be an easy
thing, but am having no luck? ThankS!

View Answers     

Similar Excel Tutorials

Print Only Specific Parts of a Worksheet in Excel
In Excel you can select parts of a worksheet to print while ignoring all of the other data on the worksheet. This a ...
Print the Current Date or Time in Excel
How to print the current date and or time on an Excel spreadsheet. This is a simple technique that allows you to di ...
Print All Worksheets at Once in Excel
How to print all worksheets at once from Excel. This saves you the time of having to go to each sheet individually ...
Print Gridlines in Excel
I'll teach you how to show gridlines for Excel when you print your files. This is a neat little feature that will ...

Helpful Excel Macros

Print Specific Pages in Excel
- This free Excel macro allows you to print a pre-specified selection of pages from Excel. This means you can print 2 pag
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
- This free Excel macro illustrates all of the possible parameters and arguments that you can include in the PrintOut Meth
Print all Embedded Charts in the Entire Workbook
- This macro will print every embedded chart in the active workbook. If you have an embedded chart in any worksheet within
Display the Print Window in Excel
- This free Excel macro displays the print window or dialog box in Excel. This is the same window that would appear when
Print Preview Screen Display for The Current or Selected Worksheets in Excel
- This free Excel macro allows you to display the print preview screen or window for the current or selected worksheets in

Similar Topics

I'm trying to find the right code to send a command to our printer to print two pages of a spreadsheet in duplex [i.e. both sides of the paper].

I can do it manually from the print screen and I have tried recording it but it doesnt record the properties.

I have to make it a default setting and that would print ALL pages in duplex which I dont want

Any help would be much appreciated


Eric Rossiter

I would like to be able to print an entire workbook with the pages of the
individual sheets numbered per the number of pages in that sheet.

For example, Sheet 1 has 5 pages I would like them numbered page 1 of 5,
etc, Sheet 2 has 6 pages-I would like them numbered 1 of 6, etc.----as I
print the entire workbook.

Can this be done. As I have it set up now, the entire workbook has 45
pages. I can print the individual sheets and get the results I want, BUT,
as I print the entire workbook, the pages are numbered 1 of 45, etc.

Thanks for your help.



I have a excel file, I want to print the content of file in A4 size paper. My printing requirement is:
I want to print on both sides of paper and on each side, it should print 2 pages (Pages per sheet =2). This is quite easy.
Another requirement is, I want to print like a directory, that means, after printing 4 pages in one A4 paper, if I cut the paper into halves, it should give correct pages on back.

In normal, I am able to print as, Page 4 behind Page 1 and Page 3 behind
Page 2.

My requiremtn is:Page 1 should be behind Page 2 and Page 3 should be behind Page 4.

I need VBA code to print two particular sheets of a workbook called
Sheet1 (tab named PR282) & Sheet2 (tab named PRpg2) to print on my HP printer duplexed front & back.

I have the printer preset to duplex, select both pages to print, & print, they print on separate pages instead of front & back (duplexed).

Any & all help greatly appreciated. mikeburg

I have a workbook with 21 single-page landscape-format worksheets in it. I would like to be able to use Win-XP's File/Print function to print only some of the worksheets in the workbook. That is, when I select File/Print, I'd like to be able to specify worksheets 1, 3-21 (I will never want to print worksheet 2). I can see where I can select specific pages to print but not how to select specific worksheets to print. Can I do this manually with File/Print?

I would also like to duplex the printing (printing worksheet 1 and three on the front and back of the same piece of paper, and 4 and 5, and 6 and 7 ... and so on through 20 and 21). My printer allows duplex printing to be selected from Properties under the printer selection within the File/Print process, but again, I'm not seeing how to select worksheets as opposed to pages for printing.

Finally, since my intention is to three-hole punch the landscape formated output for use in a three-ring binder, I would like the duplex printing to be a "tumble print" so that, for example, with the binder open, say, to worksheet 5 (on the right) and the binder then rotated 90-degrees clock-wise, the top of worksheet 6 will be just below the bottom of worksheet 5 for a straight read from top of one page to the bottom of the next. Would a "tumble print" require a special print driver?

I'm havening a problem figuring out how to only print a set amount of pages when i hit the print button, instead of going to file print and telling it how many pages to print. i have a template I'm using that is 9 pages long. i have a cell that is set up to count the number of pages in a report every time we start typing on the next page. ex( its says 1 of 1 until we type in the next page then says 1 of 2, the number in the cell keep getting bigger) is there anyway to have the print button just print how many pages i have typed into instead of all 9? thanks

I have forms I need to print, there are 21 pages, when I use the "Record Macro" on the Developer menu the block the range I need to print, press print, Set printer options ie

Select "Printer",
Settings = Print selected range, Print Landscape, Fit to Page.

The Print.

I then close the Record Macro. and try to run it.

I get an error command.

The macro show as:

Please Login or Register  to view this content.

Where the last line shows as the error.

Also, every time I block a range to print, press print key, the printer option set the entire worksheet to print, not just the part I selected.

With large worksheets this take several minutes, I've waited as much as 12 minute for the preview page to show before I can manually change the options.

I am attaching the file I need to print. This is all old data. I printed it manually one at a time.

Please note I need to print all the even pages first then turn the paper over to print the odd pages so it page 1 and 2 are on opposite sided of one page

Any help will be appreciated

I have a workbook with 4 spreadsheets, each taking 1 page to print.

I want Sheet 2 to print on the reverse side of Sheet 1 and Sheet 4 on the reverse of Sheet 3 so that all four pages of data takes 2 sheets of paper to print.

I have tried selecting 2 sheets at a time and 4 sheets at a time but printing result is always single sided even though "duplex" is selected in printer properties. In the Print dialog box I have tried selecting "Active Sheets", "Entire Workbook" and even "Selection". I've also tried specifying pages 1-4 rather than All. Eventually, by printing to a PDF creator, I have concluded that Excel is treating each tab is a separate print job. i.e. I get 4 separate PDFs.

I'm sure I've done this successfully before but I can't remember how.

Simple question..... with mazbe a possible answer.

At my internship they have an excel spreadsheet that will print as 56 pages. They want it to print in 8 pages. Preferably in 2 pages high 4 wide. I tried to specify it in the print setup... but it only makes the printed part of the pages smaller, therefor making it 117 printited pages, then alot of cutting, taping and puzzling.

Is there any way I can specify this without having to reformat the whole spreadsheet.

I know you probably will not be able to read it but this is how they want it.

Is there a way to send a print job for an entire workbook without any blank pages coming out of the printer?

For instance, suppose my pages numbers are labeled from top to bottom and then from left to right. Suppose also that I have text on pages 1, 3 and 4, and that page 2 is blank and is below page 1, and pages 3 and 4 are to the right of pages 1 and 2 respectively. If I just go to File, print, and hit enter, all 4 pages are printed, including the blank page #2.

Thanks for any help.


I have a worksheet that consists of 277 pages. I have a macro that hides pages if they end with a $0 amount. When I print, I want only the visible pages to print, but all 277 pages are printing. The hidden pages actually just come out as blank sheets of paper, but who wants to go through 277 sheets of paper and pull out all of the blank ones?

How to print odd pages and even pages seperately. For ex I have 100 pages
with page numbers customized to read "001" upto "100" and I want to print all
"Even pages" first then at the reverse side I want to print all "odd pages".

How to complete this task in two setp printing.

I have a workbook consisting of about 20 worksheets. I have VBA code that prints any sheet that is used but skips any pages that are not used. This works fine but if there are more than one user printing sheets at the same time on our network printer, the pages get all mixed together and they have to pick through the stack to find their pages. Is there a way that the used pages can be assembled and then all printed as one printjob so that each users pages will all print together simplifying the sorting process... Thanks


i have a worksheet in which cell N10 counts the number of cells in
column D that have entries, and using an if statement, determines how
many pages need to be printed in order to print all rows that have
entries. The cell displays 1, 2, or 3 [pages], depending on the number
of rows that are filled in. For example, if the count is greater than
62, 2 pages have to be printed. If less than 62, only one page need be
printed. I have to do this because there are formulas in other rows
that go down all the way to the 169th row and 3 pages will be printed
out if i dont specify in the print range the number of pages i need
printed. Is it possible to have a macro use the cell value of 1 or 2 or
3 and then print only the matching required number of pages.



I have a color printer that is set to grayscale as a default. When I print my
excel workbook and select it to print in color in the print driver properties
the first page prints in color but the other pages print in black and white
even though the other pages are in color.

Apologies if this has already been answered somewhere but I've searched for ages and can't find an answer.

I have a worksheet that when printed prints out 24 pages, excel does not allow me to print specific pages i.e. 3,5,7,9,11 only ranges i.e. 3-11. How can I overcome this, ideally I would like to have a button linked to a macro that will print the pages according to a cells content. ie. if the cell contained 5 it would print page 5.
I wonder if this could be taken a stage further to enable a number of pages to be printed out in one button push i.e. a range of cells containing numbers 3,5,9,11 to print out those pages.


I'm sorry you to trouble you all with a novice question but...

I have a worksheet that has 1254 pages. I will rarely be needing to print all of the pages. When I do print a range of pages, I need the footer to say "Page 1 of (how many pages I choose to print)".

For instance, if I print 515 pages, I will need the footer to read "Page 1 of 515, Page 2 of 515, Page 3 of 515, and so on".

So far, I've only been able to get Excel 2003 to say "Page 1 of 1254, etc..."

Any suggestions would be greatly appreciated.



I am trying to work out why when I print the attached excel spreadsheet it prints two extra blank pages.

I have done a print preview on the file and it print previews two extra blank pages.

When I print to paper or PDF it also adds two extra pages - see the attached PDF... half way through the last page there is some some of cursor on the screen.

Is anyone able to help me with this?

Hi all,

I'm a real illiterate when it comes to VBA. I have a simple question, though:

I managed to make (copy) a Macro that allows me to enter data into an Excel file through pop-up windows. At a certain point in time, the macro will print certain pages of the worksheet. In total 4 pages. I would like my printer to print the first two selections in recto-verso on one paper, and the other two each on one paper.

Is there a simple command to make the printer print the two first selections on one paper, two-sided? Or do I have to copy to Word and do it there?

Thanks for any answer!


Using Excel 2003 I am printing multiple sheets. I have a footer on every sheet that is in the format of: page # of total pages.

When I do a print preview page number and total number of pages looks correct on every page.

However when I actually print the file the total number of pages varies and some of the sheets have wildly incorrect total number of pages (i.e. 26 total pages instead of 16 and other variations).

In doing some searches in the message boards and yes my default print driver is the same as the the one I am actually using.

I have checked various page setup options all looks "safe".

The only thing I can think of is I am using PDF Creator as my print driver. Due to various reasons I have not had a chance to test with other print drivers except for doing Print Preview but not actually doing Print.

I would have thought that as PDF Creator from PDFforge should work fine on this file as I do this all the time on other Excel files with the product. All it is doing is just capturing the print format output.

Any thoughts or ideas of something to check.

I will be doing more testing and report what I find, but would love to keep useing PDF Creator.



I have a workbook with 4 spreadsheets, each taking 1 page to print. I want Tab 2 to print on the reverse side of Tab 1 and Tab 4 on the reverse of Tab 3 so that all four pages of data takes 2 sheets of paper to print.

I have tried selecting 2 tabs at a time and 4 tabs at a time but printing result is always single sided even though "duplex" is selected in printer properties. In the Print dialog box I have tried selecting "Active Sheets", "Entire Workbook" and even "Selection". Eventually, by printing to a PDF creator, I have concluded that Excel is treating each tab is a separate print job. i.e. I get 4 separate PDFs.

I'm sure I've done this successfully before but I can't rmember how.

I have VBA code which sets a print area but for some reason the printpreview tacks a couple more pages on the bottom (Ive tried palying with the pages breaks and it still does it).

Is there a way , apart from setting a print area, to limit the printed pages to, say,only pages 1-5 of the 10 shown on the print preview ?


I have a multipage userform on which I have placed a command button allowing the user to print out the form for their own records.

I found some code which nicely allows me to print off all pages- see below


Private Sub printButton_Click()
Dim curPage As Long
Dim iCtr As Long
curPage = Me.MultiPage1.Value
For iCtr = 0 To Me.MultiPage1.Pages.Count - 1
Me.MultiPage1.Value = iCtr
Next iCtr
Me.MultiPage1.Value = curPage

End Sub

The problem is that it is sending 2 print jobs to the printer- one for each page. My company insist everything is printed duplex and the printers are set up accordingly. But because there are 2 print jobs, it comes off single sided.

Can I amend the code to send just one print job?

Many thanks.

Hi All

I wish to print a 1 page worksheet on both sides of A4 paper. I've tried selecting 2 copies and long edge duplex, but get 2 sheets single side print, so:
I've created copy of sheet1 called sheet2 and slected print workbook and long edge duplex, but still same.

Iv'e tried copying sheet1 cells and inserting below a page break in same worksheet, but althought this does print duplex, the second side isn't same format as first.

I've also tried fit to 1 page wide and 2 pages tall but still no joy.

Any help please. Regards Simon

I have an Excel document that is composed of about 20 different sheets. Most are 2-3 pages long. I want the pages in each sheet to print duplex, but not print onto the back of the next sheet. I am having a problem with my three paged sheets ending up having the first page of the next sheet on the back. Is there any way to do this?