Fix Missing Calendar Grid Lines When Printing in Excel
Question details
The user needs the horizontal and vertical lines around dates in an Excel calendar template to print correctly.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Printing a calendar created from an Excel template.
- Observed behavior
- Some calendar lines appear missing or extend above the dates in print preview.
Open the calendar worksheet and identify the date range that should have borders. Check whether the lines are applied cell borders or worksheet gridlines, since they use different print settings.
Test the printed calendar and correct its cell borders
Use this approach when calendar lines look incomplete or misplaced in print preview.
Open File > Print and print the calendar page. Check the paper copy, since print preview may not display every border accurately.
If lines are still missing or misplaced on paper, select the calendar date range and open Home > Borders > More Borders. Check the outline and inside borders and remove any unwanted border segments.
With the calendar range selected, use Home > Borders to apply the required outside and inside borders. For individual cells, use More Borders to adjust specific edges.
Select the full calendar range, then choose Page Layout > Print Area > Set Print Area. Open File > Print to review the result and print another test page.

Enable printing for worksheet gridlines
Use this option if the desired lines are Excel worksheet gridlines rather than manually applied cell borders.
Edit and Print Calendar Workbooks with WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks, adjust calendar borders, and prepare them for printing as you move your workflow to WPS.

Frequently Asked Questions
Why do calendar borders appear missing in Excel print preview?
Print preview may not display every template border accurately. Print a test page from File > Print to check whether the lines are actually missing on paper.
How do I add lines around each calendar date?
Select the date cells and use Home > Borders to apply inside and outside borders. Use More Borders to adjust individual edges where needed.
How do I print Excel gridlines?
Go to Page Layout > Sheet Options > Gridlines and select Print. If you need precise lines around particular cells, apply cell borders instead.
How can I make sure the whole calendar is included in the printout?
Select the complete calendar range and choose Page Layout > Print Area > Set Print Area. Then open File > Print to check the page layout.




