If my column widths are all set for, say 12.5, why is it then you type, for
example, the following into a cell:

New York Jets and New York Giants

When I view the workbook, some columns with the above is in a cell,
truncates the expression, i.e. all you see is:

"New York Jets an"

And, at the same time, in a different column, the expression is clearly
completely visible, overriding the vertical boundary and appearing well into
the next column,
in some of the cells, but then truncated in the other cells.

What "FORMAT??" allows this dilemma to occur?

Thanks,

FLKulchar

I you want the text to go into the following cells make sure the following
cells are blank. Aonther option is to use the wrap feature. Go to formate
and select the alignment tab and you will see a box to select wrap.

"FLKULCHAR" wrote:

If my column widths are all set for, say 12.5, why is it then you type, for
example, the following into a cell:

New York Jets and New York Giants

When I view the workbook, some columns with the above is in a cell,
truncates the expression, i.e. all you see is:

"New York Jets an"

And, at the same time, in a different column, the expression is clearly
completely visible, overriding the vertical boundary and appearing well into
the next column,
in some of the cells, but then truncated in the other cells.

What "FORMAT??" allows this dilemma to occur?

Thanks,

FLKulchar

See in-line answer

On Mon, 31 Oct 2005 14:41:02 -0800, FLKULCHAR
wrote:

If my column widths are all set for, say 12.5, why is it then you type, for
example, the following into a cell:

New York Jets and New York Giants

When I view the workbook, some columns with the above is in a cell,
truncates the expression, i.e. all you see is:

"New York Jets an"

And, at the same time, in a different column, the expression is clearly
completely visible, overriding the vertical boundary and appearing well into
the next column,
in some of the cells, but then truncated in the other cells.

What "FORMAT??" allows this dilemma to occur?

No "Format" allows this.

If the cell(s) to the right of the text cell is(are) truly empty, the text
will run across and be visible.

If not empty..........contains a space perhaps...........the text cell will
truncate.

Use wrap text and autofit in this case.


Gord Dibben Excel MVP


Thanks,

FLKulchar

thank you...your rsvp was exactly correct

"Gord Dibben" wrote:

See in-line answer

On Mon, 31 Oct 2005 14:41:02 -0800, FLKULCHAR
wrote:

If my column widths are all set for, say 12.5, why is it then you type, for
example, the following into a cell:

New York Jets and New York Giants

When I view the workbook, some columns with the above is in a cell,
truncates the expression, i.e. all you see is:

"New York Jets an"

And, at the same time, in a different column, the expression is clearly
completely visible, overriding the vertical boundary and appearing well into
the next column,
in some of the cells, but then truncated in the other cells.

What "FORMAT??" allows this dilemma to occur?

No "Format" allows this.

If the cell(s) to the right of the text cell is(are) truly empty, the text
will run across and be visible.

If not empty..........contains a space perhaps...........the text cell will
truncate.

Use wrap text and autofit in this case.


Gord Dibben Excel MVP


Thanks,

FLKulchar