GST Plus - Get Daily updates,support, whatsapp Group & reply to GST Notices etc.!! Call : 011-411-70713 !!

ICICI

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

CA B Anand (CHARTERED ACCOUNTANT)     13 November 2010

PRINTING EVEN PAGES IN EXCEL

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



 10 Replies

Yogesh Shah

Yogesh Shah (Managing Corporate Finance)     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
CA B Anand

CA B Anand (CHARTERED ACCOUNTANT)     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

Manoj Garg (Support on Tally Excel Password Recovery etc.)     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: 939 times
kanagaraj

kanagaraj (CHARTERED ACCOUNTANT)     14 November 2010

Dear Manoj,

I downloaded the file nothing found.Pl explain

Manoj Garg

Manoj Garg (Support on Tally Excel Password Recovery etc.)     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
CA B Anand

CA B Anand (CHARTERED ACCOUNTANT)     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.

Manoj Garg

Manoj Garg (Support on Tally Excel Password Recovery etc.)     16 November 2010

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

 

Regards,

Manoj Garg

CA B Anand

CA B Anand (CHARTERED ACCOUNTANT)     17 November 2010

K MANOJ.

Manoj Garg

Manoj Garg (Support on Tally Excel Password Recovery etc.)     24 November 2010

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

Attached File : 14 print odd even.zip downloaded: 525 times
Vijay Lodha

Vijay Lodha (Owner)     24 November 2015

Copy the above mentioned macro to PERSONAL.XLSB File.


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  


Related Threads


Loading
Start a New Discussion

Popular Discussion


view more »







Subscribe to the latest topics :
Search Forum:

Trending Tags