Print Multiple Google Sheets Without Gridlines
Gridlines are useful for reading a spreadsheet on screen but can clutter a printed report. Turning off gridlines in Google Sheets' print settings before running the batch conversion ensures all your printed spreadsheets look clean and professional.
Turning off gridlines in Google Sheets
Open a Sheets file and go to File > Print. In the formatting section of the print settings, uncheck 'Show gridlines'. Close the print dialog. Repeat for each Sheets file in the batch. When you run the extension, each file exports without gridlines.
Why this matters for printed reports
Gridlines that help you read data on screen often reduce readability on paper. Without gridlines, the printed sheet looks more like a professional report. Use bold borders around key sections if you need visual separation without the full gridline grid.
Batch printing after setting gridlines
Once gridline settings are configured in each file, go to Drive, select all Sheets files, run the extension, and print. The gridline settings are stored in each file and apply automatically during export.
Frequently Asked Questions
Is the gridline setting saved in the Sheets file permanently?
Yes. The print settings including gridlines are saved per file. They apply to every subsequent export from that file unless you change them.
Can I print some sheets with gridlines and others without in the same batch?
Yes. Each file uses its own print settings. Set gridlines on or off independently in each file before running the batch.
Related article
Batch Convert Multiple Google Docs to PDF →Ready to Try It?
Install the free Chrome extension and start converting your Google Docs to PDF in one click.
Install Free Extension