Google Chrome Prints Blank Pages from Google Sheets

You have worked and worked on a spreadsheet or document in Google Sheets or Google Docs (and probably every other GSuite component). You’re finally ready to print and you hit Print, then Next and… BLANK!

This is incredibly aggravating and judging from the articles around the web has dozens of causes. None of the solutions worked for me.

What did?

Solution 1: Set PDF behavior to Open rather than Download

In Chrome, go to Settings > Advanced > Privacy and Security > Content. Under Content, down near the bottom select PDF and then turn on the option to “Download PDF files instead of automatically opening them in Chrome.”

This is still a hassle, because I don’t actually want PDFs to download and open in the system viewer, but at least I can print from Chrome.

Solution 2: Use Firefox

Oh the irony… to use GSuite, I have to switch to Firefox. Go figure, but it works 100% of the time.

Solution 3: Enable the new Print Preview UI?

As of this release of Chrome (Chrome 65.lots.of.numbers), there is an experimental new print preview UI. To enable it, you go to chrome://flags (i.e. you enter that in the address bar) and enter “preview” in the search box to narrow it down to a reasonable number of items.

Now find “Enable new Print Preview UI” and set it to enabled. Relaunch and see what happens.

In my case, what happened the first time (running Chrome 64) is the tab locked up and the printer was defined as Foo Printer, PrinterBrandAA 12345. Only way out of it is to close the tab.

Then I upgraded to Chrome 65 and it looked like it had worked — go to Sheets, randomly create a spreadsheet from one of the templates (Time Sheet), print, click Next, get to the print preview and it’s not blank. It’s all looking good now!

But then it turns out that I still can’t do things like cancel, access the advanced settings or change printers. But I hit print and it says “Printing…” and it looks promising… except that nothing happens and the tab locks up and I have to close it. Still, it kinda sorta feels like it might work in Chrome 66 or Chrome 67. So if you’re reading this anytime after say, May 2018, it’s probably worth a try.

 

Appendix: The problem in pictures

Here’s a visual on the problem. First I hit Print and get to the GSuite print setup and all looks good:

GSuite Sheets print setup - So far so good

But alas! When you click Next and go to the Chrome print preview, it’s blank.

Chrome Print Preview - Blank Page

8 Responses to “Google Chrome Prints Blank Pages from Google Sheets”

  1. Stephanie Hoban

    I and many users in my district are having the same problem.

  2. My fellow Beloit compatriots were fixing schmatics for a new semi-automatic pin setting machine for the alley refurb there, and right when we go to send it to the print jobber, the dang browser took a dump and baleeted the bajeeses out of my files there! What gives, Goog?!

  3. Ludmila Kukalova

    Thank you! This thing drives me crazy. I used Solution 2, print from Safari, as it is the fastest. It works. It is interesting that I never had the problem before. Today is the first day. I think for the future I will have to use one of your other solution.

  4. Jiny Rottman

    We are having the same problem how do we fix this.

  5. Ravi Shekhar Mishra

    I have a proforma invoice with 5 columns but while printing one column show blank always what to do

  6. I’m sorry Ravi, but I don’t really understand the question. Typically if you have a multi-column layout in a spreadsheet, it won’t print columns that extend past the margin (or it will print them on a subsequent page, depending). I have no idea what proforma is.

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>