ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I print several sheets in a workbook as one file, making t. (https://www.excelbanter.com/excel-discussion-misc-queries/20926-how-do-i-print-several-sheets-workbook-one-file-making-t.html)

aimeesue78

How do I print several sheets in a workbook as one file, making t.
 


Duke Carey

Please post your question in the body of the message. It is truncated and we
have to guess.

My guess is that you simply need to select the tabs you want to print by
clicking on the tab for the first sheet to print, then press & hold the
Control key while clicking on the other tabs you want to print. When all are
selected, click on the print button

"aimeesue78" wrote:



JulieD

my guess is you're looking for the report manager add-in (which allows for
consecutive page numbers, different views / scenarios per sheet, differenet
sheet order etc) ... in version 2000 it is found under tools / add-ins and
then can be accessed from the view menu
with 2002 & 2003 you need to download it from microsoft's website and follow
the instructions for installing it. if this is what you're after post back
and i'll dig out the appropriate page in the ms site for you.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Duke Carey" wrote in message
...
Please post your question in the body of the message. It is truncated and
we
have to guess.

My guess is that you simply need to select the tabs you want to print by
clicking on the tab for the first sheet to print, then press & hold the
Control key while clicking on the other tabs you want to print. When all
are
selected, click on the print button

"aimeesue78" wrote:






All times are GMT +1. The time now is 09:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com