stop a cell from repeating its value continually across the page

S

shay

i have an excell sheet that has data in cells

surprise surpise thats usually what you do with a spreadsheet yes.

only problem is that the data repets itself to infinity for example ;

value123value123value123value123value123value123value123value123

where i want
value123
how do i stop this from happening?
 
T

T. Valko

value123value123value123value123value123value123value123value123

Is that all in one cell?

Select the cell in question
Take a look at this setting:
Goto the menu Format>Cells>Alignment tab
Under Text alignment>Horizontal make sure it *doesn't* have Fill selected.
Select General then OK out.
 
Top