Print all tabs the same
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). |
Print all tabs the same
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). |
Print all tabs the same
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). |
All times are GMT +1. The time now is 02:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com