Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print selected pages from multiple worksheets
When I go to file print, I can select different pages from one worksheet but
how can I select different pages from different worksheets in the same workbook? Example- I have 5 worksheets in a workbook. Each worksheet has 10 pages configured for printing. How can I select- Page 1 & 7 from worksheet 1 Pages 2 & 5 from worksheet 3 Pages 4 & 9 from worksheet 5 ....all to print at once? Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print selected pages from multiple worksheets
You can do this with the Report Manager add-in for Excel. Unfortunately, MS
stopped providing RM after Excel 2002 (in Office XP). Fortunately, that version of RM can be used with later versions of Excelm including 2007. See http://support.microsoft.com/kb/873209/en-us -- TedMi |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print selected pages from multiple worksheets
Thanks Tedmi.
I tried downloading, but they do not seem to add in Excel 2003. I was wondering if a Macro could be available which one of the macro experts may be able to provide. Thanks again. "tedmi" wrote: You can do this with the Report Manager add-in for Excel. Unfortunately, MS stopped providing RM after Excel 2002 (in Office XP). Fortunately, that version of RM can be used with later versions of Excelm including 2007. See http://support.microsoft.com/kb/873209/en-us -- TedMi |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print selected pages from multiple worksheets
For 2003, DO NOT execute the download. Instead, use WinZip to extract
RptMgr.xla and then copy it to the location specified in the instructions given he http://support.microsoft.com/kb/873209/en-us -- TedMi |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print selected pages from multiple worksheets
Thanks Tedmi.
This seems to be working, I will just have to get used to it. If you do find a macro wherein you can select page numbers, please let me know. Thanks "tedmi" wrote: For 2003, DO NOT execute the download. Instead, use WinZip to extract RptMgr.xla and then copy it to the location specified in the instructions given he http://support.microsoft.com/kb/873209/en-us -- TedMi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing single pages from multiple worksheets in a single print job | Excel Discussion (Misc queries) | |||
How do I print a workbook in but only print selected worksheets? | Excel Discussion (Misc queries) | |||
Multiple pages after printing selected area | Excel Discussion (Misc queries) | |||
How do I print out selected worksheets one after the other | Excel Worksheet Functions | |||
Print several worksheets at once with fewer pages | Excel Discussion (Misc queries) |