Tom’s Tutorials For Excel: Copying Your Page Setup to Multiple Worksheets
Establishing your Page Setup preferences can involve a lot of steps. You won’t want to repeat those same steps over and over for each worksheet where you’ll want the same preferences.
To show the Page Setup dialog box…
…If you are using Excel version 2003 of before, from the menu bar click
File > Page Setup.
…If you are using Excel version 2007 or after, from the Ribbon, click onto the Page Layout tab. Click the small expansion button in the lower right corner of the Page Setup panel.
Here’s the Page Setup dialog box, where you set your preferences and click the OK button.
In this example, I established Page Setup preferences for Sheet1. When you want to copy the same Page Setup preferences to other worksheets, the first step is to select that original worksheet.
The next step is to press the
Ctrl key on your keyboard, and use your mouse to select the worksheets as a group to which you want to apply the same Page Setup preferences. In this example, I am copying Sheet1’s Page Setup preferences to Sheet3, Sheet5, Sheet6, and Sheet8.
Next, show the Page Setup dialog box again. Here are two keyboard shortcut tips to do that:
With the desired worksheets selected as a group as shown above, simply click the OK button on the Page Setup dialog box.
Your final step is important to remember: ungroup the worksheets!
Tom, very cool. maybe you might have an idea for a way to dump a spreadsheets intrinsic qualities (like: all cell types, attributes, column/row sizings, cell data values) out to a CSV and a reverser to reconstitute the .csv into a duplicate spreadsheet.
Wow, what a suggestion, thanks Jim. I hadn’t thought about parsing all those properties for CSVs. Interesting; I’ll give it some thought and maybe this summer post a new tutorial about that. Could be quite a project but I’ll mull it over.