View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do you attach tabs to make one page or several pages?

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?