Sunday, January 8, 2012

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.
http://www.theexceladdict.com/images/page_setup_dialog_launcher.jpg
Ungroup the sheets by clicking on one Worksheet tab name.
Excel Training Classes in NYC and Live Online Excel Courses.
Posted by at
Labels:
Location: 1 Union Square W #903, New York, NY 10003, USA

2 comments:

  1. juanjuergensJune 3, 2017 at 5:45 AM

    Thank you for helping people get the information they need. Great stuff as usual. Keep up the great work!!!
    excel vba training

    ReplyDelete
  2. Skillfin LearningDecember 30, 2019 at 1:26 AM

    Skillfin learning’s online excel course provides you 1 year access and instant doubt resolution along with 24x7 live interaction. The course is accessible on mobile and TV. Completion certificate of excel course can help you in cracking an upcoming interview.

    ReplyDelete

Subscribe to: Post Comments (Atom)