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
(E-Mail Removed)
Similar Threads
