View lengthy text from one cell to another cell without widening cell width
of the other cell

I used the = sign to display a long text in cell A1 in cell H1 so that if I
change the text of A1, cell H1 will change as well;
I want to keep the cell widths of the worksheet narrow;
how can I view the entire text in H1 without having to widen it; whereas the
formula bar in A1 shows the entire text, the formula bar shows only the
formula reference, not the text itself

On a related point, I downloaded a form template and linked it to my data;
when I use the = sign to insert my data into the template, some €“ though not
all €“ cells display the cell that is being referenced to the form template
rather than the data that is actually contained in the cell

Cell D10 in datasheet contains text; instead of displaying the text in the
template, it shows the following formula that is the reference address:
='[data sheet.xlsx]'!$D$10


--
MZ