Format Cells

[KPK]

Is there any way to prevent text from extending into
adjacent blank cells? (as the default setting)

 

[Frank Kabel]

Hi
use 'Format - Cells - alignment' and check 'word wrap'

 

[KPK]

We actually do not want the text to wrap, we just want it
to truncate.

Thanks,

Kieran

 

[Doug Kanter]

Widen the column?

We actually do not want the text to wrap, we just want it
to truncate.

Thanks,

Kieran

 

[Frank Kabel]

Hi
if you don't enter anything in the adjacent column this is not possible

 

[Trevor]

Frank's right; you can't truncate it, but you can't truncate the text, but
you can "pretend" it's truncated by turning ON the word wrap, and then
fixing the column height so that it only shows the first row of your data
AND format the cell so that the vertical alignment is TOP.

Also note that putting a space in the adjoining cell will prevent the data
from bleeding over into it, though it will make that column (row) of cells
show up in printouts.

 

[Dave Peterson]

I like to use ="" instead of a space character.

The cell looks empty, but I can see the formula in the formula bar. And it
reminds me that it's there for a reason.