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

Posted on 2011-05-02
Medium Priority
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
  • 4
  • 3

Expert Comment

ID: 35504057
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

ID: 35510362
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 18

Expert Comment

ID: 35512645
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.
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  


Author Comment

ID: 35689182
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??

LVL 18

Expert Comment

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

Accepted Solution

xtermie earned 1500 total points
ID: 35690416
just make sure that the first of the merged cells is the one containing the text.

Author Closing Comment

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

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

862 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