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 |
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 |
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 |
All times are GMT +1. The time now is 10:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com