How to Copy a Page Format to All Pages of a Workbook in Excel 2007

By Greg Lindberg

The Microsoft Office Excel 2007 application allows you to create a workbook that includes multiple worksheets. Each worksheet that you add to the workbook is represented by tabs, which are displayed at the bottom of the page. You can apply page format settings to all of the worksheets at once so that the page layout is the same for all of the spreadsheets within your workbook. Page format settings for worksheets include page margins, header and footers and printing options.

Step 1

Open the Microsoft Excel 2007 workbook that contains all of the worksheets for which you want to set the same formatting.

Step 2

Press the "CTRL" key on your keyboard and then select each worksheet tab at the bottom of the application.

Step 3

Click the "Page Layout" tab and then select the arrow in the "Page Setup" group to launch the Page Setup dialog box.

Step 4

Select the "Page" tab to make any changes to the page settings, including colors and layout. Select the "Margins" tab to change the page margins for each worksheet.

Step 5

Click the "Header/Footer" tab to change any header or footer settings. Select the "Sheet" tab to determine print settings for your worksheets, including enabling gridlines, cell range to be printed, and whether to print in color or black and white.

Step 6

Click the "OK" button and then the changes you made to the page format will be saved to all worksheets in the workbook.