Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to make ........ even after a title in a cell?
I am creating a table and want to put ................ to the end of the cell
and want it to be even in viewing and printing. i.e.: [see below...I copied from the cells] Task Hours Criteria Design Compliance¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦.. VE Review¦¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦¦¦¦ GMP/Bid Review¦¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦. Contract Negotiations¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦ Any help is greatly appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to make ........ even after a title in a cell?
Format cell, number tab, custom:
@*. This will to column width. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Penny_in_FL" wrote: I am creating a table and want to put ................ to the end of the cell and want it to be even in viewing and printing. i.e.: [see below...I copied from the cells] Task Hours Criteria Design Compliance¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦.. VE Review¦¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦¦¦¦ GMP/Bid Review¦¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦. Contract Negotiations¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦ Any help is greatly appreciated! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to make ........ even after a title in a cell?
Play with these:
="Apple"&REPT(".",100) ="Apple"&REPT(".",100-LEN("Apple")) best wishes -- Bernard Liengme MVP Excel http://people.stfx.ca/bliengme "Penny_in_FL" wrote in message ... I am creating a table and want to put ................ to the end of the cell and want it to be even in viewing and printing. i.e.: [see below...I copied from the cells] Task Hours Criteria Design Compliance¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦.. VE Review¦¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦¦¦¦ GMP/Bid Review¦¦¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦. Contract Negotiations¦¦¦¦¦¦¦¦¦¦¦¦ ¦¦¦¦¦¦¦ Any help is greatly appreciated! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to make ........ even after a title in a cell?
If you would want to fill the cell with dots for *text only*,
allowing the regular entry of numbers, try this custom format: * General;* -General;* 0;@*. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Penny_in_FL" wrote in message ... I am creating a table and want to put ................ to the end of the cell and want it to be even in viewing and printing. i.e.: [see below...I copied from the cells] Task Hours Criteria Design Compliance.................. VE Review........................ GMP/Bid Review...................... Contract Negotiations................... Any help is greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The vertical title on every chart I make is cut off. | Charts and Charting in Excel | |||
Make chart title based on a cell? | Excel Discussion (Misc queries) | |||
How do I make a cell reference to a sheet title name | Excel Discussion (Misc queries) | |||
how 2 make one cell change title when either of 2 other are > 1 | Excel Discussion (Misc queries) | |||
can you make a title page using Excel? | Excel Worksheet Functions |