Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

How do I set up the same print area and margins on multiple sheets?

0

I  am setting up an annual spreadsheet with 12 monthly slaves.  How do I set the same print areas and margins on all 12 at the same time?

Answer
Discuss

Answers

1

Page settings for a worksheet can be copied to other worksheets with the following steps:

1. Activate the worksheet with the page settings you want to copy.

2. Hold down the Shift or Ctrl key to select multiple worksheets you want to copy the page settings to - you can also right-click on one of the sheet tabs and select the Select All Sheets from the menu if you want to copy the page settings to all worksheets.

3. When the worksheets you want to apply the specified page settings to have been selected, then click Page Layout, and click the dialog box launcher in the bottom RH corner.

4. Click OK on the Page Setup dialog box that pops out and you will copy all the basic page settings from the active worksheet to all the others in the current workbook.

5. You can click File > Print to preview the result.

UPDATE

I forgot to say: Be sure to ungroup your sheets when you're done, otherwise, while grouped, Excel will execute any action you take on all the sheets in the group.

Discuss

Discussion

Please don't forget to select the answer that worked best for you! Just click the Select Answer button at the bottom of the desired answer and then click Yes to verify it.
JonP (rep: 37) Jul 20, '16 at 1:21 am
If you have special formatting (font, font size, style, colour, conditional formating rules, etc) it is easy to copy all this to all sheets. On the January sheet, do all the formating changes you want. Then group all sheets (Jan thru Dec) and on the Jan sheet select the cells with the formatting you wish to copy. Then on the Home tab of the ribbon select "Fill" then "Across Sheets" and select "Formats". Now all 12 months will have the same formatting changes as the Jan sheet.
WillieD24 (rep: 547) Aug 4, '18 at 3:47 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login