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

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
buttonexcel optionsadvanceddisplay sheetand 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

On Mon, 13 Apr 2009 17:21:01 -0700, Gerald
wrote:

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
buttonexcel optionsadvanceddisplay sheetand tried there but to no avail.

I am using Vista with the latest Excel 2007 Home.

Please give me the path to where I "Select all and set to 'automatic' or 'no
color'."

"Gord Dibben" wrote:

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

On Mon, 13 Apr 2009 17:21:01 -0700, Gerald
wrote:

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
buttonexcel optionsadvanceddisplay sheetand tried there but to no avail.

I am using Vista with the latest Excel 2007 Home.

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.

--
Rick (MVP - Excel)


"Gerald" wrote in message
...
Please give me the path to where I "Select all and set to 'automatic' or
'no
color'."

"Gord Dibben" wrote:

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

On Mon, 13 Apr 2009 17:21:01 -0700, Gerald
wrote:

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
buttonexcel optionsadvanceddisplay sheetand tried there but to no
avail.

I am using Vista with the latest Excel 2007 Home.

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!

"Rick Rothstein" wrote:

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.

--
Rick (MVP - Excel)


"Gerald" wrote in message
...
Please give me the path to where I "Select all and set to 'automatic' or
'no
color'."

"Gord Dibben" wrote:

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

On Mon, 13 Apr 2009 17:21:01 -0700, Gerald
wrote:

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
buttonexcel optionsadvanceddisplay sheetand tried there but to no
avail.

I am using Vista with the latest Excel 2007 Home.

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.

--
Rick (MVP - Excel)


"Gerald" wrote in message
...
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!

"Rick Rothstein" wrote:

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.

--
Rick (MVP - Excel)


"Gerald" wrote in message
...
Please give me the path to where I "Select all and set to 'automatic'
or
'no
color'."

"Gord Dibben" wrote:

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

On Mon, 13 Apr 2009 17:21:01 -0700, Gerald
wrote:

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
buttonexcel optionsadvanceddisplay sheetand tried there but to no
avail.

I am using Vista with the latest Excel 2007 Home.

I think I now understand....thank you so much.

"Rick Rothstein" wrote:

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.

--
Rick (MVP - Excel)


"Gerald" wrote in message
...
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!

"Rick Rothstein" wrote:

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.

--
Rick (MVP - Excel)


"Gerald" wrote in message
...
Please give me the path to where I "Select all and set to 'automatic'
or
'no
color'."

"Gord Dibben" wrote:

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

On Mon, 13 Apr 2009 17:21:01 -0700, Gerald
wrote:

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
buttonexcel optionsadvanceddisplay sheetand tried there but to no
avail.

I am using Vista with the latest Excel 2007 Home.