cell shows all the data, click out of it, end of data disappears

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data in cells disappear temporarily 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Can I add button to cell to easily view all data in cell? 1
some text shows in merged cells but not all 2
What controls row expansion to show muli-line text in a word-wrap 1
Sharing workbooks limitations - Merged Cells 12
Data Validation/In-Cell Dropdown Lists 1
Behavior of text in cells..... 1

Back
Top