Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Word-Wrap Help?
In a spreadsheet, I have one worksheet which contains a lot of data and
text. Another worksheet copies some of that info (using the LOOKUP function) into a more manageable form for viewing and printing etc. Some of the fields contain quite a bit of text and so, in the second spreadsheet, I have formatted the cells using word-wrap so that all the text is visible. This works well. However, if I now add some additional text to one of the cells in the first worksheet, the second worksheet does not automatically re-word-wrap, so the end of the new text will be hidden. I have found that if I manually remove the word-wrap and then reapply it, the cells adjust to show all the text. So my question is - is there a way of making the worksheet automatically adjust the word-wrapping when necessary? If not, then I guess I could write a macro to do what I currently do manually. If I do go down this path, is there a way to make a macro run automatically when one clicks on the tab of a particular worksheet (i.e. the second one, in this case)? TIA V |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word Wrap Help! | Excel Discussion (Misc queries) | |||
Word wrap | Excel Discussion (Misc queries) | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
word wrap | Excel Discussion (Misc queries) | |||
Word Wrap | Excel Discussion (Misc queries) |