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.

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 ).

Picture 1 of Copy Page Setup settings to another Sheet in Excel

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

Picture 2 of Copy Page Setup settings to another Sheet in Excel

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

Picture 3 of Copy Page Setup settings to another Sheet in Excel

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

Good luck!

Update 19 May 2020
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile