Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing 2 Q
How can I make that the printing set up for the first tab applies to the rest
of the tabs in the excel file. Thanks, jose |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing 2 Q
If you are manually setting the page setup parameters, you can Group two or
more worksheets. ANY change made to a sheet when sheets are grouped is made to all the grouped sheets. Be SURE to ungroup the sheets once you are finished; otherwise you may really screw things up, perhaps irretrievably so. To group a set of adjacent sheets, click the first sheet tab to be grouped, hold down the SHIFT key and click on the last sheet to be grouped. To group a set of non-adjacent sheets, click on the first sheet tab to be grouped, hold down the CTRL key and click on all the other sheets to be grouped. The word "[Group]" will appear in the Excel window caption. Once the sheets are grouped, make your changes. Ungroup the sheets by either clicking on the tab of a sheet that is not groups or right-click on a sheet tab and choose Ungroup. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2008 Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Joe" wrote in message ... How can I make that the printing set up for the first tab applies to the rest of the tabs in the excel file. Thanks, jose |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
Printing a heading on each new page when printing | Excel Discussion (Misc queries) | |||
printing | New Users to Excel | |||
printing | Excel Discussion (Misc queries) | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) |