ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   cell won't let me put all of information into it. (https://www.excelbanter.com/excel-discussion-misc-queries/62496-cell-wont-let-me-put-all-information-into.html)

rejzerrn

cell won't let me put all of information into it.
 
Why does the cell stop letting me type info into it, yet it's visible when I
double click it, but when I go into another cell, half of my words disappear.
What am I doing wrong? Thanks in advance for your help!
--
rejzerrn

Dave Peterson

cell won't let me put all of information into it.
 
Try adding alt-enters every 80-100 characters.

rejzerrn wrote:

Why does the cell stop letting me type info into it, yet it's visible when I
double click it, but when I go into another cell, half of my words disappear.
What am I doing wrong? Thanks in advance for your help!
--
rejzerrn


--

Dave Peterson

rejzerrn

cell won't let me put all of information into it.
 
How do I do that?? Thanks for your help
--
rejzerrn


"Dave Peterson" wrote:

Try adding alt-enters every 80-100 characters.

rejzerrn wrote:

Why does the cell stop letting me type info into it, yet it's visible when I
double click it, but when I go into another cell, half of my words disappear.
What am I doing wrong? Thanks in advance for your help!
--
rejzerrn


--

Dave Peterson


rejzerrn

cell won't let me put all of information into it.
 
I figured it out...but even after I alt-enter, I still have to double clicl
the cell to get all of the info in it...yet when I go to another cell, some
of the info disappears.
--
rejzerrn


"Dave Peterson" wrote:

Try adding alt-enters every 80-100 characters.

rejzerrn wrote:

Why does the cell stop letting me type info into it, yet it's visible when I
double click it, but when I go into another cell, half of my words disappear.
What am I doing wrong? Thanks in advance for your help!
--
rejzerrn


--

Dave Peterson


Dave Peterson

cell won't let me put all of information into it.
 
Widen the column. Increase the rowheight. Decrease the font size.

These are all ways to see more in that cell.

Just curious--how many characters are in that cell?

A formula like: =len(a1) will return the number of characters.

(I've seen lots and lots of characters this way.)

rejzerrn wrote:

I figured it out...but even after I alt-enter, I still have to double clicl
the cell to get all of the info in it...yet when I go to another cell, some
of the info disappears.
--
rejzerrn

"Dave Peterson" wrote:

Try adding alt-enters every 80-100 characters.

rejzerrn wrote:

Why does the cell stop letting me type info into it, yet it's visible when I
double click it, but when I go into another cell, half of my words disappear.
What am I doing wrong? Thanks in advance for your help!
--
rejzerrn


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 07:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com