When working on financial budgets, inventory manifests, or project trackers in Microsoft Excel, the faint grey gridlines separating cells provide essential visual structure. However, many users are surprised to discover that when they send a worksheet to a physical printer or export it as a PDF document, those helpful cell boundaries disappear completely, leaving data floating across a blank white page. Excel suppresses gridlines during printing by default, but you can turn them on with a single checkbox.
Why Printed Gridlines Are Essential
Enabling gridlines for paper printouts and shared documents provides distinct advantages:
- Data Tracking Accuracy: Allows colleagues reviewing paper reports to scan across wide rows without misaligning figures into adjacent cells.
- Eliminates Manual Border Formatting: Saves time by removing the need to apply custom cell borders manually across thousands of rows.
- Pristine PDF Exports: Guarantees digital PDF distribution copies retain the clean tabular grid visible on your desktop monitor.
Method 1: Enable Printed Gridlines via the Page Layout Tab (Fastest)
The quickest way to activate gridlines for printing in modern Excel versions:
- Open your workbook in Microsoft Excel.
- Click on the Page Layout tab in the top ribbon menu.
- Locate the Sheet Options group.
- Under the Gridlines heading, you will observe two separate checkboxes: View and Print.
- Check the box beside Print.
The modification applies immediately to the active worksheet.
Method 2: Enable Printed Gridlines in Page Setup Dialogue
If you prefer adjusting margins, orientation, and scaling concurrently:
- On the Page Layout tab, click the small Page Setup dialogue launcher arrow in the bottom-right corner of the group.
- In the Page Setup dialogue box, click on the Sheet tab.
- Under the Print section, check the box labelled Gridlines.
- Click Print Preview at the bottom of the window to verify that cell boundaries appear clearly across all printed pages.
- Click OK to confirm.
Tip: If cell gridlines still do not appear in Print Preview, ensure your cells do not have a solid white fill colour applied, as background cell shading conceals underlying gridlines.
Enabling printed gridlines transforms plain sheets of paper into structured, easily interpretable reports suitable for executive distribution.