Download Excel Start File: [ Ссылка ]
Download Excel File: [ Ссылка ]
Apply Page Setup from one Excel Worksheet to another:
1. With the Sheet with the Page Setup that you would like to copy to another sheet (apply to other sheets) selective, Hold Ctrl and Click on the Sheet Tabs with your mouse to selct them.
2. Then with the Active Sheet on the Sheet with the Page Setup you want to copy to the other selected Sheets, Open the Page Setup dialog box and then hit Enter.
3. Keyboard to Set Print Area: Alt P, R, S
4. Keyboard to open Page Setup dialog box: Alt, P, S, P
