View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Champ Champ is offline
external usenet poster
 
Posts: 37
Default How can I put a horizontal line in the middle of a cell?

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

"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