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

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 can I attach an explanatory note to a data cell?
 

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

"Grant" wrote in message
...
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 can I attach an explanatory note to a data cell?
 

Right click the cell and pick Insert Comment
--
Gary''s Student - gsnu200908


"Grant" wrote:

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 can I attach an explanatory note to a data cell?
 

=100+N("new garden hose")

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


Gord Dibben MS Excel MVP


On Sun, 8 Nov 2009 14:41:01 -0800, Grant
wrote:

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 can I attach an explanatory note to a data cell?
 

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



Gord Dibben wrote:

=100+N("new garden hose")

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

Gord Dibben MS Excel MVP

On Sun, 8 Nov 2009 14:41:01 -0800, Grant
wrote:

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.

--

Dave Peterson