ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I get the gridlines to print OVER colored cells? (https://www.excelbanter.com/new-users-excel/77871-how-do-i-get-gridlines-print-over-colored-cells.html)

JanetGU

How do I get the gridlines to print OVER colored cells?
 
Some rows in my spreadsheet are colored. When I try to print it, the color
is hiding the gridlines. I want the gridlines to show.

David McRitchie

How do I get the gridlines to print OVER colored cells?
 
Hi Janet,
You will have to use borders instead, because the cells with
interior color or borders will mask gridlines.
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

"JanetGU" wrote in message ...
Some rows in my spreadsheet are colored. When I try to print it, the color
is hiding the gridlines. I want the gridlines to show.





All times are GMT +1. The time now is 09:59 PM.

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