Home Application Office information

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!

You've just finished reading the article "Copy Page Setup settings to another Sheet in Excel" edited by the TipsMake team. You can save copy-page-setup-settings-to-another-sheet-in-excel.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV : Basic common...
How to create word... : NEXT »
Read more