How to Print with Gridlines in Excel: The Complete Step-by-Step Guide 2026 July

Knowing how to use excel print with gridlines is one of those foundational skills that separates a casual spreadsheet user from someone who produces genuinely professional output. By default, Excel displays gridlines on screen to help you navigate rows and columns, but when you send a spreadsheet to the printer, those helpful borders disappear entirely — leaving behind a sea of numbers with no visual structure. Enabling printed gridlines takes fewer than ten seconds, yet countless professionals overlook the setting entirely and end up with hard-to-read reports.

The gridlines feature in Excel refers to the faint gray lines that form the cell boundaries across your worksheet. On screen they are always visible, but the print version strips them out unless you explicitly tell Excel to include them. This is not a bug — it is a deliberate design choice that assumes most printed documents will use custom cell borders styled to match a company's brand. For quick reports, academic work, or data reviews, however, turning on gridlines is far faster than manually applying borders to every cell in a range.

Understanding when to print gridlines versus when to apply manual borders is a key judgment call. Printed gridlines look identical across every cell on the sheet — they are a uniform light gray with no thickness or color control. Manual borders, by contrast, let you choose line style, weight, and color, giving you the professional polish you see in financial models or dashboards. For internal use, status meetings, or rough data reviews, gridlines are perfectly adequate and save considerable formatting time.

Excel's Page Layout tab is the command center for everything related to printing, and the gridlines checkbox lives there under the Sheet Options group. You can also access the same setting through the Page Setup dialog box, which gives you a few additional controls in one place. Many power users prefer the dialog because it lets them configure gridlines, row and column headings, print area, and page order all at once — a real time-saver when preparing a complex workbook for distribution.

One thing that trips up many beginners is the difference between the gridlines checkbox in the View group versus the Print checkbox in the Sheet Options group on the Page Layout tab. The View checkbox controls whether gridlines are visible on your screen while you work. The Print checkbox controls whether they appear on paper or in a PDF export. It is entirely possible — and actually the default — to have gridlines visible on screen but absent from your printed output. Make sure you are checking the right box.

This guide walks you through every method available for enabling gridlines in Excel, including the Page Layout ribbon approach, the Page Setup dialog, applying the setting across multiple sheets at once, and troubleshooting the common reasons gridlines fail to appear even after you enable them. Whether you are using Excel 365, Excel 2021, Excel 2019, or an older version, the steps are nearly identical and fully covered here.

Along the way you will also learn related Excel skills that make your printed output even cleaner — things like freezing header rows before printing, using VLOOKUP in Excel to pull in the right data before you commit to paper, and understanding how to create a drop down list in Excel so data stays consistent before it ever reaches the printer. Gridlines are one piece of a broader printing workflow, and mastering the full picture will make your spreadsheet output look genuinely polished.

The Page Setup dialog is an alternative and arguably more powerful way to control how your Excel spreadsheet prints, and it gives you access to the gridlines setting alongside a dozen other print options in a single window. To open it, go to the Page Layout tab and click the small dialog launcher arrow in the bottom-right corner of the Page Setup group — the tiny diagonal arrow icon. Alternatively, press Alt, P, S, P in sequence on your keyboard to open the dialog directly without touching the mouse.

Once the Page Setup dialog opens, click the Sheet tab at the top. This tab contains the print-specific settings for your worksheet, separate from the page size and margin settings on the other tabs. In the Print section of the Sheet tab, you will see a checkbox labeled Gridlines. Check that box, then click OK. The dialog also lets you enable row and column headings, which prints the number row identifiers (1, 2, 3…) and the letter column identifiers (A, B, C…) — extremely useful when you need to reference specific cells during a meeting or review session.

The Page Setup dialog is particularly useful when you are configuring multiple settings at once. For example, you might want to set a specific print area, enable gridlines, choose to print row and column headings, set the page order, and adjust the print quality — all in a single visit to the dialog rather than hunting across the ribbon for each individual control. This approach is especially efficient for workbooks you print regularly, since you configure everything once and the settings are saved with the file.

Another powerful feature in the Page Setup dialog is the ability to set a print area. If your worksheet has data spread across a large range but you only want to print a specific section, you can type the cell range directly into the Print Area field on the Sheet tab. For example, typing A1:J50 will limit printing to just that block of cells. Combined with the gridlines checkbox, this gives you precise control over exactly what appears on paper and what stays on screen only.

One workflow that many Excel professionals use is printing with gridlines enabled alongside row and column headings for internal review drafts, then switching off both settings for the final polished version sent to stakeholders. The headings make it trivially easy for colleagues to say "cell G14 looks wrong" during a review meeting, since everyone can see the same reference grid on the printed page. For the final version, you would typically remove headings and gridlines and replace them with carefully styled borders and color fills that match your company branding.

The Page Setup dialog also contains the Headers/Footers tab, where you can add page numbers, the document title, the date printed, or the filename to every page automatically. For multi-page spreadsheets that you print with gridlines, adding a footer with the page number and total pages (Page 1 of 3) dramatically improves readability when someone is looking at a physical stack of papers. These small professional touches elevate a simple data printout into a document that looks intentional and well-prepared.

