V
Victor Delta
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
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