Excel Print Gridlines: How to Show Them on Paper and PDF

How-to basics · Updated November 18, 2026

Yes. In Excel for Microsoft 365 on Windows, select the worksheet, open Page Layout, and under Sheet Options check Print in the Gridlines section. Gridlines are normally visible on screen but do not print unless you enable this setting; check File > Print to preview the result before printing or saving a PDF.

Turn on gridlines for printing

The print setting belongs to an individual worksheet, so repeat these steps for each sheet that should show gridlines. If you have several sheets selected, Excel may apply the setting to all of them, but it is safest to check the sheet tabs before changing page settings.

  1. Click the worksheet tab you want to print. If the workbook has multiple sheets, make sure you have selected the intended one.
  2. Open the Page Layout tab on the ribbon.
  3. Find Sheet Options. In the Gridlines group, select the Print checkbox. The separate View checkbox controls whether gridlines appear on screen.
  4. Press Ctrl+P or choose File > Print to open Print Preview. On a Mac, use Command+P to open the print screen.
  5. Review the page preview, then print or choose a PDF printer or PDF-saving option if you want a digital copy.

In some ribbon layouts, the Sheet Options controls are compact or collapsed. Look for the Gridlines labels and their separate View and Print boxes, rather than assuming that turning on visible gridlines also enables printing. You can also open the Page Setup dialog from the small dialog launcher in the Page Layout ribbon, choose its Sheet tab, and select Gridlines in the Print section. The dialog provides another route to the same worksheet print option.

What the Print gridlines setting changes

Excel uses two related but independent controls. View determines whether the light cell guides appear while you work in the worksheet. Print determines whether Excel includes those guides in printed output and in a PDF created through Excel’s print process. A sheet can therefore show gridlines on your monitor but produce a page without them, or hide them on screen while still including them in a printout.

Gridlines are not the same as cell borders. Gridlines are the worksheet’s default guides between cells; they are generally light and unobtrusive. Borders are formatting applied to particular cell edges, and they can be given different colors and line styles. The Print gridlines option does not create or remove borders. It also does not change the values, formulas, or layout of the cells.

The setting is most useful for simple tables where the worksheet’s natural row-and-column structure is enough to guide the reader. For example, a basic inventory list with item names in column A, quantities in column B, and locations in column C may be easier to follow with gridlines printed. For a polished report, selected borders often provide more control and a cleaner result.

Check the print preview before printing

Print Preview is important because a worksheet’s on-screen appearance is not a reliable picture of the printed page. The preview shows how Excel combines the gridline choice with the print area, paper size, margins, orientation, scaling, and page breaks. If the gridlines look too faint, crowded, or incomplete, adjust the sheet or its print settings before sending it to a printer.

Open File > Print and use the preview pane to move through every page. Confirm that the intended range appears and that the gridlines are visible where you expect them. If the worksheet spans several pages, inspect the edges where one page ends and another begins; repeated headings and sensible page breaks can matter as much as the gridlines themselves.

  • Check the selected printer and paper size. A mismatch can cause unexpected scaling or page breaks.
  • Confirm the print range. Under the print settings, Excel can print the active sheet, the entire workbook, or a selected range, depending on what you choose.
  • Use landscape orientation for a wide table if portrait pages make columns too narrow.
  • Try a different scaling choice if text or columns become too small. Fit-to-page scaling can squeeze a wide sheet, so inspect readability rather than judging only whether it fits.
  • For a multi-page table, consider repeating the header row so readers can identify columns on later pages.

Print only part of a worksheet

You do not have to print every used cell on a sheet. Select the cells you need, then use Page Layout > Print Area > Set Print Area to define the range Excel should print. The Gridlines Print option can then be used for the sheet’s printed output, while the print area controls which portion of the sheet is included. Review the preview because an incorrectly defined print area can make it appear that gridlines are missing simply because the expected cells are not on the page.

To remove a print area later, choose Page Layout > Print Area > Clear Print Area. If you select a new print area, Excel replaces the existing one for that sheet. For a one-time print of a selection, use the print settings to print the selected range rather than leaving a permanent print area behind. This is useful when a workbook contains notes or calculations that should remain in the file but not appear on the handout.

When a table continues across multiple pages, set up the page layout as well as the print area. On Windows, use Page Layout > Print Titles to choose rows or columns to repeat on each printed page. For example, if the column labels are in row 1, repeating row 1 makes later pages easier to interpret. Print Titles and gridlines solve different problems: one repeats identifying labels, while the other draws cell guides.

