Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I copy the page set up from one worksheet to another?
I have data in multiple worksheets in one workbook. I would like the same
page setup on each sheet. Can I copy the page set up from one worksheet to another or do I have to go into each worksheet and do page setup? I am using both Office 2003 and Office 2007. Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I copy the page set up from one worksheet to another?
Hi,
Highlight the worksheet you want to copy the set up from, copy, click the first sheet you want to copy the format to, then hold the Shift key, and clikck in the last sheet, go to cell A1, paste special formats "Deb Raskob" wrote: I have data in multiple worksheets in one workbook. I would like the same page setup on each sheet. Can I copy the page set up from one worksheet to another or do I have to go into each worksheet and do page setup? I am using both Office 2003 and Office 2007. Thank you |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I copy the page set up from one worksheet to another?
Try selecting the sheet tabs before doing the PageSetup..Right click on Sheet
tab'Select All Sheets' OR use Ctrl key to select sheets If this post helps click Yes --------------- Jacob Skaria "Deb Raskob" wrote: I have data in multiple worksheets in one workbook. I would like the same page setup on each sheet. Can I copy the page set up from one worksheet to another or do I have to go into each worksheet and do page setup? I am using both Office 2003 and Office 2007. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy Excel page setup from one worksheet to others? | Excel Discussion (Misc queries) | |||
Move / copy worksheet without any changes to the page setup | Excel Discussion (Misc queries) | |||
copy page setup from worksheet to another within workbook | Excel Worksheet Functions | |||
How do I copy page set up attributes from one worksheet to anothe. | Excel Worksheet Functions | |||
How do I copy page setup from one worksheet & paste into new shee. | Excel Discussion (Misc queries) |