I have data in Sheet1 cell A1: ABCDEFGHIJKLMNOPQRSTUVWXYZ

This data is linked to Sheet2 cell A1. The formula reads: ='Sheet1'!A1. Also, the text is wrapped and I resized the cells so they aren't enlarged. When I view the cell all I see is "GHIJKLM"

I would like to be able to see everything (i.e. - ABC....) without having to resize the cell.

Is this possible? What are my options?