![]() |
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? |
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? |
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