Excel Gridlines Printing

Posted on 2014-07-16
Last Modified: 2014-09-30
I have a user that needs to print the grid lines on an Excel 2013 spreadsheet. The lines do actually print but they print as a series of dots rather than a solid black line. We need to change this to be the solid black line setup. Where would I make this change in Excel 2013?
Question by:bturnerpcg
    1 Comment
    LVL 37

    Accepted Solution

    I suspect the problem is that the lines are very thin (1 pixel) and they are not black but grey. To print grey, a printer has to mix black (a dot on the page) with white (no dot). This can produce the problem you have. There may be a setting in the printer driver that tells it to print black and white only (no grey). In that case the lines will print as either black or white, depending on how dark the grey is. Not many printers have that setting though.

    Alternatively you can tell Excel to print borders to the cells, in which case you can specify the line thickness as well as the colour. In your case I would suggest the thinnest line, and solid black.

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now