, , , ,

How To: Copy “Page Setup” (Margins) to All other Worksheets in Office Excel

microsoft office excel

Want create site? Find Free WordPress Themes and plugins.

When we have a workbook with multiple worksheets & we need to print them neatly and prettily, with the same headers, footers, margins, page orientation and so on. If there is one worksheet, we can setup the page settings for the worksheet easily, but if there are multiple worksheets need to be setup with the same page setup, we may set up page settings for one worksheet and then copy and apply the page setup to other worksheets.

So, how to setup or apply “Page Setup” from one Worksheet to another in Excel?

Here is how to do it.

When we set up page settings for a worksheet, we can copy the page settings to other worksheets with the following steps:

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

2. Then, hold down the Shift or Ctrl key to select multiple worksheets you want to copy the page settings to. Or you can 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. See screenshot:

doc-copy-page-setup1

3. And the worksheets you want to apply the specified page settings have been selected, then click Page Layout, and find the dialog box launcher to click it, see screenshot:

doc-copy-page-setup2

4. And a Page Setup dialog box will pop out, click OK directly. By doing so, you will copy all the basic page settings from the active worksheet to all the others in the current workbook.

doc-copy-page-setup3

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

 

GET MORE TIPS FOR MICROSOFT OFFICE EXCEL

 


 

Don’t forget to like us on Facebook and Google+ as well as share this to your social networks to support us.

Please comment below if you have any query.

Did you find apk for android? You can find new Free Android Games and apps.
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published.