show bottom portion of information in a fixed cell

[sbybee]

I've been digging, and I don't think Excel can do this.
Show me I'm wrong.

I want to align text in a cell so that it always shows the bottom information.
A lot of people do this - set up a spread sheet to show action item status entries by date. Typcially newer entries are added to the bottom of the list. But once the information size exceeds the cell size then you loose - or don't see the newest entries.
> increasing the cell size is not an option. Neither is merging cells.
> adding a scrolling text box is very awkward because I can't type text directly into the box field.

I suspect it has something to do with the fact that the verticle sizing of a row is from the bottom perimeter line.

Unless there is some way of doing this (Excel 2010), my only option is to reverse order my entries - meaning I have to alt-enter a NL at the top of the cell and add my info w/ newest entries at the beginning.

 

[shg]

Show me I'm wrong.

You're right -- Excel won't do that.

 

[sbybee]

Thought so, but needed to make sure.
Thanks for your time.

 

[Rick Rothstein]

Thought so, but needed to make sure.
Thanks for your time.

To save you the trouble involved in manually doing the Alt+Enter and possibly screwing it up, just enter your values in the correct order and use this macro (which you can assign to a shortcut keystroke to simplify things) to reverse the list for you...

Sub ReverseListOrder()
  Dim X As Long, Temp As String, Cell As Range, Lines() As String
  For Each Cell In Selection
    Lines = Split(Cell.Value, vbLf)
    Temp = ""
    For X = UBound(Lines) To 0 Step -1
      Temp = Temp & vbLf & Lines(X)
    Next
    Cell.Value = Mid(Temp, 2)
  Next
End Sub

Note: This code can act on a range of cells rather than a single cell if that would be more convenient for you, just select one or more cells and run the macro to reverse the list in each cell. If you ever want to put the list back in "correct" order, just run the macro against the cell(s) again.

 

[sbybee]

I love gadget code.
Thanks much for the gift.
Cheers

 

[moby]

I know this is an old thread, but I am wondering if the original posters question is possible in newer versions of Excel.

 

[elliecaitlin]

Thanks Rick, 7 years down the line and your Macro is still of great help to me.