Home |
Search |
Today's Posts |
#1
|
|||
|
|||
repeating a character across the width of a column
I've seen it done that a single character was entered into a cell (eg a dash)
and the effect was that the entire cell width was filled with a repetition of that character. If I widen the cell, more characters appear. How is this done please? TIA, Greg |
#2
|
|||
|
|||
Hi!
One way: =REPT("-",255) However, if the cell to the immediate right is empty then the dashes will overflow into other columns. Biff "gvm" wrote in message ... I've seen it done that a single character was entered into a cell (eg a dash) and the effect was that the entire cell width was filled with a repetition of that character. If I widen the cell, more characters appear. How is this done please? TIA, Greg |
#3
|
|||
|
|||
format|cells|alignment tab|horizontal text alignment box|Fill
Is another way. gvm wrote: I've seen it done that a single character was entered into a cell (eg a dash) and the effect was that the entire cell width was filled with a repetition of that character. If I widen the cell, more characters appear. How is this done please? TIA, Greg -- Dave Peterson |
#4
|
|||
|
|||
I was looking for that but couldn't remember where it was!
Biff "Dave Peterson" wrote in message ... format|cells|alignment tab|horizontal text alignment box|Fill Is another way. gvm wrote: I've seen it done that a single character was entered into a cell (eg a dash) and the effect was that the entire cell width was filled with a repetition of that character. If I widen the cell, more characters appear. How is this done please? TIA, Greg -- Dave Peterson |
#5
|
|||
|
|||
that's it, thanks Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Column Width Behavior | Excel Discussion (Misc queries) | |||
Column character width on auto filter | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Column Width | Excel Discussion (Misc queries) |