When borders are better than gridlines

Gridlines are convenient, but they are a general worksheet aid rather than carefully designed table formatting. They may be too light for a photocopy, may make a dense sheet look busy, or may extend through blank cells in the printed region. If readers need to distinguish totals, sections, or data-entry fields, borders let you emphasize just the relevant edges. You can apply them from Home > Borders, choosing a border style for selected cells.

For example, imagine a monthly expense report with category, date, and amount columns. Light gridlines can help readers track across ordinary rows, but a stronger bottom border below each monthly subtotal makes the important breaks clearer. You could use borders for the table and leave worksheet gridlines off in print. Conversely, a plain working list may not need custom formatting at all, so enabling printed gridlines is faster and easier to maintain.

A useful rule is to choose one visual system deliberately. If you apply borders throughout a table and also print gridlines, some edges may look heavier or inconsistent because borders and gridlines are separate features. Preview the result and, if it looks cluttered, turn off printed gridlines or simplify the borders. A PDF is a convenient way to inspect the final appearance without using paper.

Common reasons gridlines do not appear

If the option is checked but the printout still looks blank between cells, diagnose the issue in Print Preview first. That helps distinguish an Excel setting from a printer or paper issue. Work through these common causes:

  • The wrong sheet is active. The print option is a sheet-level setting. Return to the relevant tab and check its Page Layout settings.
  • You changed View, not Print. Seeing lines on the screen only confirms the View setting. Make sure the Print checkbox is selected.
  • The expected cells are outside the print range. Check the print area and the print selection in File > Print.
  • The lines are too faint on paper. Gridlines are subtle by design and can be hard to see with some printers, paper, or reproduction settings. Use selected borders when clear separation is essential.
  • The preview is being scaled heavily. A wide sheet fitted onto one page may become too small to read. Change orientation or scaling and check the preview again.
  • You are printing from another Excel version or platform. Look for the worksheet’s gridline print control; if the web interface does not offer the needed option, open the workbook in the desktop app.

If lines show in Excel’s preview but not on the physical page, investigate the printer, driver, toner or ink, and print-quality settings. If the same PDF also lacks lines, revisit the worksheet setting and preview; the issue is more likely in the workbook or the selected print range than in the physical printer. Borders are a dependable alternative when a line must remain visible in a particular location.

Excel for Mac and Excel for the web

In Excel for Mac, the ribbon arrangement can differ from Windows, but the relevant control is still the worksheet’s gridline printing option in the page layout or sheet settings. Look for separate controls for viewing and printing gridlines, and use the print preview before producing the page. The common print shortcut differs: use Command+P on Mac rather than Windows Ctrl+P.

Excel for the web has a more limited and changing set of print and page-layout controls than the desktop application. If you cannot find a Print gridlines option in the browser interface, open the workbook in Excel for Microsoft 365 on Windows or Mac and set it there. This is also the safer choice when you need precise control over print areas, repeated titles, scaling, or multi-page output. Always verify the final print preview in the version you plan to use.

Frequently Asked Questions

Do Excel gridlines print by default?
No. Worksheet gridlines are normally visible on screen, but Excel does not print them by default. Select Page Layout > Sheet Options > Gridlines > Print for the sheet, then check Print Preview.

Why do I see gridlines in Excel but not in my printout?
The View and Print controls are separate. You may have gridlines visible on screen without enabling the Print checkbox. Check the sheet’s Page Layout settings and confirm that the cells are included in the print range.

Can I print gridlines in only one part of a worksheet?
You can limit the printed cells by setting a print area or printing a selected range. The gridline printing control is associated with the worksheet, so use the print area to restrict what appears and verify the result in preview.

How do I make Excel gridlines darker on paper?
The standard gridlines are subtle and do not offer the same per-line styling control as borders. Apply borders to the cells or edges that need stronger definition, then preview the page. This also gives you more control over which lines appear.

Will gridlines appear when I save or print a PDF?
They can appear if the worksheet’s Print gridlines option is enabled and you create the PDF through Excel’s print workflow. Check Print Preview before saving, because the PDF reflects the chosen sheet, print area, and page setup.

Do borders and gridlines mean the same thing?
No. Gridlines are default worksheet guides controlled by the View and Print settings. Borders are formatting applied to cell edges and can be customized. Printing gridlines does not add borders, and borders can print even when gridlines are turned off.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.