Forum Discussion

IronRod0's avatar
IronRod0
Copper Contributor
Mar 28, 2023

Excel not printing grid lines

I'm familiar with what is needed (or, at least, what used to be needed) to print grid the grid lines; I've done it before in previous versions.  (I'm increasingly unhappy with Office 2021 products.  ...
Excel
JKPieterse's avatar
JKPieterse
Silver Contributor
Mar 29, 2023
What grid line color do you have in File, Options, Advanced? And does it make a difference to select a different printer driver? Or maybe even add an existing printer as a new printer (so it gains its default settings)?
  • IronRod0's avatar
    IronRod0
    Copper Contributor
    Mar 31, 2023

    JKPieterse

    Thanks for pointing that one out. Been using Excel for many years and never noticed that -- maybe it is recently added? In any case, it was set to "Automatic" -- which one would assume would have it actually print grid lines if selected -- but I put it to "Black". Then I tried again. Still no grid lines in the print preview or in the printed output.

     

    Does this work for you? If you print a page with "Print gridines" enabled, do they print? In my case, the only thing that works is I have to add borders to all the cells. Those print fine. But that wasn't necessary before.  I know that, in earlier versions of Excel, just enabling "Gridlines" on the Page Setup > Sheet tab would cause them to appear in both Print Preview and in the printed output.

     

     

     

Resources