This does work if you type and = (equal sign) and use @*= as the custom format.

But if the OP wanted any old character repeated, then they'd have to use that
character in the custom format, too.



Gord Dibben wrote:

Or a custom format of @*=

I use this one for "leaders" @*.

Gord Dibben Excel MVP

On Thu, 03 Mar 2005 09:03:40 -0600, Dave Peterson
wrote:

Format|Cells|Alignment tab|Horizontal Dropdown box|Fill

You can also toggle a transition setting to get the same effect.

Tools|options|Transition tab|check Transition navigation keys.

But this will change how the Tab and home/ctrl-home key work, too.

Anauna wrote:

Hello,

In Quattro I can place a backslash (\) followed by a character...say = and
the character will fill the cell regarless of column width.

Is there a process in Excel to achieve the similar outcome?

--
Thank-you and all suggestions are appreciated.

--

Dave Peterson