IS THERE ANY POSSIBILITY OF PRINTING EVEN PAGES ALONE OR ODD PAGES ALONE IN EXCEL?
Menu
PRINTING EVEN PAGES 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.
Recent Threads
- Check ITR1 on income tax Form ITR1 Instead of 1 ho
- Form 121 requirement
- Interest on reversal of ITC when ITC balance avail
- Is MirrorFly an Instant Messaging Software?
- ITR filling for legal heir
- How Can I qualify CA Final Exam?
- Wrong reporting on 22 april 2026 under article inc
- Articeship Form 107
- TAN for Multiple States
- Delivery Challan serial number Issue and return ru
Related Threads
CAclubindia
