MS Excel - Expanding the number of characters a cell can display in MS Excel 2007

Posted on 2011-05-02
Last Modified: 2012-06-21
I have a worksheet where I am copying text from word documents into a few columns for all rows.

The text is between 1500 and 15000 characters.

I am finding that the cell will only display approximately 1000 characters.

Is there a way that I can change the Excel characteristics to allow auto pasting of the copied data.

I am aware that the paste is captured in the formula bar but not displayed.

The board results that I have seen talk about using Alt-Enter as a solution but is there a workaround to automate the process for a column of cells.

Any help appreciated

Question by:Andross9
    LVL 6

    Expert Comment

    The maximum number of characters in a cell is limited to 32,767 (Excel 2003 for example) but only about 1000 will show up in the cell. The alt+enter works in between such long test within the cell but it is not a automated as you say.
    Here is a link from Microsoft which shows how to address the problem you are having:

    You can also use a text box to achieve this and even use Access to create a memo field to hold the characters.

    I found this macro which might help you automate the process:

    Probably needs some fiddling around to work but I hope it can help.

    Author Comment

    Thanks nipponsoul:

    MS are so good at providing an issue but not in providing the solution.

    Cant get the macro to work in Excel 2007 to expand the display characters.

    Am most likely importing data into the cells - so text boxes isnt an option for me.

    Thanks for your efforts
    LVL 16

    Expert Comment

    You can copy the text, go in edit mode in the cell (double click it, click in the formula bar etc) and then paste the text

    That will hold the characters.

    If you have specific file formats from which you want the copy-paste to happen to-from, please provide samples and i can try creating a macro for this.

    Author Comment

    Hi there

    The importing/copy&paste will most likely come from a word document

    Have attached a file as an example.

    Of the 2500 or so characters, I can only get around 1000 to display and or print.

    Have tried numerous web solutions that I have googles but none seem to solve the problem.

    Any help would be great - or is it simply too hard to solve??


    Author Comment

    LVL 16

    Expert Comment

    You can actually merge 2-3 cells together and increase row height to 200 or something...all text is visible then
    LVL 16

    Accepted Solution

    just make sure that the first of the merged cells is the one containing the text.

    Author Closing Comment

    Efforts appreciated, however soloution still doesnt do what I would like, will try again later.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now