Yes. In Excel for Microsoft 365 on Windows, select the worksheet, go to Page Layout > Sheet Options > Gridlines, and check Print. Then open File > Print to confirm the lines appear in the preview. Excel gridlines are different from cell borders, and borders are often the better choice when you need strong, consistent lines on paper.
Gridlines and borders are not the same
Gridlines are the faint lines Excel displays between cells to help you read and edit a worksheet. They are a viewing aid, not part of the data, and they do not print by default. The Print checkbox controls whether Excel includes those gridlines when it prints the sheet. It does not change the worksheet’s values or the lines you see while editing.
Borders are formatting that you apply to selected cells. They can be thicker, colored, or limited to particular edges, and they normally print as part of the cell formatting. For example, gridlines can give a plain table of names and dates a light row-and-column structure, while borders can outline a total row or separate sections. If you want every cell in a range to have a clearly defined edge, applying borders is more dependable than relying on gridlines.
A common misconception is that turning on View gridlines also turns on printed gridlines. These are separate settings. A sheet can show gridlines on screen but print without them, or hide them on screen while still having its Print setting enabled. Always check the print preview rather than assuming the screen view matches the paper output.
Turn on printed gridlines in Excel for Windows
Use these steps in the Microsoft 365 desktop app for Windows:
- Click the worksheet tab you want to print. If the workbook has several sheets, make sure you are on the correct one.
- Select the Page Layout tab on the ribbon.
- In the Sheet Options group, find Gridlines.
- Under the Print heading, select the checkbox. The separate View checkbox controls whether gridlines appear on your screen.
- Choose File > Print, or press Ctrl+P, and inspect the preview before printing.
If you do not see the checkbox clearly, widen the Excel window or look for the Sheet Options group on the Page Layout ribbon. You can also open the Page Setup dialog from the small dialog box launcher in the Page Setup group, select the Sheet tab, and enable Gridlines in the Print section. The dialog is useful when you are already adjusting paper size, print titles, or other page settings.
On a Mac, the same distinction applies: enable the Print option for Gridlines on the Page Layout tab, then check the print preview. The ribbon layout can vary with the Excel window size and version. In Excel for the web, available print controls can differ from the desktop app; if you cannot find a gridline-print option or need precise page setup, open the workbook in desktop Excel.
Check the preview before printing
Print Preview is the quickest way to catch missing lines, blank pages, or a table that has been shrunk too much. In Windows Excel, use File > Print. Look closely at the cells, especially the outside edges of the table and any rows or columns that cross a page break. The preview shows how the current print settings combine; it is more useful than judging the worksheet only by its on-screen appearance.
If the preview looks right, choose the printer and the number of copies, then print. If it shows only part of the worksheet, check whether Excel is printing the active sheet, the entire workbook, or a selected range. In the Print screen, the settings menu includes choices such as Print Active Sheets, Print Entire Workbook, and Print Selection. A selection can exclude cells whose gridlines you expected to see.
Also confirm the paper size, orientation, and margins. A wide worksheet may need landscape orientation, while a narrow table may fit in portrait. These choices affect page breaks and scale, but they do not replace the Gridlines > Print setting.
When borders are a better choice
Gridlines are subtle and are intended to define the worksheet’s cell structure. They generally print in a light tone, and you have little control over their weight or color. If the document must be easy to read on a low-quality printer, photocopy, or screen-reader-friendly digital printout, borders let you make the important structure more visible. Borders are also useful when only some cells need dividing lines or when the table has shaded sections.
To add borders, select the cells, then use Home > Borders in the Font group and choose an option such as All Borders or Outside Borders. For a more deliberate table, apply inside borders and an outside border separately, or use the Format Cells dialog to set a line style and color. Apply formatting only to the range you mean to print; selecting an entire worksheet and adding borders can produce an unnecessarily dense page.
One detail can explain why gridlines disappear in only part of a worksheet: cells with a fill color may not display the ordinary gridlines. A white fill can count as a fill even when it looks like the default background. If you need the cells to remain filled but still want visible divisions, add borders. If you do not need the fill, select the affected cells and choose Home > Fill Color > No Fill, then inspect the preview again.
Make a large worksheet readable on paper
Printing gridlines does not guarantee that the whole worksheet will fit legibly on a page. Excel may split a wide or long range across multiple pages. Before printing, decide whether readers need every row and column together or whether repeated pages with a readable scale are better.
- Set the print range with Page Layout > Print Area > Set Print Area if you want to exclude notes or unused sections. Clear an old print area from the same menu if Excel is omitting data you expected to print.
- Use Page Layout > Orientation to choose Portrait or Landscape, and check Size and Margins for the paper and printer you will use.
- For a wide sheet, the Scale to Fit controls on Page Layout can fit all columns to one page wide. Be cautious about fitting both width and height to one page: a large table can become too small to read.
- For a table that spans several pages, use Page Layout > Print Titles to repeat a header row or left-side columns. Repeated headings help readers interpret later pages, although they do not add borders or change the gridline setting.
Page breaks are another useful check. Use View > Page Break Preview to see where Excel divides the worksheet into printed pages. A line that appears to stop at a page edge may simply continue on the next sheet of paper. You can adjust the print area, orientation, or scaling, then return to File > Print to review the result.
Common reasons lines do not print
If gridlines are missing, work through the likely causes instead of repeatedly changing unrelated formatting:
- Print is not checked. Revisit Page Layout > Sheet Options > Gridlines and check the Print box for the active worksheet.
- The wrong sheet or range is being printed. Confirm the selected sheet and the Print screen’s choice of active sheets, workbook, or selection.
- The cells have a fill. Remove the fill or apply borders where you need lines to show clearly.
- The sheet is scaled down. A very small print scale can make thin gray gridlines hard to distinguish. Try a larger scale, landscape orientation, or printing across more pages.
- The printer output is too faint. Gridlines are intentionally light. Use darker cell borders for a result that must stand out.
- The range is split across pages. Review Page Break Preview and the print preview to see whether the missing-looking edge is on a neighboring page.
Printer settings can also affect how light lines look, particularly in draft or economy modes. If the preview shows gridlines but the printed page does not, try a test page, check the printer’s quality settings, and consider borders for the important table edges. Excel’s preview is a useful guide, but the physical result can vary with printer and paper.
Printing several worksheets or sharing a PDF
Each worksheet has its own page setup, so do not assume that enabling gridlines on one sheet enables them throughout the workbook. If you need to print several sheets, review each one, especially if they have different layouts or print areas. You can select multiple worksheet tabs to group sheets and apply certain page-layout changes together, but grouping makes edits affect the selected sheets. Ungroup the sheets afterward and verify each preview to avoid carrying unintended settings into other tabs.
If you want to share a printable copy without sending it directly to a printer, choose File > Export or use File > Save As to create a PDF, depending on the options shown in your Excel installation. Review the print preview first: the PDF generally follows the workbook’s print layout, including page breaks, scaling, and print settings. A PDF is not a substitute for setting gridlines or borders; it preserves the result of those choices.
Frequently Asked Questions
Why do Excel gridlines show on screen but not in print?
Screen gridlines and printed gridlines have separate controls. On Windows, select Page Layout > Sheet Options > Gridlines > Print, then check File > Print.
Can I print gridlines for only part of a worksheet?
Gridline printing is a worksheet page setting, not a setting for an individual cell range. To show lines for just one table, apply borders to that range and leave other cells unformatted.
Can I make printed gridlines darker?
Excel does not provide the same control over gridline weight and color that it provides for borders. Apply darker cell borders if the lines need to be more prominent.
Do gridlines print when I save the sheet as a PDF?
They can, provided the worksheet’s Print gridlines option is enabled and the PDF uses the workbook’s print layout. Check the preview before saving or exporting.
Why do some cells have no gridlines even though Print is checked?
A cell fill can hide the ordinary gridlines, including a white fill. Remove the fill or apply borders to the affected cells, then inspect the preview again.
Related
- Calendar Schedule Template in Excel: How to Build One
- Free Calendar Excel Templates: How to Choose
- Calendar Layout Template for Excel: How to Make One
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Flash Fill vs AutoFill in Excel: What’s Different?Flash Fill recognizes a pattern in example data and fills in similar text, while AutoFill copies cells or…
- How to Double Space in Word: Shortcut and StepsTo double-space text in Microsoft Word for Microsoft 365 on Windows, select the text or paragraphs and press…
- Numbers Text to Columns: Split Your Data CorrectlyYes. Apple Numbers can split text from one cell or column into separate columns: on a Mac, select…
- How to Add or Remove a Draft Watermark in Microsoft WordTo add a Draft watermark in Word for Microsoft 365 on Windows, open the document and choose Design…
- Create a Distribution List in Outlook for Mac: StepsTo create a distribution list in Outlook for Mac, open People, choose New Contact List, name the list,…
- XLOOKUP in Google Sheets: Search Across Two SheetsTo look up a value on another Google Sheets tab, put the value to find in A2 and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.