banner_ad

PRINTING EVEN PAGES IN EXCEL

Excel for Finance 5972 views 10 replies

IS THERE ANY POSSIBILITY OF PRINTING EVEN PAGES ALONE OR ODD PAGES ALONE IN EXCEL?

Replies (10)

YES its possible.

Go to File - Print - Pages --- specify page no.s you want and separate them by comma e.g. if you want only even pages then spacify as 2,4,6,8 like this.

BUT FRND, IN EXCEL 2003, I COULD ABLE TO PRINT BY FOLLOWING YOUR PROCEDURE.

IT SAYS THAT INTEGR IS NOT ALLOWED.

This option is not present in Excel. You have to use the Macro, which is attached herewith.

Dear Manoj,

I downloaded the file nothing found.Pl explain

To go to Macro Codes Press Alt + F11, Copy the codes and paste it into your Excel File. Save it, Run Macro and you will be able to print all the Even Pages. If you want to Print Odd Pages change 2 to 1 in Macro Codes. Manoj Garg

AND MANOJ, I TRIED WAT U'VE SAID AND ITS WORKING BUT CAN WE ENABLE THE SAID MACROS IN ALL OUR EXCEL FILES? I MEAN WITHOUT OPENING THE DOWNLOADED FILE, CAN WE SAVE THAT MACROS IN OUR ALL EXCEL FILES. SO THAT WE CAN TAKE PRINT OUT , WITHOUT OPENING THE DOWNLOADED FILE.

I will prepare the file and upload in a couple of days.

 

Regards,

Manoj Garg

K MANOJ.

Attached herewith an Addin. Paste it in Addin Folder. Use Ctrl + Shift + M to activate.

Copy the above mentioned macro to PERSONAL.XLSB File.


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
26 May 2026
Senior Accountant cum purchase Manager

Vardhaman Group of India

Pimpri Chinchwad

CA Inter

View Details
Company
Featured 26 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
19 May 2026
Fundraising Expert

MentorsWorld Ventures Private Limited

Ahmedabad

Others

View Details
Company
18 May 2026
MIS Executive

Primarc Pecan Retail Limited

Mumbai

B.Com

View Details
Company
10 June 2026
Senior Account Executive

JDS Advisory LLP

Ahmedabad

CA Inter

View Details
Company
19 May 2026
Article, CA & Paid Assistant Positions

Aggarwal Sarawagi and Co

New Delhi

CA

View Details
Company
21 May 2026
Associate

PWC

Kolkata

CA

View Details
Company
ARTICLESHIP 23 May 2026
Article Assistants

Acupro Consulting

Gurgaon

CA Inter

View Details