stop a cell from repeating its value continually across the page

  • Thread starter Thread starter shay
  • Start date Start date
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?
 
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.
 
Back
Top