Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Excel 2010 Won't Print Gridlines

Posted on 2011-09-29
6
Medium Priority
?
1,563 Views
Last Modified: 2012-05-12
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
Comment
Question by:mcsnetworks
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 50
ID: 36818556
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
 
LVL 23

Expert Comment

by:Michael Fowler
ID: 36818569
Are you printing as draft quality this can remove gridlines

Michael
0
 
LVL 6

Accepted Solution

by:
Nummmnut earned 1000 total points
ID: 36818986
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 6

Expert Comment

by:Nummmnut
ID: 36819015
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
 

Author Comment

by:mcsnetworks
ID: 36919305
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
 

Author Closing Comment

by:mcsnetworks
ID: 36919525
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

Industry Leaders: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question