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

[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.

 

[L. Howard Kittle]

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

 

[Gary''s Student]

Right click the cell and pick Insert Comment

 

[Gord Dibben]

=100+N("new garden hose")

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


Gord Dibben MS Excel MVP

 

[Dave Peterson]

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",";;;")