Mar 28 2023 12:36 PM
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. Maybe it is time to go back to 2013.)
Settings:
But the lines to not appear in Print Preview (they used to) nor do they appear in the printed output. The only way I've been able to print a grid is to actually add the borders in the sheet before printing.
Anyone found a way to get this to work in Excel 2021?
Mar 29 2023 12:37 AM
Mar 31 2023 04:11 PM
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.