Gridlines make spreadsheets easier to read by clearly separating rows and columns. While Google Sheets displays gridlines by default on your screen, they are not always included when printing. If you’re preparing reports, invoices, schedules, or data tables, printing gridlines can make your documents look more organized and professional.
This guide explains how to print gridlines in Google Sheets step by step.
What Are Gridlines in Google Sheets?
Gridlines are the light gray lines that separate cells in a spreadsheet. They help users identify data locations and improve readability.
When printing a spreadsheet, gridlines can:
- Make tables easier to read
- Improve document organization
- Help with data entry on printed sheets
- Create a cleaner, more professional appearance
Why Print Gridlines?
Printing gridlines is useful when:
- Sharing spreadsheets in paper form
- Printing reports and financial documents
- Creating attendance sheets
- Producing inventory lists
- Preparing schedules and planners
Without gridlines, printed data may appear cluttered and difficult to follow.
Step 1: Open Your Google Sheet
Begin by opening the spreadsheet you want to print.
To do this:
- Visit Google Sheets.
- Open the desired spreadsheet.
- Review your data to ensure everything is formatted correctly.
Before printing, it is a good idea to adjust column widths and row heights if needed.
Step 2: Access the Print Settings
Once your spreadsheet is ready:
- Click File in the top menu.
- Select Print.
You can also use the keyboard shortcut:
- Ctrl + P (Windows)
- Command + P (Mac)
This opens the Print Settings screen.
Step 3: Locate the Formatting Options
On the print preview page:
- Look at the right-hand settings panel.
- Scroll down to find Formatting.
- Click to expand the section if necessary.
The Formatting section contains options that control how your spreadsheet appears when printed.
Step 4: Enable Gridlines
Under the Formatting section:
- Find the option labeled Show Gridlines.
- Check the box next to it.
Once selected, the print preview should immediately update to display gridlines around your cells.
This allows you to confirm how the final printed document will appear.
Step 5: Review the Print Preview
Before printing:
- Ensure all data fits properly on the page
- Verify gridlines appear correctly
- Check page breaks
- Confirm margins and orientation settings
If the spreadsheet spans multiple pages, review each page in the preview.
Step 6: Adjust Page Layout if Needed
To improve your printed document:
Change Orientation
Choose:
- Portrait for narrow spreadsheets
- Landscape for wider spreadsheets
Adjust Scale
Options include:
- Normal
- Fit to width
- Fit to page
Modify Margins
Select:
- Normal
- Narrow
- Wide
- Custom
These settings help ensure gridlines and data display neatly.
Step 7: Print Your Spreadsheet
Once satisfied:
- Click Next in the top-right corner.
- Choose your printer.
- Select any additional printer settings.
- Click Print.
Your spreadsheet will now print with visible gridlines.
How to Print Selected Cells Only
If you only need part of your spreadsheet:
- Highlight the cells you want to print.
- Click File → Print.
- Under Print options, choose Selected Cells.
- Enable Show Gridlines.
- Print normally.
This helps reduce paper usage and focuses only on relevant data.
Alternative Method: Add Borders Instead of Gridlines
If you want darker lines than standard gridlines:
Steps:
- Select the cells you want to print.
- Click the Borders icon in the toolbar.
- Choose All Borders.
Borders often appear more prominently on printed documents than default gridlines.
Common Problems and Solutions
Gridlines Do Not Appear in Print Preview
Solution:
- Verify that Show Gridlines is checked in Formatting settings.
- Refresh the browser and try again.
Spreadsheet Prints Across Too Many Pages
Solution:
- Use Landscape orientation.
- Adjust scaling options.
- Reduce column widths.
Printed Gridlines Are Too Faint
Solution:
- Use cell borders instead of gridlines.
- Increase printer quality settings.
Tips for Better Spreadsheet Printing
Use Clear Headers
Add bold column titles to improve readability.
Adjust Column Widths
Prevent text from being cut off.
Freeze Important Rows
Keep headers visible when reviewing large spreadsheets before printing.
Preview Before Printing
Always check the print preview to catch formatting issues.
Frequently Asked Questions
Are gridlines printed by default in Google Sheets?
No. Gridlines must usually be enabled through the Print Settings panel.
Can I print only certain sections with gridlines?
Yes. Select specific cells and choose Selected Cells during printing.
Why are my gridlines not showing?
Check that Show Gridlines is enabled under Formatting in the print settings.
What’s the difference between borders and gridlines?
Gridlines are default cell guides, while borders are manually applied and typically print more clearly.
Benefits of Printing Gridlines
- Improves readability
- Creates organized reports
- Makes data easier to follow
- Enhances professional appearance
- Helps with manual data entry
Conclusion
Printing gridlines in Google Sheets is a simple way to make spreadsheets easier to read and more professional-looking. By enabling the Show Gridlines option in the print settings, you can ensure rows and columns remain clearly separated on paper.
Whether you’re printing reports, schedules, invoices, or data tables, including gridlines can greatly improve the usability and appearance of your printed documents. Always review the print preview before printing to ensure everything looks exactly as intended.