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

Making Color Fill Transparent in Excel 2003

1. Select the cells or rows/columns that you want to fill with color.
2. Right-click on the selection and choose "Format Cells" from the context menu.
3. In the "Format Cells" dialog box, go to the "Patterns" tab.
4. Under "Pattern," choose the color that you want to use for the fill.
5. Under "Pattern Style," choose "None."
6. Click on the "OK" button to apply the changes.

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.

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

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

"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

"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