Tags: back, cathy, cell, clear, disappear, excel, gray, grid, highlighted, lines, microsoft, msdn, office, professional, software

Gray Grid Lines disappear

On Microsoft » Microsoft Excel

5,122 words with 6 Comments; publish: Thu, 22 May 2008 04:01:00 GMT; (30692.77, « »)

When I clear a highlighted cell, the gray grid lines disappear. How do I get

them back? I am using Microsoft Office Professional 2003.

--

Cathy Hillery

All Comments

Leave a comment...

  • 6 Comments
    • "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

      On Thu, 5 Jul 2007 10:10:00 -0700, Cathy Hillery

      <CathyHillery.excel.todaysummary.com.discussions.microsoft.com> wrote:

      >When I clear a highlighted cell, the gray grid lines disappear. How do I get

      >them back? I am using Microsoft Office Professional 2003.

      #1; Thu, 22 May 2008 04:03:00 GMT
    • 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 . . . .

      --

      Alan

      "Cathy Hillery" <CathyHillery.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:4FE42E42-26B9-4B73-8E9E-22EA5707DF5C.excel.todaysummary.com.microsoft.com...

      > When I clear a highlighted cell, the gray grid lines disappear. How do I

      > get

      > them back? I am using Microsoft Office Professional 2003.

      > --

      > Cathy Hillery

      #2; Thu, 22 May 2008 04:04:00 GMT
    • alan

      Just for info.

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

      Gord Dibben MS Excel MVP

      On Thu, 5 Jul 2007 16:48:57 -0700, "*alan*" <in_flagrante.excel.todaysummary.com.hotmail.com> wrote:

      >You can restore those gridlines (although they'll appear black, not grey) by

      >doing the following:

      #3; Thu, 22 May 2008 04:05:00 GMT
    • 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?

      --

      Alan

      "Gord Dibben" <gorddibbATshawDOTca> wrote in message

      news:jm5r831etb5b2hm1i0olm19jlahgj6jid0.excel.todaysummary.com.4ax.com...

      > alan

      > Just for info.

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

      >

      > Gord Dibben MS Excel MVP

      > On Thu, 5 Jul 2007 16:48:57 -0700, "*alan*" <in_flagrante.excel.todaysummary.com.hotmail.com>

      > wrote:

      >>You can restore those gridlines (although they'll appear black, not grey)

      >>by

      >>doing the following:

      >

      #4; Thu, 22 May 2008 04:06:00 GMT
    • 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 ...

      --

      Alan

      "*alan*" <in_flagrante.excel.todaysummary.com.hotmail.com> wrote in message

      news:Plhji.37806$Um6.16469.excel.todaysummary.com.newssvr12.news.prodigy.net...

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

      > --

      > Alan

      >

      > "Gord Dibben" <gorddibbATshawDOTca> wrote in message

      > news:jm5r831etb5b2hm1i0olm19jlahgj6jid0.excel.todaysummary.com.4ax.com...

      >> alan

      >> Just for info.

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

      >>

      >> Gord Dibben MS Excel MVP

      >> On Thu, 5 Jul 2007 16:48:57 -0700, "*alan*" <in_flagrante.excel.todaysummary.com.hotmail.com>

      >> wrote:

      >>You can restore those gridlines (although they'll appear black, not grey)

      >>by

      >>doing the following:

      >

      #5; Thu, 22 May 2008 04:07:00 GMT
    • Thanks for the update.

      The things you find out by experiment<g>

      Gord

      On Fri, 06 Jul 2007 02:04:26 GMT, "*alan*" <in_flagrante.excel.todaysummary.com.hotmail.com> wrote:

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

      #6; Thu, 22 May 2008 04:08:00 GMT