Why Excel Gridlines Disappear When Converting to PDF
Excel displays gridlines on screen by default, creating the familiar spreadsheet grid of light gray lines that separate cells. These on-screen gridlines help you visually organize data while working in Excel. When you export or print an Excel to PDF document, these default gridlines do not appear in the output. Only gridlines that you have explicitly enabled for printing are included in the PDF.
Enabling gridlines for print is a one-click setting that makes spreadsheet PDFs significantly easier to read.
A test print of a single page confirms all layout settings before exporting the entire workbook to PDF.
The distinction between screen gridlines and print gridlines is a deliberate design choice in Excel. Screen gridlines serve as a working aid during data entry and editing. Print gridlines serve as a visual organization tool in the final printed or PDF output. Many spreadsheet creators want the on-screen grid for editing convenience but prefer a clean output without gridlines cluttering the data presentation. Excel's default behavior respects this preference by not printing gridlines unless you specifically enable them.
The PDF Printing output from Excel reflects the print settings, not the screen display settings. Other visual elements that appear on screen but may not print include row and column headings, the formula bar, sheet tabs, and zero values hidden by display settings. Understanding which elements print and which do not prevents the frustration of discovering missing gridlines, headers, or data after the PDF has been created and shared.
How to Enable Gridlines When Exporting Excel to PDF
To include gridlines in your PDF output, enable the Print option for gridlines in Excel before exporting. Go to the Page Layout tab on the ribbon. In the Sheet Options group, find the Gridlines section.
Check the Print checkbox under Gridlines. This setting tells Excel to include the cell gridlines in printed and PDF output. The change takes effect immediately in Print Preview, where you can confirm the gridlines are visible..
The gridline color and style can be customized through Excel's options. Go to File, Options, Advanced, and scroll to the Display options for this worksheet section. The gridline color dropdown sets the color of both screen and print gridlines. The default is a light gray that is visible but not distracting. For PDFs that will be printed in black and white, consider using a slightly darker gray for better visibility on paper.
After enabling gridlines for print, preview the PDF output before exporting. Go to File, Print, and examine the print preview. Verify that gridlines appear around all cells that should have them. Check that gridlines do not make the data harder to read. Gridlines that are too dark or too thick can overwhelm the data they are meant to organize. The ideal gridline is just visible enough to separate cells without competing with the cell content for the reader's attention.
The PDF Export settings also control whether row and column headings, the numbered rows and lettered columns, appear in the output. In the same Sheet Options group on the Page Layout tab, the Print checkbox under Headings controls whether row numbers and column letters appear. These headings are useful for reference documents where readers need to identify specific cells by their coordinates. They are unnecessary and distracting for presentation documents where the data should stand on its own.
Setting Up the Excel Page Layout for Professional PDF Output
Before exporting, set the print area to include only the cells you want in the PDF. Select the data range, go to Page Layout, click Print Area, and select Set Print Area. Cells outside the print area are excluded from the PDF output. This is useful for spreadsheets that contain supporting calculations, reference data, or draft notes that should not appear in the shared PDF.
Adjust the page scaling to fit the data appropriately on the page. On the Page Layout tab, set Width to 1 page to force all columns onto a single page width. This prevents columns from being cut off at the right edge and continuing onto a separate page. For spreadsheets with many rows, leave Height set to Automatic so the rows flow across as many pages as needed. For small spreadsheets, set both Width and Height to 1 page to fit everything on a single page.
Configure repeating header rows so column labels appear at the top of every page. On the Page Layout tab, click Print Titles. In the Page Setup dialog, set Rows to repeat at top to the row or rows containing your column headers. This setting ensures that readers can identify what each column represents on every page of a multi-page PDF without flipping back to the first page.
WukongPDF's Excel to PDF converter processes Excel files directly and preserves the print settings, including gridlines, headers, and page layout. Upload the Excel file, and the converter produces a PDF that matches the print preview in Excel, with gridlines appearing if they were enabled for print.
Troubleshooting Common Excel to PDF Gridline Problems
If gridlines still do not appear after enabling the Print checkbox, check whether cell borders have been applied to the cells. Cell borders take visual precedence over gridlines.
If you have applied a white or no-color border to cells, the border overrides the gridline, and no line appears between those cells in the PDF. Remove cell borders or set them to match the gridline appearance to restore visible cell boundaries..
If the PDF output shows gridlines but the data is difficult to read, the gridline color may be too similar to the cell background or the text color. Change the gridline color to provide better contrast. For dark-mode Excel themes, the default gridline color may assume a dark background that does not print, leaving very light gridlines on a white page. Check the gridline visibility in Print Preview before exporting.
For very large spreadsheets that span many pages when printed, consider whether gridlines improve or harm readability. Dense data with gridlines on every cell can appear cluttered and be difficult to scan. Gridlines between every row and column are most useful for small to medium data tables. For large tables, consider using borders to highlight only the key structural lines, such as the header row bottom border and the totals row top border, while leaving the data rows gridline-free for a cleaner appearance.
When exporting an Excel workbook with multiple sheets to PDF, each sheet becomes a separate section in the PDF output. The gridline print setting must be enabled for each sheet individually. Check each sheet's Page Layout settings before exporting the entire workbook. A sheet with gridlines disabled will produce PDF pages without gridlines even if all other sheets in the same workbook have gridlines enabled.
For spreadsheets that will be printed and bound, consider adding page numbers to the PDF output. Excel can include page numbers in headers or footers through the Page Setup dialog. Go to Page Layout, click the dialog launcher in the Page Setup group, select the Header/Footer tab, and choose a predefined header or footer that includes page numbers. The page numbers appear on every page of the PDF output, helping readers keep printed pages in order.
When printing the PDF output of an Excel spreadsheet, the printer settings can override some of the PDF formatting. Ensure the printer is set to print at 100 percent scale rather than Fit to Page, which can shrink the content and make gridlines appear thinner and harder to see. A test print of a single page before printing the entire document confirms that gridlines, headers, and data all appear as expected.
For spreadsheets that will be shared with people who may need to extract the data later, consider providing both the PDF and the original Excel file. The PDF provides a formatted, print-ready version that displays consistently. The Excel file provides the raw data for further analysis. This dual-format approach serves both the presentation and data access needs of the recipients.
Excel allows you to set different print settings for each worksheet in a workbook. One sheet can have gridlines enabled for printing. Another sheet in the same workbook can have gridlines disabled. Check each sheet individually before exporting the entire workbook to PDF. The sheet tabs at the bottom of the Excel window show which sheet is active. Switch to each sheet and verify its Page Layout settings.
For spreadsheets with cells that have background fill colors, gridlines may be invisible against the colored background even when gridline printing is enabled. The gridline color defaults to a light gray that provides low contrast against colored cells. Consider using cell borders instead of gridlines for colored spreadsheets. Borders can be set to a darker color that provides sufficient contrast against any cell background.
The PDF format preserves the exact visual appearance of the exported spreadsheet, including fonts, colors, cell sizes, and gridlines. This preservation is both the strength and the limitation of the PDF format for spreadsheet data. The visual presentation is locked in and will display identically everywhere. The underlying data, however, is not directly accessible from the PDF without data extraction tools.
Sharing spreadsheet data as PDF protects the data integrity while still allowing recipients to view and verify the information. The recipient sees exactly the data you intended to share, formatted as you intended, with no ability to accidentally modify a formula or sort a column in a way that changes the data presentation.