How see all text in a cell when display limit is exceeded

If I have a cell in an Excel worksheet that has exceeded the display limit of 1,024 characters even though the cell can hold 32,767 characters, is there a way for the user to somehow Double-click on the cell and have the entire text display?

Or maybe some other method?

--Steve
SteveL13Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

paulfarmerIT DirectoryCommented:
Two options:
1st, you can see the text in the input box on top. Probably not the best option.
2nd, in excel 2010, I just double-clicked the cell and it expanded into a box where I could read all of the text.
I used about 4,000 characters.  Not sure if your problem is bigger than this.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
paulfarmerIT DirectoryCommented:
Sounds like you already tried that.  What version of excel are you using?
0
Rob HensonFinance AnalystCommented:
The reason for the limitation in Excel is that it is designed for numbers. Why would you need to use an Excel cell for text string more than 1024 characters long?

Look at embedding a Word document rather than entering directly in a cell.

Thanks
Rob H
0
SteveL13Author Commented:
I did not know I could just double-click the cell.  Thanks.  That'll work.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.