If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|