Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / October 2006

Tip: Looking for answers? Try searching our database.

excell - merging cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
flores - 26 Oct 2006 20:53 GMT
How can I merge cells to create one page and have all the text wrap?  I have
merged all the cells on one page and created one merge.  As I type text some
of the text merges, and other text does not - all on the same page.  Why?  
How do I make all the text on each line wrap?
Gord Dibben - 27 Oct 2006 01:26 GMT
flores

Merging a great block of cells creates one big cell with the limitations of one
cell.

One of those limitations is the amount of viewable text.

You can enter 32767 characters in a cell but only 1024 will be visible or can be
printed.

If you stick an ALT + ENTER carriage return every 100 characters you can
increase this 1024 limit.

Otherwise, use a text box or a Word processing program like MS Word.

Gord Dibben  MS Excel MVP

>How can I merge cells to create one page and have all the text wrap?  I have
>merged all the cells on one page and created one merge.  As I type text some
>of the text merges, and other text does not - all on the same page.  Why?  
>How do I make all the text on each line wrap?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.