Microsoft Office Forums - View Single Post - Copy settings 1 tab to another?

Thread: Copy settings 1 tab to another?

View Single Post

Old

02-20-2014, 08:43 AM

markg2

markg2 is offline

markg2 uses Windows 7

Windows 7

markg2 uses Office 2007

Office 2007

Expert

The original poster

Join Date: Nov 2009

Location: Evergreen, CO

Posts: 344

markg2 is on a distinguished road

Default

Copy settings 1 tab to another?

Office '07

Assume: a workbook with 12 tabs/sheets. I change the print setup for tab 1.

Problem: other than manually opening print setup for 'each' of the remaining 11 tabs, is there a way to copy the new page setup settings from spreadsheet 1 to spreadsheet 2-12?

Mark

Reply With Quote