How to Print Gridlines in Excel - Practical Guide

Learn how to print gridlines in Excel to display cell borders on printed documents. Gridlines help organize data visually and make spreadsheets easier to read when printed. This tutorial covers both worksheet gridlines and print-specific settings, ensuring your printed output matches your screen layout.

Why This Matters

Printing gridlines enhances document readability and professional presentation for reports, budgets, and data analyses. It eliminates ambiguity about cell alignment when sharing printed Excel documents.

Prerequisites

•Basic Excel knowledge and familiarity with the ribbon interface
•A spreadsheet with data ready to print

Step-by-Step Instructions

Open your Excel spreadsheet

Launch Excel and open the workbook containing the data you want to print with gridlines.

Access Page Layout tab

Click the Page Layout tab in the Excel ribbon at the top of the screen.

Locate Sheet Options group

In the Page Layout tab, find the Sheet Options group on the left side of the ribbon.

Enable Print Gridlines

Check the Print box under Gridlines in the Sheet Options group to enable printing gridlines on your document.

Preview and print

Go to File > Print Preview to verify gridlines appear, then proceed with printing your spreadsheet.

Alternative Methods

Add borders using Home tab

Select all cells (Ctrl+A), go to Home > Borders > All Borders to add visible cell borders instead of using gridlines.

Use Print Preview settings

Access File > Print, then enable gridlines directly in the print preview dialog under Sheet Options.

Tips & Tricks

✓Gridlines appear on screen by default; checking the Print box ensures they print on paper.
✓Use View > Gridlines on the sheet tab if you want to hide gridlines on screen but keep them in print.
✓Combine gridlines with borders for enhanced visual distinction between data sections.

Pro Tips

★Print gridlines only for specific ranges by first selecting the range, then applying page break preview to control print areas.
★Use light gray gridlines (via Home > Borders > Line Color) for a professional appearance without overwhelming the printed document.
★Set gridline printing as default for all new sheets by saving as a template after configuring Page Layout settings.

Troubleshooting

Gridlines not appearing on printed output

Verify that the Print checkbox under Gridlines is enabled in Page Layout > Sheet Options. Also check your printer settings to ensure they're not suppressing gridlines.

Gridlines appear too faint or bold in print

Adjust line weight and color via Home > Borders > Line Style and Line Color options to match your desired appearance.

Gridlines only print on some pages

Check if page breaks or multiple print areas are configured; ensure the Print Gridlines setting applies to all selected print ranges in Page Setup.

Frequently Asked Questions

Can I print gridlines for only part of my spreadsheet?

Yes, select the specific range you want to print, then go to File > Print Area > Set Print Area before enabling gridlines. This ensures gridlines print only for the selected range.

What's the difference between View Gridlines and Print Gridlines?

View Gridlines (View tab) controls what you see on screen, while Print Gridlines (Page Layout tab) controls what prints on paper. You can enable one, both, or neither independently.

Will my borders disappear if I enable Print Gridlines?

No, borders and gridlines can coexist. Gridlines print behind borders, so your custom borders remain visible and may overlap with gridlines.

Why are my printed gridlines not visible?

Check if Print Gridlines is enabled and verify your printer isn't set to suppress graphics or light colors. Test printing to see if the gridlines appear.