Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 174
  • Last Modified:

I need to see the entire contents of a cell in Excell. It has 3 large paragraphs, but only shows 1.

I need to see the entire contents of a cell in Excell. I do have it setup  as cell wrap.  I do see the entire contents of the cell in the formula bar but not the cell.

Thank you..
0
miamiLAW
Asked:
miamiLAW
  • 5
  • 4
  • 2
  • +3
1 Solution
 
simonwaitCommented:
Use the down arrow at the end of the formula bar where you can see the start of the information.  Then you can scroll up & down using the arrows
0
 
simonwaitCommented:
Sorry misread your question
0
 
Neil RussellTechnical Development LeadCommented:
Have you tried making the cell deeper manually?
Drag the row divider down and make it bigger, does that not help?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
miamiLAWAuthor Commented:
I need to format the entire sheet so that I can see all the contents on all cells.  Thank you.
0
 
cb1393Commented:
0
 
Neil RussellTechnical Development LeadCommented:
A silly question but WHY are you using excell to store PARAGRAPHS of information? Thats a word processing feature surely!
0
 
miamiLAWAuthor Commented:
UNFORTUNATELY, THIS SHEET HAS A LOT OF NUMERICAL DATA AND FORMULAS.  ONLY THE LAST COLUMN ENTITLED "COMMENTS" HAS WRITTEN INFO....AND ITS A LOT.

i WOULD ASSUME I DO HAVE OVER 1024 CHARACTERS.
0
 
miamiLAWAuthor Commented:
SORRY FOR CAPS...BUT I HAVE BAD VISION AND ITS BETTER FOR ME TO TYPE IN CAPS.  I AM NOT SCREAMING.  THANK YOU.
0
 
Neil RussellTechnical Development LeadCommented:
NO WORRIES. HOPE ITS EASIER TO READ TOO.

YOU COULD ALWAYS USE CODE SO THAT ON ENTRY TO THE CELL A POPUP FORM COMES UP WITH ALL OF THE COMMENT TEXT ON IT.
0
 
cb1393Commented:
IS THE CELL FORMATTED AS TEXT? IF SO, TRY CHANGING THE CELL FORMATTING TO GENERAL INSTEAD.
0
 
miamiLAWAuthor Commented:
THE ENTIRE COLUMS IS "GENERAL" BUT STILL DOES NOT SHOW THE ENTIRE CONTENTS OF THE CELL.  IT DOES NOT PRINT THE ENTIRE CONTENTS EITHER.  PLEASE ADVISE.  THANK YOU.
0
 
Neil RussellTechnical Development LeadCommented:
LIKE THE COMMENT ABOVE SAYS, EXCEL WILL ONLY SHOW THE FIRST 1024 CHARS. THIS YOU CAN NOT CHANGE. YOU WILL NEED TO EITHER SPLIT IT INTO MULTIPLE CELLS OR DO AS I SAID AND POP UP A FORM WITH THE CONTENTS OF THE CELL ON IT.
0
 
diek_nfCommented:
0
 
Neil RussellTechnical Development LeadCommented:
Yes it bassically says to do what we have been saying all along. SPLIT THE CELLS UP.
0
 
diek_nfCommented:
What about the comment from that link,"changing Text => Value fixed a nagging 1024 bug for me" What does that mean? Another concept is you may want to step up to Access.
0
 
Rob HensonIT & Database AssistantCommented:
Have you tried merging a few cells together or stretching the column width?
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 5
  • 4
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now