Hmm... that is strange, as I can set different page size, orientation, and single or multiple page within Excel Page Layout tool bar for each sheet, it all works as you need it to work... I can't replicate the issue you are having. See below screenshots: Sheet 1 = set up as 100% magnification, Paper Size: Letter, Orientation: Portrait Sheet 2 = set up to fit 1 page by 1 page, Paper Size: A3, Orientation: Landscape Sheet 3 = set up to fit 1 page by 1 page, Paper Size: Tabloid, Orientation: Portrait The Print Preview clearly shows this will work as intended. Just to clarify I'm testing in: Microsoft Excel Version 1712 (Build 8827.2148) Adobe Acrobat DC Pro (Continuous Release | Version 2018.009.20050) Windows 10 Pro Preview Screenshots for Sheet 1 (page 1 and 2), Sheet 2 (page 3), and Sheet 3 (page 4):
... View more