Bottom align the text in a cell with wrap text turned on?

[bacon4life]

Is there a way to have Excel bottom align the text in a cell with wrap text turned on? When I change the alignment in a cell with wrap turned, the text location only changes by the height of a single row of text rather than aligning the last row of text to the bottom of the cell.

The screenshot below shows an example where both wrap text and bottom align are turned on, but the text is not actually bottom aligned. I the lower row, I turned off word wrap and the alignment then goes to the bottom.

 

[pmover]

the row height needs to be increased to show "first row" and "fifth row". do this manually.

 

[davidbeach]

If you double click on the column and row dividers to get the best fit, what you'll find is that it gets sized for how excel thinks it will print rather than making it show correctly on the display.

I’ll see your silver lining and raise you two black clouds. - Protection Operations

 

[bacon4life]

I am only interested in the last lines of text, and just want the first several lines hidden by turning on bottom align. Some of the cells contain lots of text, so reformatting the row height would make it so I can only see 1-3 rows at a time.