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

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!

3.8 ★ | 8 Vote

You should read it

May be interested

  • How to delete white pages in ExcelHow to delete white pages in Excel
    when editing a data sheet in excel, when a blank page is redundant, it will affect the printing of the document.
  • Repeat the worksheet title when turning the page in ExcelRepeat the worksheet title when turning the page in Excel
    show you how to repeat the title of the spreadsheet when you turn the page in excel. to repeat the worksheet title when moving to the page, follow these steps: step 1: go to page layout - page setup tab - click on the bottom arrow icon: step 2: page setup dialog box
  • How to fix the error of printing without finishing the page in ExcelHow to fix the error of printing without finishing the page in Excel
    need to print a table of data in excel? but the data sheet is divided into 2 pages causing inconvenience to you? click to see now to find out how to fix it quickly and effectively!
  • How to display Sheet Tab in Excel when hidden, not displayedHow to display Sheet Tab in Excel when hidden, not displayed
    excel's sheet tab is used to manage work sheets easily. however, during the data processing process, the sheet tab suddenly becomes hidden, making you wonder how to handle this situation? so let's learn how to display sheet tab in excel when hidden to help you solve problems and work more efficiently.
  • How to hide and show Sheet in ExcelHow to hide and show Sheet in Excel
    sometimes working with too many sheets makes you confused, or you don't want important sheets being viewed by others on your computer ..., or for some reason you want to hide the sheet and when necessary then display the sheet.
  • Recover deleted Sheet in ExcelRecover deleted Sheet in Excel
    when you delete sheet in excel, it seems that the undo keyboard shortcut has no effect. so how to recover deleted sheet in excel?
  • Show Sheet Tab in Excel when hiddenShow Sheet Tab in Excel when hidden
    accidentally when you open the excel file to work, you do not see the sheet tab bar appear to select sheet. you do not know what to do, so let's learn about the display of sheet tab in excel when hidden in this article.
  • How to fix the error of printing missing documents in an Excel sheetHow to fix the error of printing missing documents in an Excel sheet
    the situation of printing missing excel page content is not uncommon, especially with excel documents with many columns and many rows, sometimes missing pages will be printed. this is not a document printing error that is too difficult to fix, requiring the intervention of a repairman.
  • Shortcut switch Sheet in ExcelShortcut switch Sheet in Excel
    shortcut switch sheet in excel. are you looking for a shortcut combination to quickly switch sheet in excel to make the process of working between sheets faster? below the article shared to you the sheet shortcut shortcut in excel, invite you to tickle
  • How to number pages in all versions Excel (update 2020)How to number pages in all versions Excel (update 2020)
    instructions for numbering pages in excel versions of excel 2003, excel 2007, excel 2010, excel 365, and page numbering in excel when printing easily

Office information