Excel Help – Show data in a cell without expanding the row?

Viewing 6 posts - 1 through 6 (of 6 total)
  • Excel Help – Show data in a cell without expanding the row?
  • FunkyDunc
    Member

    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

    Premier Icon danti
    Subscriber

    Would wrapping the reference work?

    nbt
    Member

    you can expand the size of the “editing” cell at the top that is populated when you click on a cell?

    excel editing

    to thr right of this arrow

    FunkyDunc
    Member

    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.

    FunkyDunc
    Member

    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

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.