Printing Problems

Fix Excel Gridlines That Print on Alternate Rows

Tauseeq MagsiTauseeq Magsi Nov 12, 2026 868 views

Question details

The user needs Excel worksheet gridlines to print consistently on every row instead of disappearing on alternating rows.

Fix Excel Gridlines That Print on Alternate Rows
Product
Microsoft Excel
Device & OS
not provided
Scenario
Gridlines appear correctly in Print Preview, but the physical printed page omits some horizontal gridlines.
Observed behavior
Alternate gridlines are missing after printing, even though every gridline is visible in Print Preview.
Before you start

Open the worksheet in Print Preview first to confirm that gridlines are enabled there. Have access to another printer or a PDF printer so you can determine whether the issue is caused by the current printer driver.

Solution 1Recommended

Confirm Excel is set to print worksheet gridlines

Use this first when gridlines may not be enabled in the worksheet's print settings.

1
Open Page Setup

In Excel, open the worksheet, select the Page Layout tab, and click the small Page Setup dialog launcher in the bottom-right corner of the Page Setup group.

2
Enable printed gridlines

Select the Sheet tab, then under Print, select the Gridlines check box.

3
Turn off draft printing

In the same Sheet tab, clear the Draft quality check box if it is selected, then click OK.

4
Check the preview and print

Choose File > Print and review the preview before sending the worksheet to the printer.

Confirm Excel is set to print worksheet gridlines
Gridlines versus borders: Gridlines are printer-dependent display and print guides. For documents that require guaranteed lines, apply cell borders to the required range.
Print spreadsheet gridlines reliably

Print Consistent Worksheet Gridlines with WPS Spreadsheet

WPS Spreadsheet lets you enable print gridlines, review the result in print preview, and apply cell borders when a worksheet needs lines that remain consistent across printers.

  1. 1. Open the worksheet: Launch WPS Spreadsheet and open the Excel workbook that has missing printed gridlines.
  2. 2. Enable print gridlines: Open the Page Layout tab and enable the Print Gridlines option for the active worksheet.
  3. 3. Review the print preview: Select Menu > Print to check whether gridlines appear across all rows in the preview.
  4. 4. Add borders when needed: Select the required cell range, choose Home > Borders, and apply All Borders for printer-independent lines.
Enable spreadsheet gridlines for printed worksheetsUse cell borders for dependable row and column linesOpen and save Microsoft Excel .xlsx and .xls filesUse a familiar spreadsheet interface with lightweight tools
microsoft office alternative - wps office

Frequently Asked Questions

Why do gridlines look correct in Excel Print Preview but disappear on paper?

When Print Preview shows every line, Excel's gridline setting is usually correct. The issue is commonly caused by the selected printer, its driver, or a draft-quality printing option.

Where is the Excel setting to print gridlines?

Open Page Layout, click the Page Setup dialog launcher, select the Sheet tab, and select Gridlines under the Print section.

Does Draft quality affect Excel gridlines?

Yes. Draft quality can reduce or omit fine lines on some printers. In Page Setup > Sheet, clear Draft quality and print again.

How can I tell whether my printer driver is causing missing gridlines?

Choose File > Print and print the worksheet to a PDF printer or another physical printer. If all lines appear there, update or reinstall the original printer's driver.

Should I use gridlines or borders for a form that must print clearly?

Use cell borders. Select the needed cells, then go to Home > Borders > All Borders. Borders are part of the worksheet formatting and usually print more consistently than gridlines.