Leader Lines in Excel?

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Does anyone know if it is possible to create Leader Lines
in an Excel worksheet, like the way you can in Word
(using Tab Stops)??

Thanks.
 
It depends what you're trying to do, but some variation on the following
may help:

1. Enter a value in A2, and the other value in C2.
2. In cell B2, type the character you want as the leader, e.g. a period.
3. With B2 selected, choose Format>Cells.
4. On the Alignment tab, under Horizontal, choose Fill
5. Click OK
 
Steve

Assign this macro to a button. Change the dot to whatever you like.

Sub Leaders()
Selection.numberformat = "@*."
End Sub

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Back
Top