Each Excel sheet has its own setup options (orientation, margins, headers and footers, and so on), which you set using the File-Page Setup command. But when you add a new sheet to a workbook, it contains the default page setup. PC World reader Bibi Ali has come up with an easy way to transfer the settings: activate the sheet that contains the desired setup info. Hold down <Ctrl> and click the sheet tabs of the additional sheets you want to update. Then select File-Page Setup and click OK.

- John Walkenbach