

Then, just choose your printer, adjust the print settings to however you normally would, and when you’re ready, click “Print”.When you go to print one of your worksheets – or even an entire workbook – it’s the Print preview through the File tab’s Print command that tells you how your data will lay out on the pages. You will then see the same printing options that you would normally see whenever you print anything from your web browser, I’m using Google Chrome so I’m seeing Chrome’s normal print options, but if you’re in any other web browser, you’ll see the print options that you get in that browser. Once you’re happy with all your print settings, click on “NEXT” in the top right-hand corner. The “Formatting” and “Headers & footers” options are really no different to any other time you print a Google Sheet so I won’t get into them here, but if you think any of those options might be good, feel free to look through them. The same can be said for the “Margins” option, if you’re only printing a small section, it won’t make much difference, but if you’re trying to fit a lot of information on one page, you might want to set the margins to be smaller. If you’re only printing a fairly small section of your sheet like I am in this example, changing the “Scale” option won’t really make a difference, but if you’re printing a rather large section of your spreadsheet, you might want to adjust the “Scale” option to see what works best for you.

Depending on the shape and size of the section you selected, you might want to adjust some of the other settings before you continue.īy default, “Paper size” is set to “letter”, but as most printers print on A4 paper, you’ll probably want to change it to “A4”.Īnd by default, the “Page orientation” is set to “Landscape” which is often the best orientation for spreadsheets, but if you’ve selected a tall and skinny section, you might be better off setting it to “Portrait”.
