cells

H

hello

hello there, i have a large data in one cell that the
portion of the data you cannot see on the cell but it can
be viewed in the formula bar. I want to keep this all in
one page and the text does wrap within the cell. My
question is, is there a limit on characters within each
cell? Is there another way to view the entire data in one
cell besides moving the columns around it? thanks in
advance
 
F

Frank Kabel

Hi
the limit is 1024 characters. You can extend this by manually inserting
linebreaks with
ALT+ENTER
 
G

Guest

thank you Frank Kabel, but that still doesn't allow me
view the entire data in that cell. any other ideas?
 

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

Code character limit with Resize or Transpose or cell? 8
View lengthy text from one cell to another cell without widening c 1
Table Preferred width is changed when pasting 1
Creating Labels Over 3-Up Image 2
formatting specific cell 3
auto row height a cell with wrap text enabled and a lot of charact 0
Using Excel to Separate info within a Cell 3
Fixing text wrap in merged cells 1

Top