Fill a Cell

B

Bonnie Keithley

Using Excel 2000.

I have forgotten the data entry syntax for filling the width of a cell with
a particular character. For example, if I want to fill a cell from left
edge to right edge with a hyphen (-), what is the syntax? Seems to me that
in older versions I was able to use a slash or backslash followed by the
character and it would fill the width of the cell.

Anyone know the answer??? -------- Bonnie
 
N

Norman Harker

Hi Bonnie!

Try:
Type a - in the cell
Format > Cell >Alignment tab
Horizontal dropdown, choose Fill
OK


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
D

Dave Peterson

In excel:

type your character (-) and
then Format|Cells|alignment tab
in the Horizontal dropdown, choose Fill.

If you have tools|Options|Transition Tab|"Tansition Navigation keys" checked,
you can use \-
(backslash dash)

But that setting can cause other trouble. I'd toggle it off as soon as I was
done with data entry.

(Try hitting Home and Tab with the settings each way and you'll see the
difference.)
 
G

Gord Dibben

Bonnie

Posting to one newsgroup is usually sufficient.

Dave, Jim and Norman have provided answers.

You can also use a custom format.

Format>Cells>Number>Custom. Enter @*-

This will place ------- after whatever you enter. Enter one - to get --------
Enter ab to get ab---------

I use the macro below to produce leaders(series of dots after text)

Sub Leaders()
Selection.numberformat = "@*."
End Sub

Gord Dibben Excel MVP
 
B

Bonnie Keithley

Thanks to all who have answered. I appreciate the quick response time.

------------- Bonnie
 
Top