To make worksheet gridlines print in Excel for Microsoft 365 on Windows, select the worksheet, open Page Layout, and under Gridlines tick Print. Check the result in File > Print before sending it to the printer. This setting is separate from the option that shows gridlines on your screen, and cells with a fill color may still print without gridlines.
The steps below cover a whole worksheet, selected print areas, and common reasons lines seem to disappear. You do not need to change the workbook’s formatting or add borders just to enable gridline printing.
What You’ll Need
- An Excel workbook with the worksheet you want to print.
- A printer, or access to File > Print to preview the output or save it as a PDF.
- Excel for Microsoft 365 on Windows for the menu paths below. Excel for Mac has a similar setting; Excel for the web may have fewer page setup options.
Step-by-Step
- Open the worksheet you want to print. Gridline printing is a worksheet setting, so click the relevant sheet tab at the bottom of the workbook. If the workbook has several sheets, set up each one you intend to print. You can select multiple worksheet tabs to group sheets, but take care: changes made while sheets are grouped can affect every selected sheet. Click a single tab again when you are done.
- Open the Page Layout tab. On the Excel ribbon, choose Page Layout. Find the Sheet Options group, which contains controls for Gridlines and Headings. In the Gridlines row, Excel provides separate checkboxes for View and Print. The View option controls the worksheet display; it does not turn printing on or off.
- Turn on the Print checkbox. Under the Gridlines heading, tick Print. If you also want to see the lines while editing the sheet, tick View as well. You can enable printing while leaving View off, so the sheet looks uncluttered on screen but includes gridlines on paper. Make sure you are using the Gridlines row, not the separate Headings controls.
- Check the print area and page range. Go to Page Layout > Print Area if you need to set or clear a print area. A saved print area limits what Excel sends to the printer; it can leave out cells you expected to see. Also check the page range in the print screen. If you want the whole used worksheet, choose the option to print the active sheets or the entire workbook as appropriate, rather than printing only a selection.
- Open Print Preview. Choose File > Print, or press Ctrl+P on Windows. Review the preview page by page. The lines should appear around the cells in the printable area. If there are several pages, use the preview navigation arrows to inspect each one, because scaling and page breaks can make a later page look different from the first.
- Adjust the page layout if the preview is hard to read. In the print screen, check the paper size, orientation, margins, and scaling choices. For a wide table, Page Layout > Orientation > Landscape may give columns more room. Scaling a large sheet to fit on one page can make text and faint gridlines too small, so consider printing on more pages instead of shrinking everything.
- Print a test page or save a PDF. If the preview looks right, print one page first when practical. You can also select a PDF printer in the print screen to inspect a file without using paper. Check that the lines are visible at normal viewing size and that the right rows and columns are included before printing a large workbook.
- Set up other worksheets separately. Return to each sheet tab you need and confirm its Page Layout > Sheet Options > Gridlines > Print checkbox. A print setting on one worksheet does not necessarily mean another worksheet is configured the same way. Preview each sheet or print a small sample if their layouts differ.
Alternative route: You can reach the same setting from the worksheet’s Page Setup dialog. On the Page Layout tab, click the small dialog launcher in the Page Setup group, open the Sheet tab, tick Gridlines in the Print section, and select OK. The dialog is useful when you also need to set a print area, rows to repeat at the top, or other sheet-specific print options.
On Mac: Select the worksheet and open the Page Layout tab. In the gridline controls, enable the printing option, then use File > Print to preview. Ribbon labels and arrangement can vary slightly by Excel version. The Mac print shortcut is Command+P, rather than Ctrl+P. In Excel for the web, use its Page Layout and print controls if the gridline option is available; if you cannot find a print checkbox, open the workbook in the desktop app and set the option there.
Common Mistakes
- Checking View instead of Print. Seeing gray lines on your monitor does not prove they will print. In Page Layout > Sheet Options > Gridlines, check the box specifically under Print.
- Expecting gridlines to show through cell fill. Excel gridlines generally do not appear in cells that have a fill color, including a white fill. This can make parts of a table look as if the print setting failed. Remove the fill with Home > Fill Color > No Fill, or use cell borders for a consistent table outline.
- Assuming gridlines are borders. Gridlines are the worksheet’s default cell guides; they are not part of the cell formatting. Borders are deliberate formatting and can be styled or printed independently. If you need strong, precise lines around particular cells, borders are usually the better choice.
- Forgetting the selected print range. Choosing Print Selection or having a limited print area can omit cells outside the range. Check the print screen’s selection and the setting under Page Layout > Print Area.
- Making the sheet too small. Fit-to-page scaling can reduce faint lines along with the text. A dense worksheet may be more readable across several pages, or with landscape orientation and narrower margins.
Tips
- Use borders for important structure. Gridlines are usually thin and light, and their appearance can vary with the printer. Add borders to totals, section breaks, or table edges that must stand out. You can leave gridline printing on for the remaining cells.
- Use a PDF as a preview you can share. Choosing a PDF option in File > Print lets you check page breaks and line visibility without making a paper copy. A PDF preview is also useful when another person will print the workbook on different equipment.
- Repeat headings on multi-page printouts. If readers need to identify columns on later pages, open the Page Setup dialog and use the Sheet tab’s Rows to repeat at top field. This repeats chosen row labels; it is separate from printing gridlines.
- Save after changing print settings. Save the workbook so the worksheet’s print setup is retained for the next session. If you are preparing a one-off print and do not want to change the original, make a copy first.
- Keep the printout legible, not merely complete. Preview at the intended paper size. If the grid is faint or the content is cramped, use borders for key areas, adjust orientation, or split the output across pages rather than relying on a single shrunken page.
Troubleshooting
The preview has no gridlines. Return to the worksheet and confirm that Print, not just View, is checked in the Gridlines row. Reopen File > Print after changing it. If the sheet contains filled cells, test a cell with no fill; gridlines are not drawn over filled cells. If the cells need a colored background, add borders instead.
Only part of the sheet prints. Check Page Layout > Print Area and clear an old print area if it is restricting the output. In the print screen, confirm that you are printing the active sheet or workbook, rather than only the current selection. Also verify the page range and look for hidden rows or columns that may affect what appears.
The lines are present but too faint. Gridlines are intentionally subtle, and a printer’s settings, toner, or paper can make them hard to see. Increase the printer’s print quality if that option is available, try a different printer setting, or apply borders to the cells that need clearer separation. Excel does not provide a simple worksheet gridline color control for printed gridlines, so borders are the dependable way to choose a stronger line style.
The first page looks right but later pages do not. Use the preview navigation controls to inspect every page. Confirm the worksheet is not being split in an unexpected place, and review scaling and page breaks. Gridline printing applies to the sheet’s printed pages, but a print area or page range can exclude portions of the sheet. For repeated column labels, set rows to repeat at the top in Page Setup; that setting does not replace gridline printing.
You cannot find the Print checkbox. Confirm that a worksheet, rather than a chart sheet or another object, is active, then check the Page Layout ribbon or the Page Setup dialog’s Sheet tab. If you are working in Excel for the web and the control is not shown in your version, open the file in desktop Excel, set the option, and preview there.
Frequently Asked Questions
Why do gridlines show on screen but not on paper?
Excel has separate View and Print checkboxes. Turn on Page Layout > Sheet Options > Gridlines > Print, then check the print preview.
Can I print gridlines without showing them on screen?
Yes. Leave View unchecked and check Print. The two controls are independent.
Can I print gridlines for only part of a worksheet?
Set a print area for the cells you want to print, then enable gridline printing for that worksheet. Preview the result to confirm the intended range and lines are included. For a deliberately formatted partial table, borders may give you more control.
Do gridlines print on cells with a white background?
Usually not if the cells have a white fill applied. Use Home > Fill Color > No Fill to remove the fill, or apply borders where lines are required.
Are gridlines the same as cell borders?
No. Gridlines are worksheet guides that can be displayed or printed with a sheet-level option. Borders are cell formatting that you can apply to specific cells and customize. Borders are more reliable when lines need to be prominent or selective.
Will this setting apply to every sheet in my workbook?
Do not assume so. Check the Print option on each worksheet you plan to print, and preview each one. A workbook can contain sheets with different print areas, orientations, and gridline settings.
Related
- Hide Excel Columns Based on Cell Values Automatically
- Forgot Excel Sheet Password? Safe Recovery Options
- How to Lock and Protect an Excel Sheet in Microsoft 365
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Add Page Numbers in Word Using a Keyboard ShortcutIn Word for Microsoft 365 on Windows, press Alt+N to open the Insert tab, then follow the on-screen…
- Box Plot in Excel: Step-by-Step InstructionsTo make a box plot in Microsoft Excel for Microsoft 365 on Windows, arrange each group of numeric…
- Compare Two Columns in Excel Without Matching RowsTo compare two columns as unordered lists—not by checking cells on the same row—test whether each value in…
- How to Add an Exchange Shared Mailbox in Outlook 365To add an Exchange shared mailbox in Outlook, first have your Microsoft 365 or Exchange administrator grant your…
- Cash Flow Excel Sheet: Build a Reliable Monthly ForecastA cash flow Excel sheet tracks when money comes in and goes out, then calculates the cash left…
- How to Insert a Check Box in Word Using Alt+X ShortcutTo insert an empty check box in Word on Windows, type 2610 and press Alt+X; Word converts the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.