Henry,

Doing it that way won't work because I have to select what lines to format.
When I select the lines, it makes my entire document become one big grid.

-Doug

"Henry" wrote:

Doug,

To change the border format for ALL cells.
Click on the little square above the row numbers, on the same row as the
column names, to select the whole sheet's cells.
Now go to FormatCells and change the formatting of the borders to what you
want.
Click OK and then on any cell.
All your borders will be the same format.


Henry


"Doug" wrote in message
...
I have an Excel sheet that has bordered text all over the document. It's
kind of like a flow chart, in a way, so not all cells have the borders. I
want to change the color and line of the border throughout a selected
range,
but there doesn't seem to be an easy way to do this. I'd even just like
to
select the entire worksheet and change the border color throughout the
sheet
for all current border lines. Is there a way to do this? Currently the
only
way I'm seeing is to go into "Format Cells" and change each individual
border, which limits me when it's an entire worksheet.

Also, is there a way to set the default line and color of the border?