Tags: borders, cell, color, disappear, excel, fill, gridlines, microsoft, msdn, realize, software, somewhat

Gridlines disappear when I use color fill

On Microsoft » Microsoft Excel

4,306 words with 6 Comments; publish: Thu, 22 May 2008 07:35:00 GMT; (306281.25, « »)

When I color fill a cell, the gridlines disappear. I realize that I can use

borders, but they are much bolder than the gridlines, and somewhat

distracting. Is there any way to get the gridlines to show through the color

fill. Thanks for your help.

All Comments

Leave a comment...

  • 6 Comments
    • You can format the color and line thickness of the borders. Format >

      Cells...

      - Jon

      --

      Jon Peltier, Microsoft Excel MVP

      Tutorials and Custom Solutions

      http://PeltierTech.com

      _______

      "Lynninstitches" <Lynninstitches.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:AF72F58F-7CD4-4A20-A70A-C87D94BB6CF7.excel.todaysummary.com.microsoft.com...

      > When I color fill a cell, the gridlines disappear. I realize that I can

      > use

      > borders, but they are much bolder than the gridlines, and somewhat

      > distracting. Is there any way to get the gridlines to show through the

      > color

      > fill. Thanks for your help.

      #1; Thu, 22 May 2008 07:36:00 GMT
    • Lynninstitches wrote:

      > When I color fill a cell, the gridlines disappear. I realize that I can use

      > borders, but they are much bolder than the gridlines, and somewhat

      > distracting. Is there any way to get the gridlines to show through the color

      > fill. Thanks for your help.

      Nope, just change the border color, to Grey 25% for instance.

      #2; Thu, 22 May 2008 07:37:00 GMT
    • Thanks for your help! I don't remember this happening in older versions - is

      this a new feature in 2003?

      "Bob I" wrote:

      > Lynninstitches wrote:

      > > When I color fill a cell, the gridlines disappear. I realize that I can use

      > > borders, but they are much bolder than the gridlines, and somewhat

      > > distracting. Is there any way to get the gridlines to show through the color

      > > fill. Thanks for your help.

      > Nope, just change the border color, to Grey 25% for instance.

      >

      #3; Thu, 22 May 2008 07:38:00 GMT
    • No it is not new

      Regards,

      Peo Sjoblom

      "Lynninstitches" <Lynninstitches.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:343AC894-BEA8-4105-A9DA-B87AA6C31489.excel.todaysummary.com.microsoft.com...

      > Thanks for your help! I don't remember this happening in older versions -

      > is

      > this a new feature in 2003?

      > "Bob I" wrote:

      >> Lynninstitches wrote:

      >> > When I color fill a cell, the gridlines disappear. I realize that I

      >> > can use

      >> > borders, but they are much bolder than the gridlines, and somewhat

      >> > distracting. Is there any way to get the gridlines to show through the

      >> > color

      >> > fill. Thanks for your help.

      >> Nope, just change the border color, to Grey 25% for instance.

      >>

      #4; Thu, 22 May 2008 07:39:00 GMT
    • You're welcome, I don't remember, but Peo says no it's not new.

      Lynninstitches wrote:

      > Thanks for your help! I don't remember this happening in older versions - is

      > this a new feature in 2003?

      > "Bob I" wrote:

      >

      >>Lynninstitches wrote:

      >>

      >>When I color fill a cell, the gridlines disappear. I realize that I can use

      >>borders, but they are much bolder than the gridlines, and somewhat

      >>distracting. Is there any way to get the gridlines to show through the color

      >>fill. Thanks for your help.

      >>Nope, just change the border color, to Grey 25% for instance.

      >>

      #5; Thu, 22 May 2008 07:40:00 GMT
    • Lynn,

      As others have pointed out, it's not a new feature -- it's an old feature. Also, if you

      change the fill color to white (as opposed to no fill), it still paints over the gridlines,

      white in this case. That really makes people crazy.

      --

      Earl Kiosterud

      www.smokeylake.com

      Note: Some folks prefer bottom-posting.

      But if you bottom-post to a reply that's

      already top-posted, the thread gets messy.

      When in Rome...

      ----

      "Lynninstitches" <Lynninstitches.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:AF72F58F-7CD4-4A20-A70A-C87D94BB6CF7.excel.todaysummary.com.microsoft.com...

      > When I color fill a cell, the gridlines disappear. I realize that I can use

      > borders, but they are much bolder than the gridlines, and somewhat

      > distracting. Is there any way to get the gridlines to show through the color

      > fill. Thanks for your help.

      #6; Thu, 22 May 2008 07:41:00 GMT