Pasting more than 10 lines into an Excel cell [moved from Vista]

timonomics · 05-20-2009, 10:08 PM

I'm working on a project that requires that I copy and paste text from Microsoft Word to an excel spreadsheet cell that has been expanded in width to about 8 normal columns. The problem I have is that Excel appears to not allow more than 10 pasted lines of text to be shown in a given expanded cell. Is there a way to paste more lines than 10 into an expanded Excel cell so they can all be seen? Going to Format and increasing the row height only increases the height of the cell but still does not allow more than 10 lines of pasted text to be seen.

**macropod** · 05-21-2009, 01:29 AM

Hi timonomics,

You may be running into Excel's cell character display limit. AFAIK, that's about 1024 characters. That's a design limit and there's really nothing you can do about it.

A possible workaround would be to embed a Word object on the Excel sheet. Then you could have a full page of text on the Word object - which you can even re-scale to fit the object into a smaller area without having to reformat the text.

**Glaswegian** · 05-21-2009, 06:16 AM

macropod is correct. A cell will hold 32,767 characters but only 1024 will display in the cell. However all 32,767 will display in the formula bar.

05-20-2009, 10:08 PM	#1 (permalink)
timonomics Registered User Join Date: May 2009 Posts: 1 OS: vista home basic	Pasting more than 10 lines into an Excel cell [moved from Vista] I'm working on a project that requires that I copy and paste text from Microsoft Word to an excel spreadsheet cell that has been expanded in width to about 8 normal columns. The problem I have is that Excel appears to not allow more than 10 pasted lines of text to be shown in a given expanded cell. Is there a way to paste more lines than 10 into an expanded Excel cell so they can all be seen? Going to Format and increasing the row height only increases the height of the cell but still does not allow more than 10 lines of pasted text to be seen.

05-21-2009, 01:29 AM	#2 (permalink)
macropod TSF Enthusiast Join Date: Apr 2008 Location: Australia Posts: 561 OS: Vista	Re: Pasting more than 10 lines into an Excel cell [moved from Vista] Hi timonomics, You may be running into Excel's cell character display limit. AFAIK, that's about 1024 characters. That's a design limit and there's really nothing you can do about it. A possible workaround would be to embed a Word object on the Excel sheet. Then you could have a full page of text on the Word object - which you can even re-scale to fit the object into a smaller area without having to reformat the text. __________________ Cheers macropod (MS MVP -Word)

05-21-2009, 06:16 AM	#3 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,427 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: Pasting more than 10 lines into an Excel cell [moved from Vista] macropod is correct. A cell will hold 32,767 characters but only 1024 will display in the cell. However all 32,767 will display in the formula bar. __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner