viewing all words in a cell
 

I can see all the words in the cell in the formula bar when the cell is
selected. When it's not, I can's see them in the cell, no matter how big I
physically make the cell. I can make the cell so big that there is a lot of
white space at the end of the words, but the words still cut off.

Any ideas?

viewing all words in a cell
 

T insure visibility, insert a hard return every so often. This is done with
a ALT-ENTER key touch.
--
Gary's Student


"Annabelle611" wrote:

I can see all the words in the cell in the formula bar when the cell is
selected. When it's not, I can's see them in the cell, no matter how big I
physically make the cell. I can make the cell so big that there is a lot of
white space at the end of the words, but the words still cut off.

Any ideas?

viewing all words in a cell
 

Annabelle

Excel has a limit of 1024 characters visible in a cell, all 32k (total
limit) show in the formula bar

See help (Excel limits and specifications)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Annabelle611" wrote in message
...
I can see all the words in the cell in the formula bar when the cell is
selected. When it's not, I can's see them in the cell, no matter how big I
physically make the cell. I can make the cell so big that there is a lot
of
white space at the end of the words, but the words still cut off.

Any ideas?

viewing all words in a cell
 

But if you add alt-enters (to force new lines within the cell) every 80-100
characters, then you'll be able to see lots more characters than 1024 in that
cell.

Nick Hodge wrote:

Annabelle

Excel has a limit of 1024 characters visible in a cell, all 32k (total
limit) show in the formula bar

See help (Excel limits and specifications)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk

"Annabelle611" wrote in message
...
I can see all the words in the cell in the formula bar when the cell is
selected. When it's not, I can's see them in the cell, no matter how big I
physically make the cell. I can make the cell so big that there is a lot
of
white space at the end of the words, but the words still cut off.

Any ideas?

--

Dave Peterson

viewing all words in a cell
 

Dave

True, but that's a 'dance' ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Dave Peterson" wrote in message
...
But if you add alt-enters (to force new lines within the cell) every
80-100
characters, then you'll be able to see lots more characters than 1024 in
that
cell.

Nick Hodge wrote:

Annabelle

Excel has a limit of 1024 characters visible in a cell, all 32k (total
limit) show in the formula bar

See help (Excel limits and specifications)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk

"Annabelle611" wrote in message
...
I can see all the words in the cell in the formula bar when the cell is
selected. When it's not, I can's see them in the cell, no matter how
big I
physically make the cell. I can make the cell so big that there is a
lot
of
white space at the end of the words, but the words still cut off.

Any ideas?

--

Dave Peterson