When working on financial budgets, invoice registers, attendance sheets, or inventory lists in Microsoft Excel, faint grey gridlines delineate every row and column on your monitor, making large sets of data effortless to navigate. However, sending your spreadsheet to a physical office printer or exporting it as a PDF frequently results in an unexpected surprise: all cell borders vanish completely, leaving text and numbers floating awkwardly on a stark white blank page. By default, Excel suppresses gridlines during printing to avoid cluttering formal reports. If you want printed documents or exported PDF files to include clear cell outlines, you must instruct Excel to render gridlines on paper. Here is how to print gridlines in Microsoft Excel worksheets.
Why Does Excel Suppress Gridlines on Printouts?
Excel distinguishes between on-screen workspace guidelines and printed borders. The light grey gridlines you see while editing are designed solely as alignment aids for your computer monitor. When generating hard-copy printouts or client-facing presentations, Excel assumes users prefer to draw bespoke borders using the Border tool on specific headers and total rows. If you have not drawn manual cell borders and print using standard settings, the page prints without any boundary lines. Enabling the print gridlines setting ensures that the entire worksheet retains its crisp tabular structure on paper.
Method 1: Enable Print Gridlines via Page Layout Ribbon (Quickest Method)
The fastest way to ensure your current worksheet prints with gridlines is through the Excel ribbon toolbar:
- Open your spreadsheet in Microsoft Excel on your desktop.
- Click on the Page Layout tab in the top navigation ribbon.
- Locate the Sheet Options section near the centre-right of the ribbon.
- Under the Gridlines heading, you will see two checkboxes:
- View: Controls whether gridlines appear on your computer monitor (ticked by default).
- Print: Controls whether gridlines appear on printed paper and PDF documents (unticked by default).
- Tick the box beside Print.
Press Ctrl + P to open Print Preview. You will instantly see crisp gridlines separating every row and column across your document pages.
Method 2: Enable Gridlines via Page Setup Dialogue Box (Best for Multiple Sheets)
If you need deeper control over margins, headers, or wish to configure several worksheets simultaneously:
- Select the worksheets you wish to configure (hold
Ctrland click multiple sheet tabs along the bottom if needed). - On the Page Layout tab, click the tiny dialogue box launcher arrow in the bottom-right corner of the Page Setup group.
- In the Page Setup dialogue box, click on the Sheet tab at the top.
- Under the Print section, tick the checkbox labelled Gridlines.
- Optionally, choose Black and white if printing on a monochrome laser printer to prevent faint grey rendering.
- Click OK to save your settings, or click Print Preview to verify the output.
Comparison: Default Excel Printing vs Gridlines Enabled
| Output Format | Default Print Settings | Gridlines Enabled |
|---|---|---|
| Paper Printout | Floating text & numbers; no row lines | Crisp, clear boundary lines for every cell |
| PDF Export | Blank document background without borders | Full tabular borders matching screen view |
| Readability for Wide Data | Difficult to track figures across columns | Effortless visual tracking from left to right |
| Manual Border Effort | Requires manual cell selection and styling | One click applies to thousands of rows |
Troubleshooting: Gridlines Still Not Printing in Excel?
If you have enabled the Print Gridlines checkbox but your printout or PDF export still appears completely blank of lines, check these common causes:
- White Fill Colour Applied: If cells have an explicit white fill colour applied (rather than “No Fill”), Excel draws a solid white background that masks the gridlines. Highlight your data, click the Fill Colour (paint bucket) icon on the Home tab, and select No Fill.
- Draft Quality Print Setting: In the Page Setup Sheet tab, ensure that Draft quality is unticked. Draft mode often skips cosmetic lines to conserve printer ink.
- Empty Print Area: If you set a Print Area that excludes your data range, Excel will not render table lines. Clear your print area under Page Layout > Print Area > Clear Print Area.
Enabling gridlines ensures your printed reports, invoices, and audit sheets remain clean, legible, and professional in any meeting or binder.