How do you attach tabs to make one page or several pages?

[Guest]

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?

 

[MyVeryOwnSelf]

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.

 

[MyVeryOwnSelf]

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.

 

[Guest]

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)

 

[Guest]

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)

 

[Gord Dibben]

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

 

[Gord Dibben]

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