How do I create a tab stop w/ leaders?

G

Guest

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I create a table of contents with dot leaders? 3
How do I insert a dot leader or "tab leader" ? 1
How to call a COM add-in function from macro in Excel 2007 1
How do I stop a Excel 2007 file opening as read only? 1
How do I stop Excel from 'interpreting' my data? 7
How do I create a hyperlink in Excel on specific words in cells? 2
Dynamic link a cell to a worksheet tab 9
Leader Lines in Excel? 2

Top