Hi everyone,

I seem to remember when I used SuperCalc that there was a way to fill
the WHOLE cell with a character by just entering the one character in.
So, for example, if I wanted to fill the WHOLE cell with an asterix
what would I need to do please.

Thanks in Advance.
All the Best.
Paul

Just hold the key down and the character will repeat until you let up.

Mike F
"Paul Black" wrote in message
ups.com...
Hi everyone,

I seem to remember when I used SuperCalc that there was a way to fill
the WHOLE cell with a character by just entering the one character in.
So, for example, if I wanted to fill the WHOLE cell with an asterix
what would I need to do please.

Thanks in Advance.
All the Best.
Paul

Hi Paul

This would be one way to do it though it isn't the cleanest, it will
work with the font Arial with a size of 10 you will have to change the
values if you intend to use a different font and size. Paste the code
below in the sheet1 module then if you enter * into a cell in sheet1
after you move off the cell it will fill with that character no mater
what width the cell.

Option Explicit
Dim i, x As Integer

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Value = "*" Then

i = Target.Width - 5.25 ' this value is the min width a cell can
be with 1 * in it

i = i / 3.75 ' this value is the difference in width per each
character added

i = Round(i) ' just incase it's off round the number

For x = 1 To i - 1 ' set the loop to fill the cell

Target.Value = Target.Value & "*"

Next

End If

End Sub

Hope this helps

S

I am not aware of a format that will repeat the character you typed in but if
you know the character ahed of time that you want then you can use this
custom format

Format|Cells - Number - Custom
**
Repeates the asterix
*-
Repeats a dash
--
HTH...

Jim Thomlinson


"Paul Black" wrote:

Hi everyone,

I seem to remember when I used SuperCalc that there was a way to fill
the WHOLE cell with a character by just entering the one character in.
So, for example, if I wanted to fill the WHOLE cell with an asterix
what would I need to do please.

Thanks in Advance.
All the Best.
Paul

If I remember correctly, it wasn't a key it was a formula. In Lotus 1-2-3 it
was the REPEAT function in Excel it's the REPT function

=REPT(TextToRepeat,NumberOfRepetitions)

=REPT("*",300)
--
Kevin Backmann


"Paul Black" wrote:

Hi everyone,

I seem to remember when I used SuperCalc that there was a way to fill
the WHOLE cell with a character by just entering the one character in.
So, for example, if I wanted to fill the WHOLE cell with an asterix
what would I need to do please.

Thanks in Advance.
All the Best.
Paul

"Paul Black" wrote in message
ups.com...
Hi everyone,

I seem to remember when I used SuperCalc that there was a way to fill
the WHOLE cell with a character by just entering the one character in.
So, for example, if I wanted to fill the WHOLE cell with an asterix
what would I need to do please.

Thanks in Advance.
All the Best.
Paul


In Lotus123 one would enter a slash followed by the character to repeat -
"\*". I don't think Excel supports this any longer, but you could try
fiddling with the transition settings in the Tools | Options dialog.

Rob

This is the way I fill cells with the same character. I type the
character into the cell. I then go to Format--Cells--Align--Text
Alignment Horizontal and pull down the menu to fill. I then click
okay. I use Excel 2003.

Steve G

Or
Type the character * (asterisk)
Format|Cells|Alignment tab|Horizontal text alignment|Fill


Jim Thomlinson wrote:

I am not aware of a format that will repeat the character you typed in but if
you know the character ahed of time that you want then you can use this
custom format

Format|Cells - Number - Custom
**
Repeates the asterix
*-
Repeats a dash
--
HTH...

Jim Thomlinson

"Paul Black" wrote:

Hi everyone,

I seem to remember when I used SuperCalc that there was a way to fill
the WHOLE cell with a character by just entering the one character in.
So, for example, if I wanted to fill the WHOLE cell with an asterix
what would I need to do please.

Thanks in Advance.
All the Best.
Paul



--

Dave Peterson

Thanks Dave. You learn something new every day...
--
HTH...

Jim Thomlinson


"Dave Peterson" wrote:

Or
Type the character * (asterisk)
Format|Cells|Alignment tab|Horizontal text alignment|Fill


Jim Thomlinson wrote:

I am not aware of a format that will repeat the character you typed in but if
you know the character ahed of time that you want then you can use this
custom format

Format|Cells - Number - Custom
**
Repeates the asterix
*-
Repeats a dash
--
HTH...

Jim Thomlinson

"Paul Black" wrote:

Hi everyone,

I seem to remember when I used SuperCalc that there was a way to fill
the WHOLE cell with a character by just entering the one character in.
So, for example, if I wanted to fill the WHOLE cell with an asterix
what would I need to do please.

Thanks in Advance.
All the Best.
Paul



--

Dave Peterson

That's what I(!) like about the newsgroups!

Jim Thomlinson wrote:

Thanks Dave. You learn something new every day...
--
HTH...

Jim Thomlinson

"Dave Peterson" wrote:

Or
Type the character * (asterisk)
Format|Cells|Alignment tab|Horizontal text alignment|Fill


Jim Thomlinson wrote:

I am not aware of a format that will repeat the character you typed in but if
you know the character ahed of time that you want then you can use this
custom format

Format|Cells - Number - Custom
**
Repeates the asterix
*-
Repeats a dash
--
HTH...

Jim Thomlinson

"Paul Black" wrote:

Hi everyone,

I seem to remember when I used SuperCalc that there was a way to fill
the WHOLE cell with a character by just entering the one character in.
So, for example, if I wanted to fill the WHOLE cell with an asterix
what would I need to do please.

Thanks in Advance.
All the Best.
Paul



--

Dave Peterson


--

Dave Peterson