ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Changed grid line color, now cell borders don't show (https://www.excelbanter.com/excel-discussion-misc-queries/106190-changed-grid-line-color-now-cell-borders-dont-show.html)

[email protected]

Changed grid line color, now cell borders don't show
 
I'm using Microsoft Excel 2003. I changed the grid line color to a
lighter shade of gray. Now the borders of cells (merged and unmerged)
no longer show up, regardless of what color I set them to. Is there a
an arcane workaround for this? Thanks.


Dave Peterson

Changed grid line color, now cell borders don't show
 
Did you fill the area with a background color--even white?

If yes, then instead of using the gridlines, maybe it's time to use Borders--or
remove the fill color.

wrote:

I'm using Microsoft Excel 2003. I changed the grid line color to a
lighter shade of gray. Now the borders of cells (merged and unmerged)
no longer show up, regardless of what color I set them to. Is there a
an arcane workaround for this? Thanks.


--

Dave Peterson

[email protected]

Changed grid line color, now cell borders don't show
 

Dave Peterson wrote:
Did you fill the area with a background color--even white?

If yes, then instead of using the gridlines, maybe it's time to use Borders--or
remove the fill color.


Actually, the problem is that the proper border options have to be
clicked *after* selecting the line width & color. So the preview of
the borders in the border customization window is very important.
Thanks anyway.

Fred

wrote:

I'm using Microsoft Excel 2003. I changed the grid line color to a
lighter shade of gray. Now the borders of cells (merged and unmerged)
no longer show up, regardless of what color I set them to. Is there a
an arcane workaround for this? Thanks.


--

Dave Peterson




All times are GMT +1. The time now is 02:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com