Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy Page Setup from Sheet to Sheet?
Is there a simple way to copy the page setup (eg margins, page orientation)
or must I continue to go through the whole process for each sheet? |
#2
|
|||
|
|||
Right click on any one sheet and then click select all sheets
Now go to page setup This will change settings on all the pages "blank" wrote in message ... Is there a simple way to copy the page setup (eg margins, page orientation) or must I continue to go through the whole process for each sheet? |
#3
|
|||
|
|||
Depress the right mouse button on a tab sheet and select all sheets.
Select Page setup and do what you have to. Depress the right mouse button on a tab shhet and select ungroup, failure will result in things you do to one sheet being replicated in all the sheets (including deleting cells). HTH - Pank "blank" wrote: Is there a simple way to copy the page setup (eg margins, page orientation) or must I continue to go through the whole process for each sheet? |
#4
|
|||
|
|||
well well well and to think that for years and years i have not known
you could right click on the sheet tab thanks very very much "N Harkawat" wrote in message ... Right click on any one sheet and then click select all sheets Now go to page setup This will change settings on all the pages "blank" wrote in message ... Is there a simple way to copy the page setup (eg margins, page orientation) or must I continue to go through the whole process for each sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Is there a way to apply "page setup" defaults to an existing work. | Excel Discussion (Misc queries) | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
How do I keep page breaks for each page in a sheet without the co. | Excel Discussion (Misc queries) | |||
Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) |