Copy Page Setup across tabs
Hi
This is Jane from Portbury, near Bristol (England). I have Office 2000 on XP machine. I would like to know if I can copy Page Setup formats across tabs, I don't want the formats from the rows or columns, just things like, orientation, margins etc. Can anyone help Thanks xJane |
Copy Page Setup across tabs
Hi
Set one sheet up as you wish. Right click on its tab and select Group Sheets. Go back into the Page Settings again and when you click OK it will replicate these settings onto the other sheets. Don't forget to Ungroup the sheets afterwards (right-click on one and select Ungroup) Andy. (England!) "JWF" wrote in message ... Hi This is Jane from Portbury, near Bristol (England). I have Office 2000 on XP machine. I would like to know if I can copy Page Setup formats across tabs, I don't want the formats from the rows or columns, just things like, orientation, margins etc. Can anyone help Thanks xJane |
All times are GMT +1. The time now is 09:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com