Re: Fill a Cell

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 Keithley wrote:
>
> 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

--

Dave Peterson
ec35720@msn.com