Issue with Cell alignment - need only the last line in cell to sho
 

This might be a strange question, and what I'm doing might be totally silly,
but I need to know how to make it so that only the last few lines in my cell
show, as opposed to any of the content before it.

I have a regular, plain old, average Joe spreadsheet. In one of the
columns, I am keeping a line-by-line "log" of events that happen with certain
items in my list. For example, one cell will read:

"5/12/07: Followed up with so-and-so, left message, waiting for a return
call;
5/13/07: Received call back from so-and-so, was informed of this and that;
5/13/07: Sent complete order request to so-and-so;
5/24/07: Project complete, waiting on paperwork from so-and-so."

Currently, Excel shows somewhere around the middle of the text, but that's
not useful to me. I just want the last two lines to show, so resizing isn't
an option. I want the rest to be visible only when I double click on the
cell.

I have toyed around with cell alignment properties and nothing fixes it,
even if I align everything to the bottom. I suspect it has something to do
with how Excel displays data in a cell, and I would like to change that. Any
help would be SO appreciated.

Issue with Cell alignment - need only the last line in cell to sho
 

Hi

Maybe in another column, take the last "x" characters of the text e.g.
=RIGHT(B1,20)
Format this cell as wrap text


--
Regards

Roger Govier


"CamanoMouse" wrote in message
...
This might be a strange question, and what I'm doing might be totally
silly,
but I need to know how to make it so that only the last few lines in
my cell
show, as opposed to any of the content before it.

I have a regular, plain old, average Joe spreadsheet. In one of the
columns, I am keeping a line-by-line "log" of events that happen with
certain
items in my list. For example, one cell will read:

"5/12/07: Followed up with so-and-so, left message, waiting for a
return
call;
5/13/07: Received call back from so-and-so, was informed of this and
that;
5/13/07: Sent complete order request to so-and-so;
5/24/07: Project complete, waiting on paperwork from so-and-so."

Currently, Excel shows somewhere around the middle of the text, but
that's
not useful to me. I just want the last two lines to show, so resizing
isn't
an option. I want the rest to be visible only when I double click on
the
cell.

I have toyed around with cell alignment properties and nothing fixes
it,
even if I align everything to the bottom. I suspect it has something
to do
with how Excel displays data in a cell, and I would like to change
that. Any
help would be SO appreciated.