ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel gridlines disappear when color is added (https://www.excelbanter.com/excel-discussion-misc-queries/17600-excel-gridlines-disappear-when-color-added.html)

nelson1344

Excel gridlines disappear when color is added
 
When adding color to rows or columns in excel worksheets, the gridlines
disappear. How can I get the gridlines to print, even if the worksheets has
colored rows or columns?

Earl Kiosterud

Nelson,

Cell fill color, even white, paints right over the gridlines. You can use
borders (Format - Cells - Borders).
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"nelson1344" wrote in message
...
When adding color to rows or columns in excel worksheets, the gridlines
disappear. How can I get the gridlines to print, even if the worksheets
has
colored rows or columns?




Dave Peterson

Add borders to your worksheet
format|cells|borders tab
And don't print those gridlines.

(fill colors kill those gridlines--as you've seen)

nelson1344 wrote:

When adding color to rows or columns in excel worksheets, the gridlines
disappear. How can I get the gridlines to print, even if the worksheets has
colored rows or columns?


--

Dave Peterson


All times are GMT +1. The time now is 03:47 PM.

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