Cloud storage-based document editors like Google Docs and Sheets have reduced the need for document printing. Still, there are times when you need physical copies. Multiple users are often unable to print Google Sheets, resulting in last-minute scrambling for solutions. The error is common when using regular or local printers and when using Google Cloud Print.
You can still send or share the document with others through Google Drive and email. We’ll help you fix the Google Sheets not printing error quickly. The solutions are easy to follow and are not very technical.
1. Check cables or Wi-Fi
Check the cables to make sure the computer and printer are properly connected. Check the Wi-Fi network in case of Cloud Print configuration. Make sure the computer and printer are on the same network and that you have a strong signal.
I would recommend a quick restart to shut down all background processes and refresh everything. Be sure to back up any open jobs or files before restarting. Here is the sequence I recommend:
- Start the printer.
- Connect the printer to the Wi-Fi network.
- Start the computer and connect to the same Wi-Fi network.
- Open the Google Sheets file and give the print command.
2. Printer Cloud Ready
Not all printers are created equal. Make sure yours is cloud ready. Here’s how to find out. Google maintains an extensive list of printers that support cloud printing. Look up your name to see if it appears. To avoid mistakes, start with the brand name, then the model name and number. Check the box or the manual to be more specific.
Here’s what Google has to say:
- If your printer isn’t listed but supports Wi-Fi, it’s not cloud ready, but you can configure it to work with Google Cloud Print.
- If the printer name has v2 written next to it, it supports version 2.0.
- If the printer is listed, but v2 is not written, it supports version 1.0.
Follow the link shared above for how to set up a Wi-Fi printer from scratch.
3. Different browser
You are probably using Google Chrome to access and use Google Sheets while giving the print command. Try another browser like Edge or Firefox and see if it works. This is also a good time to check if you are using the latest browser version.
4. Private browsing mode
The reason I suggest Incognito Mode is because some extensions / add-ons can interfere with the printing process. A simple switch to incognito mode will help to understand if the intuition is true. Most likely, this is an extension related to PDF.
5. Choose the right printer
You can work on multiple printers, which can be confusing. Check if you are sending the Google Sheets document to print to the correct printer. All available printers should be listed in a column under Print Destinations in the Select Destination pop-up window. The default printer is the one you used last but to be sure choose manually.
6. Add a printer
Go to the Google Print page and delete the printer that is not working for you in Google Sheets. Now select one of the options based on using cloud or local printer.
Troubleshoot is a built-in Windows 10 program that will help you troubleshoot many issues with hardware and software services.
Step 1: Press Windows key + I to open settings and search for “Find and fix printing problems.”
2nd step: Select Apply repairs automatically from the pop-up window that follows and click Next.
Now you will follow the onscreen instructions and see if troubleshooting can fix the Google Sheets not working printing error.
You can also try the hardware and device troubleshooting option, but it was recently removed from the settings. You can still access it from the command prompt.
Step 1: Find and open the Command Prompt from the Start menu by selecting Run as administrator.
2nd step: Give the command below and you will be greeted with a pop-up similar to the one you saw above. Again, follow the same steps.
msdt.exe -id DeviceDiagnostic
8. Manage pilots
To bring the perfect harmony, you need to roll back the drivers to a previous version, update to the latest version, or uninstall and reinstall the drivers from scratch. The drivers should be reinstalled automatically. However, you can download them directly from Google. You search for printers in Device Manager when working with drivers.
9. Update the firmware
Note the make and model of the printer and visit the manufacturer’s website to download and install the latest version. A restart is generally not necessary but recommended.
10. Convert to PDF
Here is a weird hack if nothing else seems to work for you. Open Sheets and in the File menu you will find an option to convert the document to PDF.
Now open the PDF file and give the print command from there. So the goal is to print the same document as a PDF instead of a spreadsheet.
Print the world
It’s amazing how the world has shifted to 3D printing, and we’re still struggling with local and cloud printers. But that’s how our relationship with technology works. Let us know your thoughts in the comments below. This could include comments or a new way to correct this old error.
Do you own a Chromebook? Click the link below to find out how to print with Chromebook, as things work a little differently there.
Last updated on Oct 20, 2020
The above article may contain affiliate links that help support Guiding Tech. However, this does not affect our editorial integrity. The content remains impartial and authentic.