When I double-click on the row separator at the left, Excel adjusts the row
height to fit the contents of the cells.

At least, that's the way I think it's suposed to work. But what often
happens is that Excel adjusts the row height, but still does not show the
complete text.

Any suggestions?

I'm using Excel 2003.

Should work, unless there is a merged cell involved. Auto fit ignores
merged cells.

--
Jim
"Eric" wrote in message
...
When I double-click on the row separator at the left, Excel adjusts the
row
height to fit the contents of the cells.

At least, that's the way I think it's suposed to work. But what often
happens is that Excel adjusts the row height, but still does not show the
complete text.

Any suggestions?

I'm using Excel 2003.

It should but it doesn't. No merged cells.

"Jim Rech" wrote:

Should work, unless there is a merged cell involved. Auto fit ignores
merged cells.

--
Jim
"Eric" wrote in message
...
When I double-click on the row separator at the left, Excel adjusts the
row
height to fit the contents of the cells.

At least, that's the way I think it's suposed to work. But what often
happens is that Excel adjusts the row height, but still does not show the
complete text.

Any suggestions?

I'm using Excel 2003.

How much is "complete text

More than 1024 characters?

Add an Alt + Enter every 100 or so characters.


Gord Dibben MS Excel MVP

On Sat, 28 Jun 2008 13:10:00 -0700, Eric wrote:

When I double-click on the row separator at the left, Excel adjusts the row
height to fit the contents of the cells.

At least, that's the way I think it's suposed to work. But what often
happens is that Excel adjusts the row height, but still does not show the
complete text.

Any suggestions?

I'm using Excel 2003.

I don't know how big the cells are - but the text already is multi-line text,
all separated by Alt+enter.

"Gord Dibben" wrote:

How much is "complete text

More than 1024 characters?

Add an Alt + Enter every 100 or so characters.


Gord Dibben MS Excel MVP

On Sat, 28 Jun 2008 13:10:00 -0700, Eric wrote:

When I double-click on the row separator at the left, Excel adjusts the row
height to fit the contents of the cells.

At least, that's the way I think it's suposed to work. But what often
happens is that Excel adjusts the row height, but still does not show the
complete text.

Any suggestions?

I'm using Excel 2003.

To find out how many characters you're dealing with enter =LEN(cellref) in a
helper cell.

Make sure you're set for wrap text..........sounds like you are.


Gord

On Sat, 28 Jun 2008 15:41:00 -0700, Eric wrote:

I don't know how big the cells are - but the text already is multi-line text,
all separated by Alt+enter.

"Gord Dibben" wrote:

How much is "complete text

More than 1024 characters?

Add an Alt + Enter every 100 or so characters.


Gord Dibben MS Excel MVP

On Sat, 28 Jun 2008 13:10:00 -0700, Eric wrote:

When I double-click on the row separator at the left, Excel adjusts the row
height to fit the contents of the cells.

At least, that's the way I think it's suposed to work. But what often
happens is that Excel adjusts the row height, but still does not show the
complete text.

Any suggestions?

I'm using Excel 2003.