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

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

Sorry misread your question

Have you tried making the cell deeper manually?
Drag the row divider down and make it bigger, does that not help?

I need to format the entire sheet so that I can see all the contents on all cells.  Thank you.

I'm guessing your text is more than 1024 characters...?

http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx

A silly question but WHY are you using excell to store PARAGRAPHS of information? Thats a word processing feature surely!

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.

SORRY FOR CAPS...BUT I HAVE BAD VISION AND ITS BETTER FOR ME TO TYPE IN CAPS.  I AM NOT SCREAMING.  THANK YOU.

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.

IS THE CELL FORMATTED AS TEXT? IF SO, TRY CHANGING THE CELL FORMATTING TO GENERAL INSTEAD.

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.

See bottom of this http://blog.excelgeek.com/2006/01/work-around-for-1024-character-per.html

d

Yes it bassically says to do what we have been saying all along. SPLIT THE CELLS UP.

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.

Have you tried merging a few cells together or stretching the column width?