You can set up the worksheet page to print just the way you want. With the Page Setup dialog box, you can choose the page orientation , which determines whether Excel prints the worksheet data portrait (vertically) or landscape (horizontally). You can also adjust the print scaling (to reduce or enlarge the size of printed characters ), change the paper size (to match the size of paper in your printer), and resize or realign the left, right, top, and bottom margins (the blank areas along each edge of the paper). Changes made in the Page Setup dialog box are not reflected in the worksheet window. You can see them only when you preview or print the worksheet.
Change Page Orientation
Change the Margin Settings