Free Microsoft Excel 2013 Quick Reference

Printing odd even pages Results

Is there a fast and easy way to print odd and then even pages in Excel? Perhaps a macro.
Thanks in advance for any help with this.
--Dan

In Word and many other programs with printing facilities, there's an
option to choose whether to print all odd or even pages. I sometimes
find that handy, in order to print on both sides of the paper. Maybe
I'm not looking in the right place, but is there no such feature in
Excel 2000 please?

--
Terry, West Sussex, UK

I am using this macro to print all of the odd or even pages in the active worksheet:
Sub Print_Odd_Even()
    Dim Totalpages As Long
    Dim StartPage As Long
    Dim Page As Integer

    StartPage = 1  '1 = Odd and 2 = Even

    'Or use the InputBox suggestion from Gord Dibben
    'StartPage = InputBox("Enter 1 for Odd, 2 for Even")

    Totalpages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
    For Page = StartPage To Totalpages Step 2
        ActiveSheet.PrintOut from:=Page, To:=Page, _
                             Copies:=1, Collate:=True
    Next
End Sub
I am trying to edit the macro code to print all of the odd or even pages in every worksheet in the active workbook without any success.

I tried changing the
 and it still only prints the odd or even pages active worksheet.

What changes do I need to make to print every worksheet in the active workbook?

Thanks,
Jason

Can anybody tell me
1. How to print all/ some Odd pages or Even pages in Excel.
2. How to print some specified pages only (ex: 1,5, 8 to 10).

Without using macros. It is a tedious job for me.
Advance thanks.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

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.

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.

Can anybody tell me
1. How to print all/ some Odd pages or Even pages in Excel.
2. How to print some specified pages only (ex: 1,5, 8 to 10).

Without using macros. It is a tedious job for me.
Advance thanks.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I know I did it before and know I can't find it. I am trying to print on
both sides of the paper by printing first odds and then even pages. I am
using excel 2000 in windows xp

I need to print only odd pages & then even pages
so paper will be double sided

I need to print only odd pages & then even pages
so paper will be double sided

Hi,

Can any body tell me
1. How to print all/ some Odd pages or Even pages in Excel.
2. How to print some specified pages only (ex: 1,5, 8 to 10).

Advance thanks.

Bye.

NAVEEN

Hi,

Is it possible to print odd and then even pages in Excel?
If so, how?

Matt

I want to print double sided. The even numbers on one side and the odds on
the other. Is there a way to do this in Excel

I need to print basic terms and conditions at the end of a Quotation. This will take up about 1/3 of a page. I also need to keep the standard footer with Pg * of Pg * on each page.

I find options for different "First page" and "Odd & Even pages", but nothing for a last page.
Can someone please point me in the right direction or send me a HELP link?

Thanks for your time.

I want to print odd pages only so I can print even pages on other side to
save paper.

When printing a document of various pages in length, using VBA code to set it, I need:

Odd pages of document (page 1, 3, 5, etc) to have:
Right margin of 4.375
Left margin of 0
Top margin of 0
Bottom margin of 4.75

Even pages of document (pages 2, 4, 6, etc) to have
Right margin of 0
Left margin of 4.375
Top margin of 0
Bottom margin of 4.75

Can someone help? thanks, mikeburg

Hi there.

I have a large report which I've had to split into two separate reports so that it can actually be printed (2 A3 landscape reports that is) and need to sort out page numbering. As this is part of a report to be sent to a client it's quite important that I get it right!

At the moment I have the following in a textbox:


	VB:
	
="Appendix D6 Cont... (" & [Page] & "/" & [Pages] & ")" 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
which works for a single report, but is there a way that I can make it work for both reports.

So, for example, page one of report 1 reads "Appendix D6 Cont...(1/20)"; and page one of report 2 reads "Appendix D6 Cont...(2/20)"

Page 1 should then continue with only the odd pages, and report 2 with only the even pages. That way, when they are reported / printed the tables will be in the right order.

Does that make sense? I hope it does.

Thank you in advance.

AL

In Word I would just print odd pages, then even pages on the reverse.

But how do you do it in Excel?

Thanks and regards,

Richard Oldcorn

I need to print Excel documents (landscape A4) on both sides of the paper,
and bind them along the long edge. Thus I need an extra margin gutter along
the top of odd pages, and along the bottom of even pages. (It's wasteful to
put the extra margin on both top and bottom of every page...) Using Excel
2002 SP1.

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!


No luck finding an answer? You could always try Google.