Skip to main content

Copy page setup settings from one sheet to another in Excel

Author: Tech Support Last Modified: 2025-04-03

Ensuring consistency in page setup across multiple worksheets within a workbook is key to producing uniformly formatted printouts. Manually adjusting the page setup for each sheet can be time-consuming, especially in large workbooks. This article will guide you through two methods to efficiently duplicate page setup settings across different sheets, streamlining your workflow and maintaining uniformity across your documents.


Copy basic page setup across multiple worksheets

Excel's native functionality facilitates the straightforward duplication of all page setup settings from one worksheet to others. Please do as follows to get it done.

  1. Open the source worksheet that has the page setup settings you wish to copy.
  2. Hold down the "Ctrl" key and click on the tabs at the bottom of the workbook to select all the target sheets where you want to apply the same page setup.
  3. Go to the "Page Layout" tab, and click on the small square with an arrow in the lower right corner of the "Page Setup" group.
    A screenshot showing the Page Layout tab in Excel and the dialog box launcher for page setup
  4. In the opening "Page Setup" dialog box, click the "OK" button.
    A screenshot showing the Page Layout tab in Excel and the dialog box launcher for page setup

Now you can check the applied page setup settings by navigating to "File" > "Print".


Copy specified page setup options to other worksheets

Compared to the above method, "Kutools for Excel" enhances your ability to customize which page setup elements are copied, making it ideal for selectively applying settings:

Kutools for Excel - Packed with over 300 essential tools for Excel. Enjoy permanently free AI features! Download now!

  1. Open the source worksheet that has the page setup settings you wish to copy.
  2. Select "Kutools Plus" > "Printing" > "Copy Page" Setup.
  3. In the opening "Copy Page Setup" dialog box, configure as follows.
    1. Select the target sheets where you want to apply the same page setup.
    2. Check which page setup options you want to copy to the selected worksheets. By default, all options are checked
    3. Click "OK".
      A screenshot showing the Copy Page Setup dialog box of kutools

Kutools for Excel - Supercharge Excel with over 300 essential tools. Enjoy permanently free AI features! Get It Now

Excel's built-in tools provide a fast way to ensure uniform page setup across multiple worksheets, perfect when complete conformity is required. For more control, particularly when only certain page setup attributes need standardizing, Kutools for Excel offers the flexibility to select exactly what you copy. This tailored approach helps manage complex workbooks efficiently, ensuring that each worksheet is set up perfectly for its specific needs.


Related articles:

Print multiple workbooks in Excel

Print ranges in Excel

Print long column on one page in Excel


Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions…
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more
Use Kutools in your preferred language – supports English, Spanish, German, French, Chinese, and 40+ others!

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!