Repeat symbol in a cell??

R

Repeating symbols

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?
 
E

excelent

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


"Repeating symbols" skrev:
 
S

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
D

dannyrblock

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!
 
G

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
 
Top