Copying the Page Setup to Other Sheets in Microsoft Excel 2010

In this article, we will learn how to copy the page setup to other sheets in Microsoft Excel 2010.

 

To copy the page setup to other sheets in the workbook & let’s assume we have four sheets, follow the below mentioned steps.

  • Select the sheet tab whose print settings you want to copy.
  • Right click the sheet and select “Select All Sheets”.

 
img1
 

  • Click on Page Layout ribbon
  • Click on Print Titles or click Dialog Box Launcher in the bottom-right corner of Page Setup group

 
img2
 

  • The Page Setup dialog box will be displayed

 
img3
 

  • Click OK.
  • The page settings from the sheet1 are copied to all of the selected sheets.
  • To ungroup the sheets, select the sheet tab, right click and select Ungroup Sheets.

 

Comments

Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.