Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dealing with Excel's Word-Wrap Limit
I have found that Excel will only automatically word-wrap up to 1024
characters in a cell; any additional text after that will just continue on the last line and will run out of sight off the edge of the cell except when being edited. I have a sheet that requires lengthy text comments by the users, and the 1024 character limit is not going to enough. It is possible to force additional line breaks in the text using Alt^Enter, but this is not a good solution for my mostly non-technical users, plus the word wrapping breaks at different points in Excel's edit mode than it does otherwise making it difficult to determine where a line needs to be inserted. Is there a way to increase the chararacter limit that Excel will word-wrap? Or does anyone have any clever ideas on how else I can have users enter lengthy commentary on an Excel sheet... perhaps an embedded control or something? Thanks for any suggestions, TK |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dealing with Excel's Word-Wrap Limit
Maybe use a textbox from the control toolbox toolbar?
T Kirtley wrote: I have found that Excel will only automatically word-wrap up to 1024 characters in a cell; any additional text after that will just continue on the last line and will run out of sight off the edge of the cell except when being edited. I have a sheet that requires lengthy text comments by the users, and the 1024 character limit is not going to enough. It is possible to force additional line breaks in the text using Alt^Enter, but this is not a good solution for my mostly non-technical users, plus the word wrapping breaks at different points in Excel's edit mode than it does otherwise making it difficult to determine where a line needs to be inserted. Is there a way to increase the chararacter limit that Excel will word-wrap? Or does anyone have any clever ideas on how else I can have users enter lengthy commentary on an Excel sheet... perhaps an embedded control or something? Thanks for any suggestions, TK -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel's conditions ignored by Word in Mail-merge | Excel Worksheet Functions | |||
Does Excel have a limit on lines it will wrap in a cell? | Excel Discussion (Misc queries) | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
Making Excel's open command work like Word | Excel Discussion (Misc queries) | |||
Word wrap | Excel Discussion (Misc queries) |