' character in excel

H

holhol1214

In older versions of excel the ' character could be used as the first
character in a cell to mke the following character repeat itself throughout
the cell. This command no loner works. What command was used to replace it?
 
D

Dave Peterson

You sure that the character wasn't a backslash (\) with:
tools|options|transition tab|transition navigation keys
checked.

You could try:
type the character(s) in the cell.
Format|cells|alignment tab|Horizontal Text Alignment box|Fill
 
S

Sheeloo

Type the character you want then
Format|Cells|Alignment tab|Horizontal text alignment|Fill

or
Format|Cells -> Number -> Custom
*A
Repeates A

or
=REPT("A",300)
 
Top