I'm trying to make one file out of an excel worksheet that has 3 worksheets.
I don't want 3 files, I need to make 3 pages. Then I'm going to convert it
to Adobd PDF. How do I make the pages. How do I attach them to end of each
worksheet?

I'm trying to make one file out of an excel worksheet that has 3
worksheets. I don't want 3 files, I need to make 3 pages. Then I'm
going to convert it to Adobd PDF. How do I make the pages. How do I
attach them to end of each worksheet?

I'm not quite sure what you mean.

If your aim is a PDF file with three pages, I’ve done it this way. It’s not
elegant, admittedly.

Print the workbook to the “Microsoft Office Document Image Writer.” This
opens a “Microsoft Office Document Imaging” window for each worksheet.

Next, combine the worksheets into a single document. To do this, notice
that each of the “Imaging” windows has a left pane with thumbnails of the
page(s). Using right-click, “Copy” one or more thumbnails from the left
pane of one window and “Paste” it into the left pane of another. Repeating
this, the entire document can be merged into a single window. Finally,
print from that window.

Hope this helps.

If you do this sort of thing a lot, you might want to look into
http://fineprint.com/products/fineprint/index.html
for an add-on program that (among many other features) can combine several
print jobs into one, with fewer steps than using Image Writer.

You can select all three tabs at the same time then convert to Adobe. There
are many ways to select the tabs: right click on a tab and choose select
all, hold the control key down and click the tabs with your mouse, are a few.

(not sure if this is an issue - we "own" the full Adobe and can do the above
conversion)

"warrior1" wrote:

I'm trying to make one file out of an excel worksheet that has 3 worksheets.
I don't want 3 files, I need to make 3 pages. Then I'm going to convert it
to Adobd PDF. How do I make the pages. How do I attach them to end of each
worksheet?

You need a short course in terminology.

A file is a workbook.

A workbook can contain multiple worksheets.

A worksheet when printed can comprise multiple pages.

You have a workbook with 3 worksheets.

This is one file, not 3

The number of pages per sheet will depend upon data range and print area
settings for that sheet.

The number of pages per workbook is the total pages from the 3 worksheets.


Gord Dibben MS Excel MVP


On Tue, 19 Sep 2006 14:28:02 -0700, warrior1
wrote:

I'm trying to make one file out of an excel worksheet that has 3 worksheets.
I don't want 3 files, I need to make 3 pages. Then I'm going to convert it
to Adobd PDF. How do I make the pages. How do I attach them to end of each
worksheet?