Excel gridlines disappear when color is added

nelson1344 · 03-14-2005, 09:06 PM

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 · 03-14-2005, 09:06 PM

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

Earl Kiosterud · 03-14-2005, 09:06 PM

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" <[email protected]> wrote in message
news:[email protected]...
> 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?

**OfficeCat** · 10-24-2018, 01:02 PM

When formatting the borders of the cells to allow the gridlines to appear even when the cells are color-filled, do I have to format each cell border individually?! ...because when I highlight the bunch of cells that I want to format it just puts the border around the entire thing not each cell! I think it's nuts that Excel does not have an easy command option that allows the gridlines to show/unshow when the cells are colored in! This is an old thread so maybe that option is there now I just don't know it... (?) *crosses fingers*

Thanks for any help!

**FDibbins** · 10-25-2018, 02:26 AM

OfficeCat, welcome to the forum

Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

(There are options for putting borders on different areas of a range or cell)