Yes. In Excel for Microsoft 365 on Windows, select the worksheet, then choose Page Layout > Sheet Options > Gridlines > Print. Check File > Print to confirm the lines appear in the preview before sending the sheet to your printer.
What Printed Gridlines Do
Excel’s gridlines are the light gray lines that separate cells on a worksheet. They are a screen aid, not part of the cell contents, so Excel does not print them by default. Turning on the Print setting tells Excel to include gridlines in the printed worksheet; it does not change the values, formulas, or formatting in the cells.
This setting is useful when a sheet has a simple table without borders and readers need to follow rows and columns on paper. For example, a weekly inventory list with product names in column A and quantities in column B may be easier to scan when the cell divisions print. The setting is also useful for blank forms, provided the print area includes the cells where people are expected to write.
Printed gridlines are generally thin and pale. Their appearance depends on the printer, paper, and print settings, so they may look subtler on paper than they do on screen. If the divisions need to be prominent, use cell borders instead of relying only on gridlines.
Turn On Gridlines for Printing
Enable the setting for each worksheet you intend to print. In Excel for Microsoft 365 on Windows:
- Open the worksheet and select the sheet tab at the bottom of the workbook.
- Choose the Page Layout tab on the ribbon.
- Find the Sheet Options group. Under Gridlines, select the Print check box. The View check box controls on-screen gridlines and is a separate setting.
- Open File > Print and inspect the preview. If the lines show there, continue with printing.
The checkbox is a worksheet-level page setting. A workbook with several tabs may therefore need the setting enabled on each tab that will be printed. If you have grouped multiple sheet tabs, a Page Layout change can affect the selected group; check which tabs are selected before changing settings. To avoid unintentionally changing several sheets, select just the intended tab first.
If you cannot see Sheet Options, maximize the Excel window or widen it: a narrow ribbon can collapse group controls. You can also open the Page Setup dialog from the small dialog-box launcher in the Page Setup group, then use its Sheet tab and select Gridlines under Print. The dialog offers another way to reach the same print behavior.
Check the Preview and Page Setup
File > Print is more than a final confirmation. The preview shows how the worksheet will be divided across pages and whether gridlines are visible in the output. If a table spans several pages, inspect each page using the preview controls. A line that appears on one page may be too faint to distinguish on another, especially when the content is small or scaled down.
Before printing, confirm the printer, paper size, orientation, margins, and scaling options. These settings do not switch gridlines on or off, but they affect readability. For instance, fitting a wide worksheet onto one portrait page can shrink the text and make thin gridlines difficult to see. Landscape orientation, a larger paper size, or printing a selected range across more pages may produce a clearer result.
Use File > Print to choose what to print, such as the active sheet, the entire workbook, or a selected range. A print area can limit which cells are included. If the preview shows no lines around a blank section, check whether that section is inside the print area and whether the selected print option includes its worksheet. Previewing first can save paper and reveal page breaks or clipped columns before printing.
Which Cells and Lines Are Included?
Gridlines print within the portion of the worksheet included in the printout. They are not a substitute for adding borders to particular cells, and enabling them does not create a boundary around every possible row and column on the sheet. Excel prints the worksheet’s printable content and any area you have explicitly set to print, subject to the chosen print settings.
This distinction matters for blank templates. If you want a page of empty boxes, include those cells in the print range or set an appropriate print area, then preview the result. Merely turning on gridlines does not make Excel print an unlimited blank worksheet. To define a range, select the cells and use Page Layout > Print Area > Set Print Area. You can remove that limit later with Page Layout > Print Area > Clear Print Area.
Gridlines also do not automatically repeat as column headings or row labels on every printed page. If a long table needs its headings repeated, configure print titles separately through Page Layout > Print Titles. That setting addresses repeated headings; it is different from printing gridlines.
Why Gridlines May Be Missing or Hard to See
If the preview or paper does not show the expected lines, check the common causes in this order:
- The Print box is not selected: Return to Page Layout > Sheet Options > Gridlines and verify Print for the active worksheet. Do not confuse it with View, which affects only the worksheet display.
- You are printing a different sheet: Confirm that the active sheet or print selection is the tab where you enabled the setting. Each worksheet can have its own page setup.
- The cells have a fill color: Excel does not display normal worksheet gridlines through cells with a fill color. If the cells are filled, apply borders where divisions should appear. Changing the fill to No Fill may restore visible gridlines on screen, but borders are more dependable for a designed printout.
- The print area excludes the cells: Check Page Layout > Print Area or choose the appropriate option in File > Print. A correct gridline setting cannot print cells outside the chosen range.
- The lines are too faint: Try a higher print quality setting if available, avoid excessive scaling, or replace gridlines with darker borders. Printer and driver settings vary, so the preview may not perfectly represent the final shade.
- The sheet is being printed from the web app: Open the workbook in the desktop version of Excel and set the print option there if the web interface does not offer the gridline control.
Also check whether the worksheet contains a background image or heavy cell formatting that makes the faint lines difficult to distinguish. If the preview itself has no gridlines, investigate the worksheet or print selection first; changing printer ink or toner settings will not turn an unchecked Excel option on.
Gridlines or Cell Borders?
Gridlines are a quick way to show the ordinary cell structure across a worksheet. They are controlled as a sheet display and print option, and they normally appear in a subtle gray. Cell borders are formatting applied to selected cells. You can choose which edges to draw and select a line style and color, making borders appropriate when only certain divisions matter or when stronger contrast is required.
For a simple data list, printed gridlines may be enough and take only a moment to enable. For an invoice, schedule, checklist, or form, borders usually give more predictable results. For example, a schedule may need a heavier border around each day and no line between two cells that form one combined heading. Gridlines cannot express that selective design; borders can.
To add borders, select the cells and use Home > Font > Borders, then choose an available border option. A border remains part of the cell formatting whether or not gridline printing is enabled. You can use both: keep gridlines for the rest of the sheet and add stronger borders around a total row or key section. If a cell has a fill, borders are especially useful because gridlines are not shown through filled cells.
Mac and Excel for the Web
In Excel for Mac, select the worksheet and use the Page Layout tab’s Gridlines section, then select Print. The ribbon layout can differ slightly by version, but the setting is still separate from the option for viewing gridlines on screen. Check the print preview on the Mac before printing, just as you would on Windows.
Excel for the web has a more limited set of page-layout controls than the desktop application, and its gridline printing options may not match the Windows ribbon. If you cannot find a Print checkbox for gridlines, use Open in Desktop App and enable the setting in Excel for Microsoft 365 on Windows or Mac. This is also a practical option when you need precise control over print areas, page breaks, or titles.
Frequently Asked Questions
Are Excel gridlines printed by default?
No. Gridlines normally appear on the worksheet screen but are not printed unless you enable the Print option under Page Layout > Sheet Options > Gridlines.
Why can I see gridlines on screen but not on paper?
The View option controls screen display, while Print controls printed output. Select Print for the worksheet and check File > Print. Also verify the print area and selected sheet.
Can I print gridlines for only part of a worksheet?
Yes. Set a print area for the desired cells with Page Layout > Print Area > Set Print Area, enable gridline printing, and review the preview. Only the chosen print range is included.
Can I make printed gridlines darker?
Gridlines have limited appearance controls compared with cell borders. For darker or selectively placed lines, apply borders to the relevant cells and choose a suitable color and style.
Does printing gridlines change the worksheet?
It changes a page setup option, not the cell values or formulas. It does not add border formatting to cells, and the on-screen View setting remains a separate control.
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
- Excel AND Statement for Conditional Formatting RulesTo use an AND statement in Excel conditional formatting, create a formula-based rule with the AND function. For…
- How to Add Checkboxes in an Excel File on SharePointTo add checkboxes to an Excel workbook stored on SharePoint, open the workbook in Excel, select the cell…
- How to Freeze Selected Rows in Excel While You ScrollTo freeze selected rows in Excel, click the cell in column A immediately below the last row you…
- COUNTIF Duplicate Formula in Google SheetsTo flag every nonblank value that appears more than once in Google Sheets, put this formula beside the…
- Unknown Range Name in Google Sheets: Causes and Fixes“Unknown range name” in Google Sheets means a formula contains a word or reference that Sheets is treating…
- When Was Excel Created? The 1985 Launch ExplainedMicrosoft Excel was created and first released in 1985, initially for Apple Macintosh computers. Its first Windows version…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.