ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   cell shows all the data, click out of it, end of data disappears (https://www.excelbanter.com/excel-discussion-misc-queries/109723-cell-shows-all-data-click-out-end-data-disappears.html)

LINDA

cell shows all the data, click out of it, end of data disappears
 
i have a large amount of text in an Excel cell and it all shows but when i
click outside that cell, the last part disappears (it truncates in the middle
of a word). i have cells larger in other places in the worksheet. i tried
dragging down the cell size, merging the cells, and setting the size on that
row larger. same results each time. please help. Linda

Dave Peterson

cell shows all the data, click out of it, end of data disappears
 
If you have lots of text in the cell (more than a 1000 characters???), you can
add alt-enters ever 80-100 characters (to force new lines within the cell).

You may have to adjust the rowheight to see the text, though.

Linda wrote:

i have a large amount of text in an Excel cell and it all shows but when i
click outside that cell, the last part disappears (it truncates in the middle
of a word). i have cells larger in other places in the worksheet. i tried
dragging down the cell size, merging the cells, and setting the size on that
row larger. same results each time. please help. Linda


--

Dave Peterson


All times are GMT +1. The time now is 01:49 AM.

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