How can I attach an explanatory note to a data cell?

  • Thread starter Thread starter Grant
  • Start date Start date
G

Grant

So, I have data cells in an Excel spreadsheet. The row has a heading, like
"misc house expenses", but I want to be able to know specifically why I had a
$100 item in column 26, like "new garden hose". How do I do that? Thanks.
 
How about Insert > Comment and enter the item description in the comment.
Mouse over the cell to see the reason for the expenditure.

HTH
Regrds,
Howard
 
=100+N("new garden hose")

100 will be displayed but in formula bar you will see the full text.


Gord Dibben MS Excel MVP
 
And to piggyback on Gord's response...

If you had a formula that returned text, you could use:

="Due date: " & text(a1,"mm/dd/yyyy") & text("a note goes here",";;;")
 
Back
Top