To apply page setup attributes to a group of worksheets in a workbook, follow these steps:
- Press CTRL and then click each worksheet tab in the workbook that you want to affect.
- On the File menu, click Page Setup. …
- Make the changes that you want in the Page Setup dialog box, and then click OK.