To print gridlines in Excel for Microsoft 365 on Windows, open the worksheet, go to Page Layout, and under Sheet Options, select the Print checkbox beneath Gridlines. Check the print preview with Ctrl+P before printing. This adds the worksheet’s faint cell lines to the printed page; it does not add dark cell borders or change the worksheet itself.
What You’ll Need
- An Excel workbook with the worksheet you want to print.
- A printer, or access to a print-to-PDF option, to produce a paper or digital copy.
- Excel for Microsoft 365 on Windows for the menu steps below. Excel for Mac has a similar Page Layout setting; Excel for the web may not offer the same print-gridlines control, so use the desktop app if the option is missing.
You do not need to select every cell first. Before printing, decide whether you want the whole worksheet or just a particular range, and check that any cells you expect to show are included in the print area.
Step-by-Step
- Open the worksheet you want to print. If your workbook has several sheets, click the correct sheet tab at the bottom of the Excel window. Gridline printing is a worksheet setting, so turning it on for one sheet does not automatically turn it on for every other sheet. If you plan to print multiple sheets, you can set each one separately; see the tips below before grouping sheets.
- Go to the Page Layout tab. On the ribbon, select Page Layout. Find the Sheet Options group, which has separate controls for Gridlines and Headings. The Gridlines controls usually include View and Print. View affects whether lines appear on your screen; Print affects whether they appear on paper or in a PDF.
- Turn on printing for gridlines. Under Gridlines, select the checkbox labeled Print. If it is already checked, the setting is on. Do not rely on the View checkbox: it can be unchecked while printing is enabled, or checked while printing is disabled. Those settings control different things.
- Choose the cells or area to print, if needed. By default, Excel prints the worksheet’s used area, subject to its page settings. To print only a specific selection, highlight the cells, then choose Page Layout > Print Area > Set Print Area. To print a one-time selection without making it the worksheet’s saved print area, use File > Print and select the option for printing the selection, if it is available in the print settings. Make sure the range includes the blank cells whose gridlines you want to see.
- Check the page setup and scaling. Choose Page Layout > Orientation and select Portrait or Landscape to suit the sheet. Set margins or paper size if needed. In the Scale to Fit group, scaling a wide worksheet to one page can make text and gridlines very small. Prefer fitting the width to one page while allowing the sheet to use multiple pages in height when readability matters.
- Preview before printing. Press Ctrl+P on Windows, or select File > Print. Review every preview page, not just the first one. Check that the gridlines are visible, the intended rows and columns are included, and the content is not clipped or shrunk too far. Use the back arrow to return to the worksheet if you need to adjust the settings.
- Print or save the result. In the print screen, choose the correct printer, paper size, and number of copies, then select Print. To create a digital copy, choose a PDF printer or the available PDF option and save the file. Reopen the PDF if the lines look faint or the page breaks differ from what you expected in Excel.
Alternative route: If you cannot find the Print checkbox on the ribbon, open the Page Setup dialog using the small dialog box launcher in the Page Setup group on the Page Layout tab. Select the Sheet tab, check Gridlines under Print, and select OK. Then reopen print preview to confirm the change.
Common Mistakes
- Checking View instead of Print. The View option only controls on-screen gridlines. You need the separate Print checkbox to include lines on the printed worksheet.
- Assuming gridlines are borders. Gridlines are Excel’s default faint guides. They are not cell formatting, and their appearance is limited. If you need strong, dark, or selective lines, apply borders using Home > Borders. Borders are printed as formatting even when gridline printing is off.
- Expecting gridlines to show through cell fills. Cells with a fill color may not show their normal gridlines in print. Remove the fill if it is unnecessary, or add borders to the filled cells so their edges remain clear.
- Printing a range that is too small. Gridlines appear only where Excel prints cells. A print area that excludes nearby blank cells will not include their gridlines. Expand or clear the print area if the page needs a larger grid.
- Forgetting that each sheet has its own setting. Enabling Print on one tab does not necessarily enable it on the other tabs in the workbook. Check each worksheet that will be printed.
Tips
- Use borders for presentation-quality tables. Gridlines are useful for basic worksheets and drafts, but they are light and not intended as a design tool. Use borders when readers must clearly distinguish rows, columns, totals, or section boundaries.
- Check contrast on a PDF or test page. Gridlines can look different on screen and on a printer, especially with draft or toner-saving settings. A PDF preview or one-page test print helps reveal whether the lines are visible enough.
- Set a sensible print area. Choose Page Layout > Print Area > Clear Print Area to remove an old area that is restricting the output. Then select the intended range and set a new print area if you need a consistent, repeatable printout.
- Group sheets only when their layouts match. To apply a setting to several sheets at once, select their tabs together, then set Print under Gridlines. Use this cautiously: grouped sheets are edited together. Right-click a selected sheet tab and choose Ungroup Sheets as soon as you finish.
- Keep the scale readable. For a wide table, landscape orientation or narrower margins may work better than shrinking everything onto one page. If readers need to follow rows across pages, repeat the header row using Page Layout > Print Titles.
Troubleshooting
The preview has no gridlines. Return to the worksheet and check Page Layout > Sheet Options > Gridlines > Print. Confirm that you are looking at the correct sheet, since the setting is per worksheet. Also inspect the selected print area: if it is too small or excludes the cells, the preview cannot show their lines. Reopen File > Print after making a change so the preview refreshes.
The checkbox is unavailable or dimmed. First click an ordinary cell in the worksheet rather than a chart, shape, or other object. Then check whether a print area or unusual selection is affecting the sheet. If the ribbon control remains unavailable, open the Page Setup dialog and inspect its Sheet tab. You can also clear an unintended print area from Page Layout > Print Area > Clear Print Area, then try again.
Only some lines are missing. Look for cells with fill colors, merged cells, or manually formatted borders that make the default grid hard to distinguish. Gridlines are not printed over filled cells in the same way as ordinary unformatted cells. Apply a border to the affected cells if you need their edges to print consistently. Also check that the missing cells fall inside the print range.
The lines are too faint or the page looks crowded. Gridlines are intentionally subtle, and Excel does not provide a setting to choose their printed color or thickness. Add borders to important areas instead of trying to darken the gridlines. If the table is crowded, change orientation, margins, or scaling, and inspect each page in preview to avoid text becoming too small.
The option is missing in Excel for the web. Some print-layout controls differ in the browser version. Open the workbook in the desktop Excel app and use Page Layout > Sheet Options > Gridlines > Print. In Excel for Mac, look for the equivalent Gridlines Print control on the Page Layout tab; the ribbon arrangement can vary by version. Use Command+P on Mac to open printing, compared with Ctrl+P on Windows.
Frequently Asked Questions
Why do gridlines show on my screen but not on the printout?
Screen display and printing use separate settings. Keep View checked if you want lines on screen, and check Print under Gridlines on the Page Layout tab to include them in output.
Can I print gridlines for just part of a worksheet?
Yes. Set a print area for the cells you want using Page Layout > Print Area > Set Print Area, then enable Print under Gridlines. Preview the result to ensure the selected range includes all the cells you need.
Can I change the color or thickness of printed gridlines?
Not through the gridline-printing setting. To control line color, weight, or which edges appear, format the cells with borders from Home > Borders.
Will gridlines print on every worksheet in the workbook?
Not automatically. The setting is applied to individual sheets. Enable it on each sheet you intend to print, or carefully group matching sheets, change the setting, and then ungroup them.
Do gridlines print on a PDF?
Yes, when Print is enabled for the worksheet and the PDF is generated from Excel’s print screen. Check the PDF itself because gridlines are light and can be harder to see at some zoom levels.
Why are lines missing around colored cells?
Cell fill can hide the default gridlines. Remove the fill if appropriate, or add cell borders where you need visible edges. Borders are the more reliable choice for a formatted table.
Related
- How to Hide Columns in Excel for the Web
- How to Hide Columns in Excel: A Step-by-Step Guide
- How to Hide Columns in Excel on Mac Without Losing Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Create Columns in a Word Document: A Simple GuideTo create columns in a Word document, open the Layout tab, select Columns, and choose a layout such…
- How to Split a Cell in Google Sheets Into Two CellsTo split text in Google Sheets, select the cell or range, choose Data > Split text to columns,…
- Flash Fill in Excel: Keyboard Shortcut and How to Use ItTo use Flash Fill in Excel for Microsoft 365 on Windows, type one example of the result you…
- Google Sheets Percentage Bar: Make an In-Cell Progress BarTo make a percentage bar in Google Sheets, put your percentage in one cell and use the SPARKLINE…
- Excel Consolidate: Combine Data from Multiple SheetsTo use Consolidate in Excel for Microsoft 365 on Windows, choose a blank destination cell, go to Data…
- Export Outlook Contacts to Excel: Steps and OptionsYes. You can export Outlook contacts to a comma-separated values (CSV) file and open that file in Excel;…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.