Fill a Cell

  • Thread starter Thread starter Bonnie Keithley
  • Start date Start date
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
 
Hi Bonnie!

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


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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.)
 
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
 
Thanks to all who have answered. I appreciate the quick response time.

------------- Bonnie
 
Back
Top