Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I copy Page Setups from one Sheet to Another sheet?
I've set up margins within a worksheet and wish to copy that worksheet with
the same format. Doesn't seem to copy the margin settings. Am I missing somethin? |
#2
|
|||
|
|||
If you copy the whole worksheet (not just the cells), then the page setup will
travel with that worksheet. Select your sheet to copy Edit|move or copy sheet If you want multiple worksheets to have the same page layout, you can select the first and ctrl-click on the subsequent tabs. Then File|page setup You'll be getting all the worksheets that are grouped. Remember to ungroup your sheets (just rightclick on one of the grouped worksheets tabs and select "Ungroup Sheets". Any change you make to one of the group, you make to all of the group. Jeff wrote: I've set up margins within a worksheet and wish to copy that worksheet with the same format. Doesn't seem to copy the margin settings. Am I missing somethin? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Page Setup from Sheet to Sheet? | 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) | |||
How do I copy page set up attributes from one worksheet to anothe. | Excel Worksheet Functions |