is there a way to prevent cells from overlapping?

[airtas]

in excel 2007 is there a way to prevent a string of characters and the cell to automatically overlap into the next cell?

 

[white605]

In Older versions you can select the cell, right click, format cell, alignment - choose "fill"

This old world keeps spinning round - It's a wonder tall trees ain't layin' down

 

[SkipVought]

either change the font size, align the column width or wrap the text.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[airtas]

I want it to stay hidden

for example lets says I type this

CELLA CELLB
gggggiiiiiiiiiiiiiiiiii


how can I have the remaining IIIIIIIIIIIII stay hidden?

 

[macropod]

Hi airtas,

If you format the cell so that wordwrap is on, and type more than fits the normal cell width, Excel will ordinarily expand the row height to fit. You can re-set the cell height so that the wrapped text is hidden. Do note that, if these are spaces, periods etc in the string, this may cause the text to wrap to the next line earlier than you might want.

An alternative, without text wrapping, is simply to put a single space character in the adjoining cell.

Cheers

[MS MVP - Word]