To view your print preview in Google Sheets, you just need to select the option to print. Then when you print, you should see in your print preview that as scroll through, the headers are on every page. This is done in the top menu by selecting View and then selecting Freeze, and 1 RowĢ. The first step to print header rows on every page is to lock the first row in place with freeze panes.
#Print selection in google sheets how to
Try each one and see how it would effect the print preview to see if this is a better option for your data How to Print Header Rows on Each Page in Google Sheets Just above the scale and margin settings you can also select if you want to print portrait or landscape. There will be more white space and you will end up with less data on each printed page Wide: This option creates a wider margin on your page.Narrow: If you want to get rid of the white spaces on the side of your printed sheet, this will make the margins narrow.Normal: This is the default margin setting.Here are the different options for your Margin settings: Select the one you want from the drop-down menu (or you can set custom margins). If you have a small spreadsheet and it would be readable on a single page, select this optionīelow the scale setting, you will find the option for changing the Margin. Fit to Page: This will print everything on one page.If you have few columns in your data, this is a good option Fit to Height: This will fit all your columns on the same page.If you have few rows on your data and want to get them all on the same page, this is great option Fit to Width: This will print all your rows on the same page.
2 How to Set Print Area to Print Entire Sheet.1 How to Set the Print Area for a Selected Range in Google Sheets.