PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?VG9t?=
Guest
Posts: n/a
 
      22nd Aug 2007
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!
 
Reply With Quote
 
 
 
 
=?Utf-8?B?TWF4?=
Guest
Posts: n/a
 
      22nd Aug 2007
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!

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically fill cell value =?Utf-8?B?aW5nYWxsYQ==?= Microsoft Excel Worksheet Functions 1 28th Mar 2007 08:58 PM
How do I automatically fill a cell based on another cell in Excel =?Utf-8?B?U291dGhDYXJvbGluYQ==?= Microsoft Excel Misc 3 13th Jan 2006 12:52 AM
automatically fill in a cell if the adjacent cell has any value =?Utf-8?B?R2VvZ3JhcGhlcg==?= Microsoft Excel Programming 4 1st Jun 2005 03:40 PM
Re: Cell fill color automatically changes when you leave cell Frank Kabel Microsoft Excel Misc 1 11th Mar 2004 04:50 PM
automatically fill up a cell? polletje Microsoft Excel Programming 8 6th Jan 2004 11:15 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:58 PM.