Copy page layout and margin from sheet to sheet

G

Guest

Hi,

I was hoping someone could help...

I have 7 sheets in my workbook, all showing similar data in landscape.

The page setup at first was as default.

On the first sheet I have reduced the margins around the edge to make the
information spread across larger on the page.

I want this to apply to sheets 2-5, but not 6 and 7.

Any ideas that will save me going to each sheet and amending margins and
"Centre on page" options??

Many thanks.

Rajen
 
J

Jim Rech

When you 'group' worksheets, a change in Page Setup on the active sheet
affects all the grouped sheets. To group sheets press Ctrl or Shift as you
click on their tabs.

--
Jim
| Hi,
|
| I was hoping someone could help...
|
| I have 7 sheets in my workbook, all showing similar data in landscape.
|
| The page setup at first was as default.
|
| On the first sheet I have reduced the margins around the edge to make the
| information spread across larger on the page.
|
| I want this to apply to sheets 2-5, but not 6 and 7.
|
| Any ideas that will save me going to each sheet and amending margins and
| "Centre on page" options??
|
| Many thanks.
|
| Rajen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top