#1   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7,247
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Printing --Borders are not printing on the same page as data Stup88 Excel Discussion (Misc queries) 1 August 7th 07 09:34 AM
Printing a heading on each new page when printing Brian Excel Discussion (Misc queries) 3 November 15th 06 05:22 PM
printing pathan New Users to Excel 3 May 30th 06 04:23 AM
printing Eddie Excel Discussion (Misc queries) 6 August 24th 05 06:26 PM
Enable Double sided printing contiuously when printing multiple s. Lee Excel Discussion (Misc queries) 1 November 27th 04 01:58 AM


All times are GMT +1. The time now is 04:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"