asked on

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.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

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,

Michael Fowler

Are you printing as draft quality this can remove gridlines

Michael

ASKER CERTIFIED SOLUTION

Nummmnut

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Nummmnut

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

mcsnetworks

ASKER

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.

mcsnetworks

ASKER

It ended up being that we needed to convert the 2003 workbook to 2007 format, after that it printed gridlines as expected.