| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXcel 2003 Page setup slow | Excel Discussion (Misc queries) | |||
| Page Setup changes | Excel Discussion (Misc queries) | |||
| Excel 2003 - PAGE SETUP - FIT TO WIDTH does not work | Excel Discussion (Misc queries) | |||
| In excel how do I copy page setup format from one wsht to another | Excel Discussion (Misc queries) | |||
| How do I copy page setup from one worksheet & paste into new shee. | Excel Discussion (Misc queries) | |||
Linear Mode
