Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Workbook Print Settings
Hi, can't figure out how to set identical Print Settings for every worksheet
in Workbook without having to set each indiv worksheet in same Workbook??? thanks for ur help! |
#2
|
|||
|
|||
Good morning tccc1219 Try this trick. Select the sheet you want to use as the source. Then, with ctrl held down, select all the sheets you want to copy the settings to. Then goto File Page Setup and when the dialog box appears clickOK. All the print settings will then be copied across. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=384437 |
#3
|
|||
|
|||
Note:
Some print settings are not available when sheets are grouped. 1. Print range 2. Rows to repeat at top, columns to repeat at left. Gord Dibben Excel MVP On Tue, 5 Jul 2005 04:36:51 -0500, dominicb wrote: Good morning tccc1219 Try this trick. Select the sheet you want to use as the source. Then, with ctrl held down, select all the sheets you want to copy the settings to. Then goto File Page Setup and when the dialog box appears clickOK. All the print settings will then be copied across. HTH DominicB |
#4
|
|||
|
|||
Hello Dominic B :-)
Just want to THANK YOU so very much for your great help!!!! Your instruction worked, of course!!!! and helped me out tremendously (beats setting page settings for "every" worksheet in multi-page workbooks!) Thanks again for taking the time to help those of us still figuring Excel things out! Have a GREAT day! Christine "dominicb" wrote: Good morning tccc1219 Try this trick. Select the sheet you want to use as the source. Then, with ctrl held down, select all the sheets you want to copy the settings to. Then goto File Page Setup and when the dialog box appears clickOK. All the print settings will then be copied across. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=384437 |
#5
|
|||
|
|||
Hello Gord D !
I basically worded my question wrong because I was actually looking to format the "page settings" across mutliple worksheets in a workbook. But the information you provided is great because I was not aware of that! So thanks so much for taking the time to help me out! Have a GREAT day! Christine "Gord Dibben" wrote: Note: Some print settings are not available when sheets are grouped. 1. Print range 2. Rows to repeat at top, columns to repeat at left. Gord Dibben Excel MVP On Tue, 5 Jul 2005 04:36:51 -0500, dominicb wrote: Good morning tccc1219 Try this trick. Select the sheet you want to use as the source. Then, with ctrl held down, select all the sheets you want to copy the settings to. Then goto File Page Setup and when the dialog box appears clickOK. All the print settings will then be copied across. HTH DominicB |
#6
|
|||
|
|||
I just tried that and I got the first 12 of 31 changed to the new settings.
From worksheet 13-31 the old settings still appear. "dominicb" wrote: Good morning tccc1219 Try this trick. Select the sheet you want to use as the source. Then, with ctrl held down, select all the sheets you want to copy the settings to. Then goto File Page Setup and when the dialog box appears clickOK. All the print settings will then be copied across. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=384437 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
Formatting all sheets in a workbook to print the same | Excel Discussion (Misc queries) | |||
How do I print all sheets of an Excel workbook from explorer? | Excel Discussion (Misc queries) | |||
print entire workbook default | Excel Discussion (Misc queries) |