Copy page setup

If you want to change the page setup (margins, header, footer, and so on) for several or all of the sheets in your workbook, you have to select all the sheets by holding the SHIFT or CONTROL keys while clicking the sheet tabs. The XL Toolbox provides an alternative way to adjust the page properties: The Copy Page Setup function, which will propagate the current sheet’s settings to all other sheets in the workbook.

This is a companion discussion topic for the original entry at