Are you not seeing any gridlines when trying to print Excel? Follow the solutions in this article if you find that Excel is not printing gridlines properly or printing only some gridlines. Gridlines are lines that run horizontally and vertically across the Excel spreadsheet.
Fix Excel not printing gridlines properly
If Excel is not printing gridlines properly or printing only some gridlines, follow these suggestions to resolve the issue:
- Enable the print gridline option in Excel.
- Go to the Page Layout tab.
- Go to the Page Setup settings.
- Modify the color of printed gridlines.
How to print Excel Worksheet with gridlines
1] Enable the print gridline option in Excel.
Maybe the issue is occurring because the Gridline feature is not enabled:
Click the File tab.
On the backstage view, click Options.
An Excel Options dialog box will open.
On the left, click Advanced.
Scroll down to the Display options for this worksheet section and check the Show Gridlines check box.
Then click OK.
2] Go to the Page Layout tab.
If the gridline is not showing, there is a chance that the gridline view on the Page Layout tab is not checked.
Go to the Page Layout tab.
In the Sheet Options group, under Gridlines, check the check box for View.
Also, check the check box for Print. The Print check box prints lines between the rows and columns to make the lines easier to read.
3] Go to the Page Setup settings
Click the File tab.
On the backstage view, click Print on the left.
Under Settings, click Page Setup.
A Page Setup dialog box will open.
On the Sheet tab, under the Print section, check the Gridlines option check box.
Then click OK.
4] Modify the color of printed gridlines.
Click the File tab.
On the backstage view, click Options.
An Excel Options dialog box will open.
On the left, click Advanced.
Scroll down to the Display options for this workbook section and select the workbook gridlines you want to change.
Ensure the Gridlines check box is checked.
Click the drop-down arrow for Gridline Color, choose a color, then click OK.
Why do gridlines not print when a document is printed?
If gridlines do not show up when you are trying to print your spreadsheet, or you do not see them in the print view, you should check if the Draft Quality check box is selected; if it is, please uncheck the check box. Follow the steps below to uncheck the Draft Quality check box.
- Click the File tab.
- On the backstage view, click Print on the left.
- Under Settings, click Page Setup.
- A Page Setup dialog box will open.
- On the Sheet tab, under the Print section, check the Gridlines option check box.
- Then click OK.
If your gridlines do not print successfully, that means that maybe there is an issue with your computer drivers.
READ: Excel not highlighting Cells in formula
Do the worksheet gridlines appear by default when printed?
No gridlines appear in the spreadsheet when printed by default; you will have to enable the gridlines for them to show. In this article, we have explained some steps to enable the gridlines in Microsoft Excel.
