Excel borders are there but not shown on print preview and won't be printed

Solution 1:

If you are using Microsoft Excel 2010+ (i.e. a version later than Office 2010), Navigate to the Layout tab. There are 4 sub-sections there namely: Page Setup, View, Print and Window.

Under the Print sub-section, check the Gridlines option.

That should do it.

Solution 2:

If you are playing with Page layout properties in VBA, then its possible that you turned the .Draft property under PageSetup to true.

The below line fixed the above problem for me. Changed the True to False With ActiveSheet.PageSetup.Draft = False

Hopefully, if someone happens to land upon this page with the same issue - then this simple fix may resolve the problem.

Thanks,
US

Solution 3:

I had the same problem with Excel 2010. If I printed directly from Excel the borders would not print. I had to save to pdf as a work-around. I tested every suggestion I found in the forums to no avail, then I tried disabling a recent Excel add-in that Adobe pushed out that allows you to save as Adobe pdf from the print menu in Excel. Once I disabled the add-in, the borders started printing again.