How to Copy Page Setup to Other Worksheets in Excel

This post will guide you how to copy the page setup to other worksheets in your current workbook in Excel 2013/2016. How do I copy the page setup in a specified worksheet to all other worksheets in the current active workbook in Excel.

Assuming that you have a workbook that has multiple worksheets. And you want to set the same page setup based on one specified sheet, such as: same header, footers, margins and so on. If you only have one worksheet, you can set page setting for this worksheet easily. And If you want to set the same page setup for other worksheets in your workbook, if you set the same page setting one by one for those worksheets, it should be not a good idea.

This post will teach you how to copy the page setup to other worksheets quickly, just do the following below mentioned steps:

Step1: select the sheet tab whose page setup settings that you want to copy.

copy page setup to other sheet1

Step2: right click on the current sheet tab, and select “Select All Sheets” menu from the popup menu list.

copy page setup to other sheet2

copy page setup to other sheet3

Step3:  Go to PAGE LAYOUT menu in the Excel ribbon, and click Dialog Box Launcher in the bottom-right corner of Page Setup group. And the Page Setup dialog box will appear.

copy page setup to other sheet4

Step4: click OK button. And the Page settings from the active worksheet are copied to all of the selected worksheets in your workbook.

copy page setup to other sheet5

Note: if you want to ungroup the worksheets, you just select the sheet tab, and right click on it, and then select Ungroup Sheets menu from the popup menu list.

 

You might also like:

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar