'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Removing Borders at the End of a Printed Page
Question details
The user is experiencing an issue where Excel omits or removes the bottom cell border at the end of a printed page, despite the page layout and border settings being configured correctly.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Printing a spreadsheet containing applied cell borders.
- Observed behavior
- The bottom border of the last row on a printed page is missing or cut off in the final physical printout.
Before altering your spreadsheet layout, test printing the document to a PDF file to determine if the missing borders are caused by your physical printer driver margins or an underlying Excel software bug.
Adjust Custom Margins to Accommodate Borders
Borders situated at the very edge of the page can be pushed into the unprintable area by the printer. Adjusting the bottom margin often resolves this.
Every printer has a built-in unprintable margin at the edges of the paper. If Excel's borders fall exactly into this margin, they will be visually removed during the print job. Slightly increasing the margin forces the border into the printable zone.
Navigate to the 'Page Layout' tab on the Excel ribbon, click on 'Margins', and select 'Custom Margins' from the drop-down menu.
In the Page Setup dialog box, slightly increase the numerical value for the 'Bottom' margin (e.g., from 0.75 to 1.0 inches) to give the bottom border more room to print.
Press Ctrl + P to open the Print Preview screen and verify that the bottom border is now visible on the last printed page.
Modify the Print Area using Page Break Preview
Manually adjusting the page breaks ensures that the final row and its borders are not caught between pages, keeping them intact on the printed sheet.
Provide a Sanitized Test Workbook for Support Investigation
Because missing printed borders can sometimes be a persistent bug related to specific file corruption, sharing a sanitized test file helps technical support communities identify the exact cause.
Print Spreadsheets Flawlessly with WPS Office
If Microsoft Excel continues to truncate your printed borders due to persistent layout bugs, consider switching to WPS Office. It is a free, lightweight alternative offering highly accurate print rendering and seamless compatibility with your existing Excel spreadsheets.
- 1. Download and Install WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your computer.
- 2. Open Your Excel File: Launch WPS Spreadsheet and open your existing .xlsx file. The formatting and borders will be preserved perfectly.
- 3. Print Your Document: Go to Menu > Print. Review the document in the print preview to ensure all borders are visible, then click Print.
Frequently Asked Questions
Why do my cell borders look fine on the screen but disappear when I print them?
This discrepancy is usually caused by a mismatch between the software's screen rendering and the physical printer's unprintable margin limits. If a border sits perfectly on the printer's unprintable edge, Excel will show it on screen, but the printer will omit it.
Does saving the Excel file as a PDF fix the missing border issue?
Yes, in many cases. Using the 'Save as PDF' or 'Print to PDF' function generates a digital document that bypasses your physical printer drivers. You can then print the resulting PDF file, which often prints with all borders fully intact.
How do I ensure my spreadsheet prints exactly as it appears?
To prevent unexpected printing errors, always utilize the 'Page Break Preview' mode found under the View tab. This allows you to verify layout boundaries and ensure your content, including borders, is well within the printable margins before sending it to the printer.
