Fill a cell with a character

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.

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

Hi Anauna,

Use this format (format, cells, custom) to fill remainder with periods
@*.

Use this format to fill beginning with periods (leader dots)
*.@

The format doesn't have to be text formats, the following would
provide asterisk protection on dollar amount.
**$#.###.00

http://www.mvps.org/dmcritchie/excel/formula.htm

Using Formatting to Change the Way Numbers, Dates, Times, and Text Appear in Microsoft Excel,
http://support.microsoft.com/default...ts/default.asp

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Anauna" <[email protected]> wrote in message news:[email protected]...
> 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.

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 <[email protected]>
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.

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 <[email protected]>
> 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