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? For example if I could use VBA for getting each cell to autosize itself when the cell is selected or hovered over with the mouse pointer, would that be possible?
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.