Is a transparent color fill possible?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan - 02 Sep 2006 21:16 GMT

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

Reply to this Message

Dave Peterson - 02 Sep 2006 21:46 GMT

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.

> 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

Signature

Dave Peterson

Reply to this Message

Alan - 03 Sep 2006 00:12 GMT

> 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.

>> 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

Reply to this Message

Gord Dibben - 02 Sep 2006 22:03 GMT

Alan

Transparent color not possible.

Use borders to restore the appearance of gridlines around cells that have
backgrounf color.

Gord Dibben MS Excel MVP

>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

Reply to this Message

Alan - 03 Sep 2006 00:13 GMT

> 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

Reply to this Message