Copy Print Settings From One Sheet To Another (Excel 2007-2010)

1) Select the sheet tab containing the print settings you want to duplicate;

2) Hold down the CTRL key and select the sheet tab(s) you want to copy those print settings to; (You are grouping the worksheets by doing this)

3) On the Page Layout tab, click the small arrow (dialog launcher) on the bottom right of the Page Setup group and click OK.

Ungroup the sheets by clicking on one Worksheet tab name.

Excel Training Classes in NYC and Live Online Excel Courses.

Leave a Reply

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