Labeling Values in a cell

[kstuffer]

I have a financial spreadsheet that holds all of my financial data. One of the columns is a pending column. This means that the figure held here would be money that is pending. So a check waiting to be cashed/deposited etc. Is it possible to insert lets say

Pending check - $546
Waiting for payment from John - $232

into one cell. When the cell isn't clicked it will show the sum ($778) but when I click on it it will show the data above so that I will know what the pending amounts are from.

Any ideas of a solution?


many thanks!

 

[Michael M]

Have you considered insertting a Comment into the cell.
Select the cell and then
Insert / Comment

The whenever the mouse is hovered over the cell, the comment will appear.

 

[Warship]

Use a Cell Comment?