Excel Tips and Tricks – Set Margins Across All Sheets

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