Does it seem like your printed spreadsheet isn’t making the best use of the space on the page? If it seems like you aren’t fitting as much information on a page as you could be, then changing the orientation could be a beneficial change.
In Microsoft Excel the orientation setting is fairly accessible, so it can be confusing in Google Sheets when you need to switch the orientation of your printed spreadsheet. Fortunately this is something that you can do, although the method for doing so is actually found during the printing process. Our tutorial below will show you how to switch between portrait and landscape in Google Sheets.
How to Switch to Landscape Orientation in Google Sheets
The steps in this article assume that you have a Google Sheets file that currently prints in the portrait orientation, and that you would like to print it in the landscape orientation. However, the process of changing the printing orientation is the same, regardless of which orientation you wish to use for your file.
Step 1: Sign into your Google Drive at https://drive.google.com/drive/my-drive and double-click the file that you want to print in landscape.
Step 2: Select the File tab at the top of the window.
Step 3: Choose the Print option at the bottom of the menu.
Step 4: Click the circle to the left of Landscape in the column at the right side of the window, then click the blue Next button.
You can then adjust any of the other settings and click the Print button to complete the process.
Do you find that you often have trouble determining what a spreadsheet is after it’s been printed out? Find out how to put the name of a spreadsheet at the top of the printed page and make your spreadsheets a little easier to identify.