Is a transparent color fill possible?
When I fill a rows or columns with color, the gridlines running through them
disappear. Is there a way to make the fill "transparent" in order to see the gridlines? (I'm using Excel 2003). Thanks |
Answer: Is a transparent color fill possible?
Making Color Fill Transparent in Excel 2003
This will give you a transparent color fill that allows you to see the gridlines running through the cells. If you want to adjust the transparency level, you can use the "Transparency" slider under "Fill Effects" in the "Format Cells" dialog box. |
Is a transparent color fill possible?
I'd drop the Gridlines and use Borders (format|Cells|border tab) or use the
icons on the Formatting toolbar. You'll have much better control over how your workbook should look. Alan wrote: When I fill a rows or columns with color, the gridlines running through them disappear. Is there a way to make the fill "transparent" in order to see the gridlines? (I'm using Excel 2003). Thanks -- Dave Peterson |
Is a transparent color fill possible?
Alan
Transparent color not possible. Use borders to restore the appearance of gridlines around cells that have backgrounf color. Gord Dibben MS Excel MVP On Sat, 02 Sep 2006 20:16:38 GMT, "Alan" wrote: When I fill a rows or columns with color, the gridlines running through them disappear. Is there a way to make the fill "transparent" in order to see the gridlines? (I'm using Excel 2003). Thanks |
Is a transparent color fill possible?
"Dave Peterson" wrote I'd drop the Gridlines and use Borders (format|Cells|border tab) or use the icons on the Formatting toolbar. You'll have much better control over how your workbook should look. Thanks, Dave --- that works. Alan wrote: When I fill a rows or columns with color, the gridlines running through them disappear. Is there a way to make the fill "transparent" in order to see the gridlines? (I'm using Excel 2003). Thanks -- Dave Peterson |
Is a transparent color fill possible?
"Gord Dibben" wrote Transparent color not possible. Use borders to restore the appearance of gridlines around cells that have backgrounf color. Gord Dibben MS Excel MVP Thanks for the help ---- your suggestion works. "Alan" wrote: When I fill a rows or columns with color, the gridlines running through them disappear. Is there a way to make the fill "transparent" in order to see the gridlines? (I'm using Excel 2003). Thanks |
All times are GMT +1. The time now is 02:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com