Go Ad-Free on CAclubindia with Daily Mobile Updates. Subscribe Now!

PRINTING EVEN PAGES IN EXCEL

CA B Anand (CHARTERED ACCOUNTANT) (198 Points)

13 November 2010

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

Reply
Follow
Share

10 Replies

Yogesh Shah (Managing Corporate Finance) (1051 Points)
Replied 13 November 2010

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.

1 Like

Upgrade to CAclubindia Pro. Subscribe Now!

CA B Anand (CHARTERED ACCOUNTANT) (198 Points)
Replied 13 November 2010

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

IT SAYS THAT INTEGR IS NOT ALLOWED.

Manoj Garg (Support on Tally Excel Password Recovery etc.) (1987 Points)
Replied 13 November 2010

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

Attached File : 44 print odd even.xls downloaded: 1069 times

kanagaraj (CHARTERED ACCOUNTANT) (793 Points)
Replied 14 November 2010

Dear Manoj,

I downloaded the file nothing found.Pl explain

Manoj Garg (Support on Tally Excel Password Recovery etc.) (1987 Points)
Replied 15 November 2010

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

1 Like

Upgrade to CAclubindia Pro. Subscribe Now!

CA B Anand (CHARTERED ACCOUNTANT) (198 Points)
Replied 16 November 2010

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.