I have one worksheet, with 5, 10, 15 tabs.
When I print the whole worksheet, different tabs print differently.

Is there a way to make all the Tabs print the same without having to go to
each tab and fix the print settings?( 11 X 17 Landscape for instance).

Select all tabs
(Right Click on any Tab and choose Select ALL
or click on the first and Shift-Click on the last tab)
Choose Page Setup and choose your settings...

"ArthurMailloux" wrote:

I have one worksheet, with 5, 10, 15 tabs.
When I print the whole worksheet, different tabs print differently.

Is there a way to make all the Tabs print the same without having to go to
each tab and fix the print settings?( 11 X 17 Landscape for instance).

Most print settings can be done on all sheets that have been "Grouped"

Right-click on a sheet and "Select all sheets" or shift and CTRL + Click to
select some sheets only. What you set on the active sheet will be done to
all in the grouping.

Some print settings are not available in group mode............

Print Range and Rows to Repeat at Top are two not available.

You would need VBA to achieve that.


Gord Dibben MS Excel MVP

On Mon, 1 Dec 2008 10:54:02 -0800, ArthurMailloux
wrote:

I have one worksheet, with 5, 10, 15 tabs.
When I print the whole worksheet, different tabs print differently.

Is there a way to make all the Tabs print the same without having to go to
each tab and fix the print settings?( 11 X 17 Landscape for instance).