In excel i have several worksheets set up in a workbook. On one worksheet i
have cells that contain text. I want this text to be display on another
Summary worksheet within the same workbook. I have done this successfully in
terms of creating the formula to do this , however, the Summary worksheet
doesn't display all of the text, even if i have merged cells/wrapped the
text/shrink to fit. No matter what i try i can not see all of the text
unless i expand the cells massively. Is there a way round this? Can i use
some other form of display?