Guides

Why are gridlines missing from my Excel PDF?

Check printed gridlines, cell fills and borders before exporting again. Includes a four-row checklist example and a saved-PDF review.

If your Excel PDF has numbers but no cell lines, check the workbook before editing the PDF. Gridlines visible while you work are not automatically included in printed output. Enable printed gridlines in desktop Excel, or add explicit cell borders when you need lines around selected cells. Then export again and inspect the saved PDF.

Which kind of line is missing?

What you seeWhat to check
Lines on the worksheet, none in the PDFThe gridline print setting, not just the screen view.
Lines disappear inside colored cellsCell fill can hide gridlines; use borders if the fill must stay.
Only a few cells need outlinesApply borders to that range rather than printing a whole sheet of gridlines.
Lines exist but the entire table is tinyFix page scaling before judging line visibility.

Turn on printed gridlines in desktop Excel

  1. Select the worksheet that needs lines.
  2. Open Page Layout. Under Sheet Options → Gridlines, select Print. The View setting controls the worksheet display separately.
  3. Open File → Print and inspect the preview.
  4. Save or export a new PDF using your usual PDF workflow, then open that saved file. Check the output itself before sending it.

Microsoft documents these controls in Print gridlines in a worksheet. If preview still lacks lines, check that Draft quality is off in Page Setup. Gridlines around empty cells may require a print area that includes those cells.

Use borders for filled cells or Excel for the web

A white fill is still a fill: changing a cell from another color to white does not restore its gridlines. If you want to retain shading and visible divisions, apply cell borders. Microsoft explains this in Show or hide gridlines on a worksheet.

Excel for the web does not support printing worksheet gridlines. Select the intended range and use Home → Borders → All Borders as an alternative, then inspect print preview. Borders become workbook formatting, so save a separate copy if the original design needs to stay intact.

A four-row equipment checklist example

Suppose a hypothetical checklist has four equipment rows and an empty “Checked” column. The headings have a blue fill. You want recipients to mark the empty cells on paper.

  1. Select the complete checklist, including the empty response cells.
  2. Apply borders to that range, keeping the shaded headings.
  3. Preview the page and confirm the empty response boxes have outlines.
  4. Open the exported PDF and check all four rows, the heading line and the rightmost edge.

This checks the actual handoff: visible boxes for handwritten answers, rather than whether Excel displayed a grid while you worked. If the checklist shrinks too much, use our Excel PDF scaling guide. If additional pages appear, check print areas and extra blank pages before deleting anything.

Review the PDF before sharing

Look at the saved PDF at a readable zoom and preview a paper copy if it will be printed. Check that borders do not obscure small text and that columns are not clipped. Different export and print paths can produce different results; a setting alone is not proof of the final appearance.

For a final page review, open the PDF in AlphaPDF’s editor. Make gridline and border corrections in the source workbook, export again, and review the new copy before assembling or sharing your packet.

Comments

Comments are reviewed before appearing here. Your email is never displayed.

No approved comments yet.

Join the conversation

ALPHAPDF PRO

Explore paid tools

AlphaPDF Pro: $99/year · $12/month

An account and payment are required for PDF-to-JPG, all other converters and Premium tools. No free Premium jobs.

Compare free and paid access

Plan purchasing is not available here yet. Review supported inputs and limits before choosing a tool.

View pricing

Privacy choices

The device allowance is essential and cannot be disabled without deleting your AlphaPDF data. Optional uses are controlled separately.

Are you sure?