How do I create a tab stop w/ leaders?

[Carter Devereaux]

Does anyone know if it's possible to create tab stops w/ leaders (i.e., those
leading dots) in a cell? In Word, it's easily done, of course; but I wonder
if Excel allows that.

Thanks,
Carter

 

[Frank Kabel]

Hi
Excel does not support this as Word does. Yiu have to do it manually

--
Regards
Frank Kabel
Frankfurt, Germany

im Newsbeitrag
news:[email protected]...

 

[Gord Dibben]

Carter

Not sure if this is what you want but....

Format>Cells>Custom @*.

Which enters ........ after any text in a cell to fill out the cell.

Or macro

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


Gord Dibben Excel MVP