Repeat symbol in a cell??

[Guest]

I want to repeat the same symbol to fill a cell, I know there is a simple
keystroke for this but I have forgotten it.

Example: I want ***'s to fill the cell across.

Anyone have an idea of how to do this?

 

[Guest]

Format cells
second tab from left (justify i think name is)
select in vertical box - fill


"Repeating symbols" skrev:

 

[Sandy Mann]

Custom format as
##**
for 99**********

or ##*-

37----------

Note that it only works with numbers not text.



--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Guest]

First, go to Tools/Options/Transition and make sure you have checked the
transition navigation keys box. Then just enter \ and whatever symbol you
want to appear in that cell. Example: \* returns *********** (or however
many it takes to fill your column based on the width.)

Good luck!

 

[Gord Dibben]

One more........

Format>Cell>Alignment>Horizontal>Fill.

If you want the asterisks to be leaders like text******** you could format
the cell to Custom @**


Gord Dibben MS Excel MVP

On Wed, 19 Sep 2007 12:20:04 -0700, Repeating symbols <Repeating