This post demonstrates how we could set excel sheet to landscape or portrait layout in excel to achieve our desired layout.
Go to Page Layout Ribbon and select Orientation, you could select your desired orientation for the excel sheet to fit the print area. You will see a very fine dashed line changing as you change the orientation which defines your preview area while printing.
Hope this helped.
