Fix Excel Cell Borders That Appear in Preview but Do Not Print
Question details
The user needs to print an Excel worksheet with cell borders that are visible in Print Preview but missing from the physical printout.
- Product
- Microsoft Excel desktop
- Device & OS
- not provided
- Scenario
- The workbook is being printed from a computer or laptop, and the user wants the worksheet borders to appear on paper as they do in Print Preview.
- Observed behavior
- Cell borders appear correctly in Excel Print Preview but are absent from the printed page, potentially because of printer quality settings, scaling, page setup, driver issues, or computer-specific configuration.
Print a small test page with the same worksheet and note the printer model, Excel version, paper size, and selected print quality. Also print another document containing borders to determine whether the issue affects Excel only or the printer generally.
Check printer quality, Excel page setup, and scaling
Use this solution when borders are visible in Print Preview but disappear on paper from a specific printer or computer.
Print Preview confirms the worksheet layout, but the printer driver and printer preferences control how that layout is rendered on paper. Draft or Quick Print modes, incorrect paper settings, and aggressive scaling can make thin borders difficult to print or omit them entirely.
Open Windows Settings or Control Panel, select Printers & scanners, choose the printer, open Printing preferences, and turn off Draft Quality, Quick Print, or any economy printing option.
In Excel, open the Page Layout tab and check Size, Orientation, and Margins. Select the paper size loaded in the printer and use margins that leave enough printable area.
In Excel, open Page Layout, select the Page Setup dialog launcher, open the Page tab, and check Scaling. Try Fit to 1 page wide or set Adjust to 100% before printing another test page.
Open the Page Layout tab, select Print Area, and choose Clear Print Area if the worksheet uses an incorrect range. Then use File > Print to confirm the intended worksheet and page range are selected.
Use File > Print, select the correct printer, and print one page. If the borders remain missing, open the printer's Printing preferences from the print dialog and review border, scaling, paper, and document-formatting options.
Update the printer driver and compare devices
Use this solution when the same workbook prints correctly on another printer or computer, indicating a local driver or system configuration problem.
Print bordered worksheets accurately with WPS Spreadsheet
WPS Spreadsheet lets you review page layout, set paper size and scaling, adjust margins, and print a bordered worksheet from one familiar interface. It can also open and print Microsoft Excel workbooks while you troubleshoot printer-specific settings.
- 1. Open the workbook in WPS Spreadsheet: Launch WPS Office, choose Spreadsheet, and open the Excel XLS or XLSX workbook containing the borders.
- 2. Review page layout: Open the Page Layout tab and set the correct paper size, orientation, margins, and print area for the loaded paper.
- 3. Adjust scaling and borders: Use the Page Setup or scaling controls to choose 100% or Fit to Page, then select the cells and confirm their border style and line color are visible.
- 4. Preview the worksheet: Select Menu > Print or the Print Preview command and inspect every page for visible borders before sending the job to the printer.
- 5. Print a test page: Choose the target printer, open its printer preferences to disable Draft or Quick Print, and print one test page.
Frequently Asked Questions
Why do Excel borders show in Print Preview but not on paper?
Print Preview reflects the worksheet layout, while the printer driver and printer preferences control the physical output. Draft or Quick Print mode, incorrect paper settings, scaling, outdated drivers, or very light borders can cause borders to disappear.
Which Excel settings should I check before printing borders?
Open Page Layout and verify Size, Orientation, Margins, and Print Area. Open the Page Setup dialog and review Scaling, then use File > Print to confirm the correct worksheet, printer, and page range.
Can changing printer quality restore missing cell borders?
Yes. Open the printer's Printing preferences from Windows Settings, Control Panel, or the Excel print dialog and disable Draft Quality, Quick Print, or economy modes. If available, select a normal or higher-quality print mode.
How can I tell whether the printer or Excel file is causing the issue?
Print another Excel workbook with borders, print the same file to a different printer or Microsoft Print to PDF, and test the workbook on another computer. Results that vary by printer or computer usually indicate a driver or local configuration issue.
What should I do if the problem affects only one computer?
Install pending Windows and Office updates, download the latest printer driver from the manufacturer's website, and reinstall or refresh the printer. Then recheck paper size, scaling, and printer preferences in Excel.
