How can I automatically fill the remainder of a cell with dots (..

G

Guest

I hope some one can help me.

I need to make a table and want to make sure that each cell with text is
automatically filled by dots/periods/points. The length of the text is
different in each cell, butthe width of the cell itself is the same.

As an example:

Net Sales...........................................
Depreciation.......................................

Please let me know if you can help!
 
G

Guest

Try custom formatting the range with: @*.
[Format > Cells > Custom > In "Type:" box: @*. ]
 

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

Top