Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
I have a spread sheet of actions, with a unique reference on each row. Each unique action may have a number of actions within it.
With 50 + unique references it is a pain in to have each row expanded to show all the text in the actions column. It would be ideal just to be able to hover on the action cell and the detail 'pop up'.
I don't want to use comments as I assume they don't work on filters ie if I was looking for all actions that contained key words.
Any ideas?
Thanks
Would wrapping the reference work?
you can expand the size of the "editing" cell at the top that is populated when you click on a cell?
to thr right of this arrow
Wrapping used as standard.
Viewing at the top still means you have to use a scroll down and it’s limited to 3 rows of data at a time.
The ideal solution would be comments... if I could get the comments to auto update with the content of the cell.
Actually just randomly found that double clicking on the cell expands it to show full content. When you click elsewhere it returns to ‘normal’ size
if I could get the comments to auto update with the content of the cell
Not quite auto-update, but this does 99% of what you want: https://www.extendoffice.com/documents/excel/764-excel-convert-cell-contents-to-comment.html#a1