I have lost the soft, blue borders of some cells.

  • Thread starter Thread starter Gerald
  • Start date Start date
G

Gerald

I have lost the border lines in a portion of one column in one of my
worksheets--66 adjacent rows (cells) in one column. I have done a--- office
button>excel options>advanced>display sheet>and tried there but to no avail.

I am using Vista with the latest Excel 2007 Home.
 
Perhaps you set the background color of those cells to white, which wipes
out the grid lines.

Select all and set to "automatic" or "no color".


Gord Dibben MS Excel MVP
 
To select the all the cells in the column, click the column's letter at the
top of the column (this will highlight all the cells in the column), then
locate the Font panel on the Home tab... there will be an icon with what
looks like a bucket pouring something out... click the small arrow to the
left of that icon and put a check mark in the "No Fill" checkbox on the
dialog that displays.
 
Thanks Rick, That took care of it, but I wish I knew how or why. "No Fill"
just doesn't seem to be the command that would add lines!
 
It doesn't "add lines". Somewhere along the line, you accidentally selected
those cells and filled them with (I'm assuming) a white color. Whenever you
fill a cell, the fill covers the gridlines (if you need lines around your
cells, you can put various combinations of borders around them)...
specifying "No Fill" removes the color thus revealing the lines it covered
up. You might be confused by the fact that your cells look to be white now,
but they aren't... they are just showing the "active Windows window
color"... if you change that in Windows display settings, your cells will be
that color instead.
 
I think I now understand....thank you so much.

Rick Rothstein said:
It doesn't "add lines". Somewhere along the line, you accidentally selected
those cells and filled them with (I'm assuming) a white color. Whenever you
fill a cell, the fill covers the gridlines (if you need lines around your
cells, you can put various combinations of borders around them)...
specifying "No Fill" removes the color thus revealing the lines it covered
up. You might be confused by the fact that your cells look to be white now,
but they aren't... they are just showing the "active Windows window
color"... if you change that in Windows display settings, your cells will be
that color instead.
Click to expand...
 
Back
Top