A worksheet is finally painstakingly shaped to ensure that margins, orientations, headers, and footers are all as desired. Now we’re working with another document, and we’d like to assign the same settings once. This can be done with a trick.
Open the workbooks and click on the Page Layout tab in the menu bar at the front. In the Page Setup area, click on the small arrow in the bottom right corner to open the Page Setup window – you can close it immediately afterward.
Because by opening this window, Excel has saved all the formatting settings. Now switch to the new workbook and press [F4]. This will have the effect of repeating the last command or pattern in Excel.
In this case, the formatting of the first workbook will be applied to the second.