Compiling Notes

A

Araqnid78

My speadsheet is configured as follows: columns are milestones and rows are
individual records. I want to be able to periodically add a note to a record
(there is one cell at the end of each row for this now), without overwriting
the previous note, i.e., keep a running list of notes (maybe in a drop
down-type format)?
 
J

Jim Rech

A cell can contain just one entry. You might just add to the existing
note(s). I'd do it like this:

-Press F2 to go into Edit mode.
-Press Alt-Enter once to start a new line (or twice to have an empty row
between each addition.
-Type new note.

If the row height expands to show all of the notes you might want to
manually adjust the row height. Excel will then keep this row height even
when new text is entered. If you subsequently select the cell you'll see
all the notes in the formula bar (subject to the size of the Excel window).

--
Jim

| My speadsheet is configured as follows: columns are milestones and rows
are
| individual records. I want to be able to periodically add a note to a
record
| (there is one cell at the end of each row for this now), without
overwriting
| the previous note, i.e., keep a running list of notes (maybe in a drop
| down-type format)?
| --
| P Walsh
 
Top