Printing Problems

Fix Missing Calendar Grid Lines When Printing in Excel

Olivia MillerOlivia Miller Nov 20, 2026 869 views

Question details

The user needs the horizontal and vertical lines around dates in an Excel calendar template to print correctly.

Fix Missing Calendar Grid Lines When Printing in Excel
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.
Before you start

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.

Solution 1Recommended

Test the printed calendar and correct its cell borders

Use this approach when calendar lines look incomplete or misplaced in print preview.

1
Print a test page

Open File > Print and print the calendar page. Check the paper copy, since print preview may not display every border accurately.

2
Inspect the date cells

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.

3
Apply the needed borders

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.

4
Check the print area

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.

Test the printed calendar and correct its cell borders
Merged cells: Calendar templates may use merged cells. Check their individual border edges if applying borders to the whole range does not produce the intended layout.
Free Microsoft Office alternative

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.

Adjust calendar cell borders before printingCompatible with Microsoft Excel formats such as XLSX and XLSFamiliar spreadsheet tools make migration easierFree and lightweight office suite
microsoft office alternative - wps office

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.