It is worth noting that the Page Setup dialog settings — including gridlines — are saved on a per-sheet basis within the workbook. If you enable gridlines on Sheet1 and then navigate to Sheet2, the gridlines setting on Sheet2 is completely independent. This means you can have gridlines enabled for a raw data sheet and disabled for a summary dashboard sheet within the same workbook. To apply the setting to multiple sheets at once, hold Ctrl, click each tab you want to configure, then check the gridlines box — the change will apply to all selected sheets simultaneously.

Even after checking the gridlines box in the Page Layout tab, some users find that their printed output still shows no gridlines at all. This is one of the most common Excel printing frustrations, and it almost always has one of a small number of root causes that are straightforward to diagnose and fix.

The first thing to check is whether the cells in question have a white fill applied. When a cell has a white background color set through the Fill Color tool on the Home tab, that white fill prints on top of the gridlines, effectively hiding them — even though gridlines are technically enabled.

To check for white cell fills, select all cells in your print range using Ctrl+A, then go to the Home tab, click the dropdown arrow next to the Fill Color bucket icon, and look at the current fill color. If it shows white or any solid color, that color will print and cover the gridlines underneath.

To remove fills and let gridlines show through, select your cells, open the Fill Color dropdown, and click No Fill. This is the single most common reason gridlines do not appear even when the print setting is enabled, and fixing it immediately resolves the issue in the vast majority of cases.

A second cause of missing printed gridlines is that the cells have manually applied borders that are set to white or that exactly match the page background. White borders applied through the Borders tool on the Home tab override the default gray gridlines — from Excel's perspective, you have told it to draw a white line where the gridline would be, so no gray line appears.

To remove all borders from a selection, go to Home, open the Borders dropdown, and click No Border. This clears all manual border formatting and lets the standard gray gridlines take over, assuming you have the Print checkbox enabled.

A third scenario where gridlines fail to print is when you are printing to a color printer that has a grayscale or black-and-white mode enabled. Some printer drivers convert light gray elements to white when printing in economy mode, and the default gridline gray is light enough to fall below the threshold.

Try printing in standard quality mode rather than draft or economy mode, or increase the contrast setting on your printer. Alternatively, apply a manual light gray border to all cells instead of relying on the default gridlines, since manual borders render more reliably across different printer models and driver settings.

A fourth cause that is easy to overlook is that the spreadsheet uses a page background image. Excel allows you to set a background image for a worksheet through Page Layout → Background, which tiles an image across the sheet. However, this background image does not print — and more importantly, it can visually mask gridlines on screen, leading you to believe gridlines are not set when in fact they are. Background images are screen-only decorations. Remove the background before printing if you want to confirm your gridline settings are working correctly.

Some users encounter the situation where gridlines print on some pages but not others within the same sheet. This almost always happens because cells in certain rows or columns have fill colors applied while others do not. The gridlines are printing fine everywhere — they are just invisible in the colored cells because the fill sits on top. The fix is consistent: either remove fills from all data cells, or embrace the filled design and use white borders styled in a color that matches your fills to create the visual separation you need without relying on default gridlines.

Finally, if you are printing to PDF rather than a physical printer, check which PDF export method you are using. Excel's built-in Save as PDF function (File → Save As → PDF) fully respects the Print Gridlines setting. However, some third-party PDF printer drivers handle gridlines inconsistently. If your PDF output is missing gridlines but your physical printer output includes them correctly, the issue is with the PDF driver rather than Excel's settings. Switching to Excel's native Save as PDF export resolves this in almost every case.

Once you have mastered basic gridline printing, there are several advanced techniques that will take your Excel printing workflow to a genuinely professional level. The first is understanding print areas in combination with gridlines. When you define a print area, Excel prints only the cells within that range.

Gridlines will appear only within the print area boundary — the region outside it prints as a blank white page. This means you can have a large worksheet with data in one corner and charts in another, and print only the data section with gridlines while leaving the charts for a separate export.

A technique that pairs naturally with gridlines is using VLOOKUP in Excel to consolidate data from multiple sheets onto one print-ready summary sheet. VLOOKUP lets you pull values from a lookup table on another worksheet directly into cells on your summary sheet, so the printed output contains exactly the data you need without requiring manual copy-paste each time. When your summary sheet has gridlines enabled, each VLOOKUP result appears in a clearly defined cell that is easy for readers to locate and reference. This combination of dynamic data population and clean grid printing is a cornerstone of automated reporting workflows.

Scaling is another advanced printing topic that interacts with gridlines in important ways. Excel's scaling options under Page Layout let you shrink a wide spreadsheet to fit on one page, or stretch a small dataset to fill a page more completely. When you scale down significantly — say to 50% of normal size — the gridlines scale with the content and become visibly thinner and closer together.

At very small scale factors, gridlines can become difficult to read. Consider whether your audience will be reading the printed sheet on screen (where zoom is available) or in a physical printout, and adjust your scale accordingly to keep gridlines legible.

