Fill Cell with Asterix

[Paul Black]

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

 

[Mike Fogleman]

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

Mike F

 

[Incidental]

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

 

[Jim Thomlinson]

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

 

[Kevin B]

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)

 

[Robert Bruce]

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

 

[Steve G]

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

 

[Dave Peterson]

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

 

[Jim Thomlinson]

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

 

[Dave Peterson]

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

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

 

[Paul Black]

Thanks everyone for the replies and insight.
Dave, yours works perfectly, thank you.

All the Best.
Paul