Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 22nd 07, 10:14 AM posted to microsoft.public.excel.misc
Tom Tom is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 5
Default 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!

  #2   Report Post  
Old August 22nd 07, 11:10 AM posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,221
Default 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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically fill cell value ingalla Excel Worksheet Functions 1 March 28th 07 08:58 PM
Automatically fill blank cell by same as just above record [email protected] Excel Discussion (Misc queries) 2 March 3rd 07 06:24 PM
set up a formula to automatically fill down from previous cell audif New Users to Excel 4 January 15th 07 08:26 PM
How do I automatically fill a cell based on another cell in Excel SouthCarolina Excel Discussion (Misc queries) 3 January 13th 06 01:52 AM
Automatically fill one cell in any newly inserted row spoko Excel Discussion (Misc queries) 1 November 11th 05 07:45 PM


All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017