Print titles are one of the most underutilized features in Excel's printing toolkit. Under Page Layout → Print Titles, you can designate rows or columns to repeat on every printed page. For a spreadsheet with gridlines enabled, having your column header row repeat at the top of every page means each sheet of a multi-page printout is self-contained and readable without reference to page one. Similarly, if your spreadsheet is very wide and spans multiple pages horizontally, repeating the leftmost column (which typically contains row labels) on every horizontal page makes the output dramatically easier to use.

Color printing versus black-and-white printing produces noticeably different results when gridlines are enabled. On a color printer, the default gray gridlines are soft and professional-looking, providing structure without dominating the page visually. On a black-and-white printer, the same gray gridlines may reproduce as a medium gray or a light gray depending on the printer's toner density settings. If your target audience will print on black-and-white printers, test your document on that device before finalizing it. You may find that manually applied medium-gray borders reproduce more consistently than the default gridlines across different printer models.

Another professional technique is combining gridlines with conditional formatting to create data-driven visual highlights within your printed grid. For example, you might apply a light yellow fill to cells that exceed a certain threshold, while leaving all other cells with no fill so that gridlines remain visible.

This creates a printed document where the grid structure is clear everywhere and the highlights draw attention to the important values — a much more effective communication tool than either gridlines alone or color fills alone. The key constraint to remember is that only the No Fill cells will show gridlines; the highlighted cells will show their fill color instead.

For organizations that print Excel reports on a regular cadence, it is worth creating a standardized print template workbook with all print settings — including gridlines, print area, page orientation, scaling, and headers/footers — already configured. New data can be pasted or linked into the template, and since all print settings are pre-configured, the user simply hits Ctrl+P and prints.

This eliminates the risk of someone forgetting to enable gridlines before a big meeting, and ensures every printed report from your team looks consistent and professional. Combine this template approach with the knowledge that Excel's print settings are saved with each worksheet, and you have a robust, repeatable printing workflow.

Practical printing tips extend well beyond just enabling gridlines — they encompass the entire preparation process that ensures your spreadsheet communicates clearly the moment it leaves the printer. One of the most impactful habits you can develop is always working in Page Layout view rather than Normal view when you are actively designing a worksheet you plan to print.

Page Layout view, accessible from the View tab, shows your data exactly as it will appear on printed pages, including page break lines, headers, footers, and the margins. You can see immediately whether your content fits within the page width or spills onto an additional page.

Page break management is closely tied to gridlines in terms of the visual quality of your printed output. When Excel automatically breaks a page in the middle of a data table, the resulting printout can be confusing — a table header might appear on one page while its data continues on the next.

You can manually control where page breaks occur by going to View → Page Break Preview, which shows your worksheet as a grid of pages. Drag the blue page break lines to reposition them wherever you want pages to end, ensuring each printed sheet contains a complete logical section of your data rather than an arbitrary slice.

Print scaling deserves special attention when you are working with wide datasets. Excel's Fit Sheet on One Page option under Page Layout → Scale to Fit is a popular choice, but it can make text and gridlines very small if your sheet is wide. A better approach for wide data is to choose Fit All Columns on One Page while leaving the row scaling set to Automatic. This ensures all your columns appear without horizontal truncation while allowing the content to span as many pages vertically as needed, with each page being full size and fully legible.

For spreadsheets that include both charts and data tables, consider separating them onto different sheets before printing. Charts and gridlined data tables have very different optimal print settings — charts look best on a full page without gridlines or headings, while data tables benefit from gridlines and sometimes column/row headings. By placing them on separate worksheets, you can give each element its own ideal print configuration without compromising either one. This also makes it easier to print only the charts, only the data, or both, depending on what your audience needs.

Keyboard shortcuts dramatically speed up the printing workflow once you know them. Ctrl+P opens the Print pane immediately from any view. Alt+P followed by S then P opens the Page Setup dialog. Ctrl+F2 is an alternative shortcut to reach Print Preview on some keyboard configurations. For power users who print Excel documents frequently, memorizing these shortcuts eliminates the ribbon navigation overhead and makes the printing workflow feel seamless and fast — especially important when you are preparing materials under time pressure before a meeting or deadline.

Finally, do not overlook the value of a print style guide for your organization. If multiple people are creating and printing Excel documents, a one-page style guide that specifies when to use gridlines versus manual borders, which page orientation to use for different report types, and what scaling rules to follow creates consistency across all printed output. Pair this with a shared template library and you create a self-reinforcing system where every spreadsheet that leaves your team looks professional, readable, and on-brand — with or without gridlines, depending on the context.

Building these habits around Excel printing — including mastering gridlines, understanding scaling, managing page breaks, and using print templates — pays compound dividends over time. Each individual tip saves a few minutes per print job, but collectively they eliminate reprints, reduce formatting errors, and ensure your spreadsheets make the right impression every time they appear on paper. Gridlines are the starting point, and this guide gives you everything you need to go from there to truly polished Excel printing output.