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.