Last Alt-Ent text to read in cell as opposed to the first text line entered?

Hi,

I'm trying to format cells to show the last text entered as opposed to the first entered text. So, if you were to enter information on 4/16 in a cell, then Alt-ent for a new line on 4/17, the bottom of the cell will show instead of the top. Is that possible?

Thanks!

Hi & welcome to the board.
Select cell format > Alignment > In Vertical select "Bottom"

Thank You!!

I have it set up that way already though?? I still shows the first entry and aligns that entry to the bottom while still hiding the last alt-ent entry. I'm looking for the last bottom alt-ent text to align to the bottom of the cell and the initial first test to hide? Is that possible?

Thanks Again

It works for me, so not sure why it's not working for you.

Maybe it's a different version? Thanks Though!!

Think I've figured it out.
It works if the row height is slightly larger then autofit.
With autofit height at 12.75, if the row height is changed to 13.5 it works

I'm sorry I'm retarded, but what is autofit? Is that the...[Height: XX.XX (XX Pixels]? Is it when you want to change the size of the row or column?

For more about AutoFit look here https://www.ablebits.com/office-addi...-columns-rows/

But if you increase the height of the row by 1 pixel, then hopefully you will get the desired effect.

That was it!

Thank You, Thank You, Thank You!!

You're welcome & thanks for the feedback