Set Print Settings for multiple worksheets

[Jonbob]

Is there anyway to select multiple worksheets in a workbook and set the print settings for each one at the same time?

 

[berg891832]

Click the 1st worksheet, then SHIFT Click the last worksheet. All worksheets will then be grouped.

When you set print settings, they will be applied to all of the selected sheets.

Just be sure you don't forget to ungroup the sheets when you are through. Just click any sheet tab to ungroup them.

Berg

 

[Jonbob]

that didn't work- it only does it for one worksheet (the one I am on at the time)

 

[berg891832]

Try this then.

Set the single active sheet to all of your print settings.

When you are done, right click the sheet tab that has the proper print settings, and click Select All Sheets on the shortcut menu.

Then, click File, Page Setup on the Menu bar. When the page setup dialog box displays, just click OK.

The page setup settings should be on all sheets.

Berg

 

[nevillestoke]

When I use the grouping of tabs using the shift-click mode, any page set up settings I set up (footer, auto fit, range, etc.) works on all sheets.

 

[Redcar]

Try this then.

Set the single active sheet to all of your print settings.

When you are done, right click the sheet tab that has the proper print settings, and click Select All Sheets on the shortcut menu.

Then, click File, Page Setup on the Menu bar. When the page setup dialog box displays, just click OK.

The page setup settings should be on all sheets.

Berg

How can I do this in EXCEL 2010?

 

[ahandmadegrin]

Try this then.

Set the single active sheet to all of your print settings.

When you are done, right click the sheet tab that has the proper print settings, and click Select All Sheets on the shortcut menu.

Then, click File, Page Setup on the Menu bar. When the page setup dialog box displays, just click OK.

The page setup settings should be on all sheets.

Berg

How can I do this in EXCEL 2010?

Right click on the sheet tab means the tab at the bottom of the screen for the sheet you have open.

File, Page Setup in 2010 would be Page Layout tab, then click on the little arrow in the bottom right corner of the Page Setup group. Click OK there and your settings will be propagated to all selected sheets.

 

[danlkb1]

Click the 1st worksheet, then SHIFT Click the last worksheet. All worksheets will then be grouped.

When you set print settings, they will be applied to all of the selected sheets.

Just be sure you don't forget to ungroup the sheets when you are through. Just click any sheet tab to ungroup them.

Berg

Word to the wise ... All settings for the default sheet will be applied to all sheets ... for instance.. if 5 are sheet is portrait and 6 sheets are landscape... they will all be saved as the preference for the default sheet (all will then be either landscape or portrait) ... I believe also all margins, headers, etc will be saved from the default sheet... The way around this is to create a macro for one and then modify the macro to change only the settings you want to control (and delete all the ones you don't want to change across the board). You can walk thru all / select tabs in your workbook.

Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
  If ws.Name <> "Data" Then ' Exclude sheet(s) by name
     'Enter code that you want to apply to all sheets here (from recorded macro)
     With ActiveSheet.PageSetup
        .BlackAndWhite = False
     End With
    
      End If
Next ws