I need to set the "page setup" parameters differently for each page of a
spread sheet. Everytime I try the entire spread sheet changes.

Is there a global setup I missed?

When you say each page, do you mean each tab?

You can set up each tab separately. If a tab prints on multiple pages, you
can't have a different setup for each page.

--

Vasant




"Tony" wrote in message
...
I need to set the "page setup" parameters differently for each page of a
spread sheet. Everytime I try the entire spread sheet changes.

Is there a global setup I missed?

Tony

What do you consider a "page" to be?

What do you consider a "spreadsheet" to be?

Spreadsheet is a generic term for the type of Application that Excel is a
member of.

Quattro Pro is also a Spreadsheet Application.

Excel deals in Workbooks with multiple Worksheets.

Each Worksheet can have multiple "pages" when printing.

Each Worksheet can have different parameters from the other Worksheets.

You cannot set up the parameters differently for each "page" printed from a
Worksheet unless you break the sheet up into more than one print job.


Gord Dibben Excel MVP

On Tue, 1 Feb 2005 14:31:06 -0800, "Tony"
wrote:

I need to set the "page setup" parameters differently for each page of a
spread sheet. Everytime I try the entire spread sheet changes.

Is there a global setup I missed?

Thanks for the response. I wanted the second page on a tab to be different
margin-wise than the first. Have to go to plan B
Tony

"Vasant Nanavati" wrote:

When you say each page, do you mean each tab?

You can set up each tab separately. If a tab prints on multiple pages, you
can't have a different setup for each page.

--

Vasant




"Tony" wrote in message
...
I need to set the "page setup" parameters differently for each page of a
spread sheet. Everytime I try the entire spread sheet changes.

Is there a global setup I missed?

Thanks I was hoping to set the margins on the second page of a TAB within a
workbook, different from the first. Looks like I need to go to Plan B.
Regards. Tony

"Gord Dibben" wrote:

Tony

What do you consider a "page" to be?

What do you consider a "spreadsheet" to be?

Spreadsheet is a generic term for the type of Application that Excel is a
member of.

Quattro Pro is also a Spreadsheet Application.

Excel deals in Workbooks with multiple Worksheets.

Each Worksheet can have multiple "pages" when printing.

Each Worksheet can have different parameters from the other Worksheets.

You cannot set up the parameters differently for each "page" printed from a
Worksheet unless you break the sheet up into more than one print job.


Gord Dibben Excel MVP

On Tue, 1 Feb 2005 14:31:06 -0800, "Tony"
wrote:

I need to set the "page setup" parameters differently for each page of a
spread sheet. Everytime I try the entire spread sheet changes.

Is there a global setup I missed?