Feb 05 2019 09:38 AM
I am doing a spread sheet and I have "Grid Lines" turned on. When I go to the print screen a few are missing. I have tried copying a group of cells that HAVE grid lines on the print page and I copy them in a different area. Again I go to just look on the print page and again some will be missing. Grrrrrr, Please help!!! i need to get this printed :(
Feb 05 2019 10:48 AM
Show Grid Lines only applies to the worksheet view on the screen. It sounds like you are missing borders on cells that are not showing lines when printed.
Feb 05 2019 10:57 AM
Thank you Rusty. How to I change the cell borders?
Feb 05 2019 11:17 AM
Select your cells, right click, format cells. Under Line Style, select the type of lines you want (typically the small dots to provide a fine line on the printout), then place on the Border box.
You can also select the cells & click the borders icon in the Font group on the Home tab.
After adding the borders, just do a print preview & adjust as necessary.
Apr 04 2020 11:40 AM
The borders not being on the print preview happened to me but I printed the document anyway and the lines all printed. @tomanypups1