can you set the "Page Setup" margins etc. differently for each pag

[Tony]

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?

 

[Vasant Nanavati]

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.

 

[Gord Dibben]

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

 

[Tony]

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

 

[Tony]

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