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: 25) Jul 20, '16 at 1:21 am
Add to Discussion

Answer the Question

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