One of my users has managed to change a spreadsheet so that the grid lines do not print. It has me stumped. Windows 8, Office 2013. The spreadsheet is locked. The “print gridlines” box is checked. My PC will print the gridlines on the same printer.
Does anyone have any ideas?
Thanks!
if you highlight a cell and then change the cell color to white using the “fill” icon, it will eliminate the visible grid line(s). you can undo it by selecting the problem cells and changing them to “no fill.”
I don’t think she can do that on a protected spreadsheet. The gridlines print on a copy of her sheet from my PC to the same network printer.
My best guess, based on your description, is that the other user changed the print options for that document on their computer (which, afaik, are part of excel’s settings, not document data). If you go into File > Print > Scaling > Custom Scaling Options > sheet (tab) there’s an option for print gridlines. Compare the setting on that computer (the one that doesn’t print the gridlines) with the setting on your computer.
There’s an option in the page layout tab (of the main ribbon in Excel) for print gridlines, but it sounds like you checked that, and that should be part of the document data.
By the way, that was a good idea to print a copy of her sheet from another PC.
Another IT guy updated her to Office 2013, and the problem no longer exists.
Dammit, I want to know what happened!