• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1601
  • Last Modified:

Excel 2010 Won't Print Gridlines

I have a Excel 2010 workbook that will not print gridlines. Under page layout the print gridlines box is checked, both on the ribbon, and in Page Setup > Sheet. It may be possible that the printer is the issue as if I print to the network printer it works correctly, but if I print to my hp laserjet 4050.
0
mcsnetworks
Asked:
mcsnetworks
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

If it prints fine on another printer, then it's not the workbook that's the problem. Try to update the printer driver for the printer that does not show the grid lines.

cheers,
0
 
Michael FowlerSolutions ConsultantCommented:
Are you printing as draft quality this can remove gridlines

Michael
0
 
NummmnutCommented:
I have ran across this issue directly when migrating a worksheet from 2003 excel to 2010 and the problem is suppose to stem from Excel 2010 incompatibility with older printers.

However, I have gotten around this problem by modifying my macro code to shrink the page slightly.

(in my case)
ActiveSheet.PageSetup.Zoom = 65
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
NummmnutCommented:
Also this helped as well... I commented out the areas I didn't need

'TEST to fix borders in Excel 2010
 With ActiveSheet.PageSetup
        '.LeftHeader = ""
        '.CenterHeader = ""
        '.RightHeaderPicture.Filename = pLogoFileName
        '.RightHeader = "&G"
        '.CenterHeader = ""
        '.LeftFooter = strCentreFooter
        '.CenterFooter = ""
        '.RightFooter = pRightFooter
        '.LeftMargin = Application.CentimetersToPoints(0.25)
        '.RightMargin = Application.CentimetersToPoints(0.25)
        '.TopMargin = Application.CentimetersToPoints(0.25)
        '.BottomMargin = Application.CentimetersToPoints(0.25)
        '.HeaderMargin = Application.CentimetersToPoints(0.25)
        '.FooterMargin = Application.CentimetersToPoints(0.25)
        .PrintHeadings = False
        .PrintGridlines = False
        .PrintComments = xlPrintNoComments
        .PrintQuality = 300
        .CenterHorizontally = True
        .CenterVertically = True
        .Orientation = IIf(pPageOrient = "L", xlLandscape, xlPortrait)
        .Draft = False
        .PaperSize = xlPaperA4
        .FirstPageNumber = xlAutomatic
        .Order = xlDownThenOver
        .BlackAndWhite = False
        .Zoom = 100
        '.PrintErrors = xlPrintErrorsDisplayed
      End With
      'Application.PrintCommunication = True

Open in new window

0
 
mcsnetworksAuthor Commented:
The settings in Excel are all correct for the printing of gridlines, I am attempting the driver reinstall to see if that makes any difference. I will update once I have more information.
0
 
mcsnetworksAuthor Commented:
It ended up being that we needed to convert the 2003 workbook to 2007 format, after that it printed gridlines as expected.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now