ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   missing cell lines (https://www.excelbanter.com/setting-up-configuration-excel/66255-missing-cell-lines.html)

CVDave

missing cell lines
 
When using Excel 2000, sometimes the cell gridlines do not show in print
preview or print even though they are visible on the worksheet. If I add a
gridline of a style different than the selected type, the newly added
gridline is visible and does print.



David McRitchie

missing cell lines
 
Hi Dave,
If by sometimes, I would presume you have the draft option turn on, on your printer.
If by sometimes, you mean some cells, then you probably have a cell that is shaded
with a background color -- even if white it will override gridlines, and you would either
correct the situation or use borders.

Gridlines and borders
http://www.mvps.org/dmcritchie/excel/gridline.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"CVDave" wrote in message ...
When using Excel 2000, sometimes the cell gridlines do not show in print
preview or print even though they are visible on the worksheet. If I add a
gridline of a style different than the selected type, the newly added
gridline is visible and does print.






All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com