How can I put a horizontal line in the middle of a cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
This might not be exactly what you want: highlite the cell you want, then go
into Format, then to Font, then check the Strikethrough box. Go to Print
Preview fom the File above, see what it looks like..

Me personally, I insert other cells and use the format cells button, then
border, then touch the cell centerline for the affect you are after. (I'll do
the row height change if need be forpositioning purposes)..just a thought,
hope this helped.

Champ
 
This might not be what you need, but here goes:

Highlite the cell that you want the line in, then go above to the Format
tab, then Cells, then into Font, then check the strikethrough box, then okay,
then print preview for the final look.

I usually just add-insert another row if needed, then right click on the
number of the row, then use the row height, change it small, then highlite
the two celss, above and below, and put a grid line in the middle of both of
them.

I hope that helped,

Champ
 
Pop open the Drawing Toolbar from View>Toolbars.

Draw the line across the cell.

OR

Format>Cells>Number>Custom

@*-

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


Gord Dibben MS Excel MVP
 
Back
Top