Copy Page Setup settings to another Sheet in Excel

The setup of Page Setup is very simple, but if you work with lots of Sheet in Excel you spend a lot of time setting up this. The following article shows you how to Copy Page Setup settings to another Sheet in Excel .

For example , Sheet 1 has the standard format you want to copy this Sheet to Sheet 2 you do as follows:

Step 1: Select the Sheet format to copy ( Sheet 1 ).

Copy Page Setup settings to another Sheet in Excel Picture 1

Step 2: Hold down Ctrl and click the name of the Sheet to be copied (here is Sheet 2 ).

Copy Page Setup settings to another Sheet in Excel Picture 2

Step 3: Select Tab Page Layout -> Page Setup . The Page Setup dialog box appears, click OK .

Copy Page Setup settings to another Sheet in Excel Picture 3

Copying Page Setup hopes to save you time in working with Sheets in Excel.

Good luck!