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: 178
  • Last Modified:

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
0
SteveL13
Asked:
SteveL13
  • 2
1 Solution
 
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
 
paulfarmerIT DirectoryCommented:
Sounds like you already tried that.  What version of excel are you using?
0
 
Rob HensonIT & Database AssistantCommented:
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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