I have the spreadsheet that I have been working on and have got some text that is too big for the cell.
I dont want to shrink to fit as it would be too small and I dont want to resize the worksheet.

Ideally I want the contents of the cell in the formula bar, but as its locked and hidden you cant press F9 to display the formula result.
Is there anyway I could get it so that when I clicked on, for in this example D8, it displays the cell value in A1 or pops the value up or anything similar - comments box maybe??

This is not for printing, just generally using the workbook on a Laptop/PC

rota7.xlsx