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

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!

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

Automatically fill the remainder of a cell with dots in Microsoft Excel:

1. Select the cell or cells that you want to format with dots.
2. Right-click on the selected cell(s) and choose "Format Cells" from the context menu.
3. In the "Format Cells" dialog box, select the "Alignment" tab.
4. In the "Horizontal" section, choose "Right" from the drop-down menu.
5. In the "Text control" section, check the box next to "Fill" and choose the character you want to use for the fill (in this case, a dot/period).
6. Click "OK" to apply the formatting.

Now, any text you enter in the selected cell(s) will be aligned to the right and the remainder of the cell will be filled with dots. If you need to adjust the width of the cell, simply drag the column boundary to the desired width.

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

Try custom formatting the range with: @*.
[Format Cells Custom In "Type:" box: @*. ]
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tom" wrote:
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!