Displaying cell contents (from excel) in a text box

[healthwa2022]

I have managed to get the text box in excel to display the contents of a cell of another worksheet in the same workbook but it is not showing all of the contents. I've tried resizing it and changing various properties but can't seem to get all text in the shape.  Any ideas what I am doing wrong or is there a limit I don't know about?

[#2]

@healthwa2022 

with VBA macro this could be overcome

Sub SetColumnsRows()
With ActiveSheet.UsedRange
.Columns.AutoFit
.Rows.AutoFit
End With
End Sub

Additional Information:

Change the column width and row height