Gray Grid Lines disappear

G

Guest

When I clear a highlighted cell, the gray grid lines disappear. How do I get
them back? I am using Microsoft Office Professional 2003.
 
G

Gord Dibben

"Highlight" means background color or?

How are you clearing the cell?

Generally this is caused by the background color being set to white.


Gord Dibben MS Excel MVP
 
A

*alan*

I may be answering a question you haven't asked, as I'm not only unclear
what you mean by "highlighted" (filled with color?), but I'm also not sure
what "clearing" (I'm assuming you mean deleting data) would have to do with
the disappearing gridlines.

That having been said, I use Excel2003 and have noticed that those grey
gridlines do "disappear" when one color-fills the cells.

You can restore those gridlines (although they'll appear black, not grey) by
doing the following:

Select the affected cells (actually, you might as well select the entire
sheet)
Go to Format > Cells > Border
Click "Outside" and "Inside"
Click OK

Apologies if I've totally misunderstood your problem . . . .
 
G

Gord Dibben

alan

Just for info.

You can select a color for the borders at the borders dialog.


Gord Dibben MS Excel MVP
 
A

*alan*

Yes, I see that now ---- and options to change the line styles as well.
Thank you.

But --- oddly enough --- no matter what line style I chose and no matter
what color I chose, the result was always black and always standard line
style.

I'm puzzled. It sure LOOKS like I've got the ability to change line colors
and styles, but no matter whether I select portions of the sheet or the
entire sheet, it just didn't seem to work. What do you suppose I'm doing
wrong?
 
A

*alan*

I shouldn't have been so quick to hit the "Send" button on that one -----
just now figured it out.
I need to FIRST choose the color, THEN the line style, and THEN click
"Outline" and "Inside" borders . . . I knew there was some way it HAD to
work ...
 
R

Rich C

So far. All responses are unclear and/or wrong
Highlight the involved cells and right-click > delete > Shift cells left or Shift cells up will correct the problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retain grid after color fill? 1
Why do my gray lines disappear around labels on the screen? 2
HOW TO APPLY GRAY HIGHLIGHTING TO RANGE, BASED ON ENTRY IN ONE CELL 4
Show horizontal grid lines only in xl2003.. 1
how to control the gray line on the border? 4
Excel Grid Lines in Outlook Preview Pane 3
How to vary shading of groups of rows, based on change in value in aparticular column 9
How do you create a table with a shaded header in Word 2007 or 201 1

Top