For a cell in Excel overfilled with text that can't be displayed in full, what is the best way to display all text upon hovering with the mouse or selected with cursor?
For example, if I use Data/Data validation/Input message, is it possible to make this dynamic so that the message displayed is what the cell contains?
Or would I need to use VBA?
In other words, the cell's size is too small to display all the contents, and I want all contents in it to be displayed when the cell is selected with the cursor or hovered over with the mouse pointer.
I have Excel 2007.