cells

  • Thread starter Thread starter hello
  • Start date Start date
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
 
Hi
the limit is 1024 characters. You can extend this by manually inserting
linebreaks with
ALT+ENTER
 
thank you Frank Kabel, but that still doesn't allow me
view the entire data in that cell. any other ideas?
 
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

Cell shows the last typed text, no matter where it is typed 0
View lengthy text from one cell to another cell without widening c 1
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
VBA set thick borders around non empty cells in range 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Help needed 0
Code character limit with Resize or Transpose or cell? 8

Back
Top