Files & formats

Google Sheets printing cuts off the rightmost columns

The short answer

In Google Sheets on a computer, open File → Print and look for the last column you want on paper. If it’s missing from every page, check the print range. If it starts on a separate page, try Landscape and check the page breaks.

Related sourcesGoogle

01Make sure the last column is in the print range

Section link

Choose Current sheet to print the active tab. If you only want a table, go back to the sheet, select the range from its first cell through the last column and row, then choose File → Print → Selected cells. Workbook includes the other tabs as well.

02Give a wide table more room

Section link

In the Sheets preview, choose Landscape under Orientation. Set Paper size to the paper you plan to use. Try narrower Margins if the rightmost column still spills onto another page. Check that the labels and numbers are large enough to read in the preview.

03Split a table where it makes sense

Section link

If the table needs more than one page across, choose Set custom page breaks and move a vertical break between groups of related columns. Each outlined rectangle prints on its own page. Choose Confirm breaks and review all the pages before continuing. If you’ve frozen a label column, you can repeat it under Headers & footers → Repeat frozen columns.

04If the Sheets preview looks right but the paper doesn’t

Section link

Choose Next and compare the orientation and paper size in the final print window with the settings you chose in Sheets. In Chrome this is the browser print window. With Firefox or Safari, open the downloaded PDF and check its last column before printing it. If the PDF is complete, focus on the printer’s paper size and layout settings.

Sources & further reading

Put it into practice