Pop open the Drawing Toolbar from ViewToolbars.

Draw the line across the cell.

OR

FormatCellsNumberCustom

@*-

Enter a hyphen(dash) and you will see -------------- across the cell.


Gord Dibben MS Excel MVP

On Fri, 13 Oct 2006 08:14:01 -0700, CatBuddy
wrote:

I want to put a line at the bottom of a column of figures before the sum, but
I want it in the middle of the cell rather than at the border. This way,
when I'm looking at the S/S on my monitor, I won't confuse it with the
gridlines. I'm using Excel 2003