-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Is it possible to change page layout to all pages of a workbook at once vs. changing one page at a time? I inherited a workbook, and would like to have all pages with the same margins, orientation, etc.
Oaktree
MrExcel MVP
- Joined
- Jun 20, 2002
- Messages
- 8,120
- Office Version
- 365
Welcome to the board.
Sure, just select all of your (appropriate) sheet tabs before you apply the changes. You can either click the first sheet tab, hold shift, and click the last sheet tab to select all of them... or, you can hold CTRL while you click on the sheet tabs one at a time (if they are not adjacent).
Just make sure you ungroup them (right click on the sheet tabs and go to "ungroup sheets") before you start working in the file or you'll be changing every selected sheet (instead of just the active one).
Sure, just select all of your (appropriate) sheet tabs before you apply the changes. You can either click the first sheet tab, hold shift, and click the last sheet tab to select all of them... or, you can hold CTRL while you click on the sheet tabs one at a time (if they are not adjacent).
Just make sure you ungroup them (right click on the sheet tabs and go to "ungroup sheets") before you start working in the file or you'll be changing every selected sheet (instead of just the active one).
Upvote
0
