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?

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


"Repeating symbols" skrev:

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?

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


Replace @mailinator.com with @tiscali.co.uk


"Repeating symbols" <Repeating wrote in
message ...
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?

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!



"Repeating symbols" wrote:

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?

One more........

FormatCellAlignmentHorizontalFill.

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
wrote:

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?