Fix Excel Gridlines That Print on Alternate Rows
Question details
The user needs Excel worksheet gridlines to print consistently on every row instead of disappearing on alternating 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.
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.
Confirm Excel is set to print worksheet gridlines
Use this first when gridlines may not be enabled in the worksheet's print settings.
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.
Select the Sheet tab, then under Print, select the Gridlines check box.
In the same Sheet tab, clear the Draft quality check box if it is selected, then click OK.
Choose File > Print and review the preview before sending the worksheet to the printer.

Test the workbook with PDF output or another printer
Use this when Excel Print Preview is correct but alternating gridlines are missing only on the printed paper.
Update the printer driver and use explicit cell borders
Use this when the issue follows one physical printer or when the worksheet needs reliable printed lines.
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. Open the worksheet: Launch WPS Spreadsheet and open the Excel workbook that has missing printed gridlines.
- 2. Enable print gridlines: Open the Page Layout tab and enable the Print Gridlines option for the active worksheet.
- 3. Review the print preview: Select Menu > Print to check whether gridlines appear across all rows in the preview.
- 4. Add borders when needed: Select the required cell range, choose Home > Borders, and apply All Borders for printer-independent lines.

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.




