+ Reply to Thread
Results 1 to 10 of 10

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

  1. #1
    Registered User
    Join Date
    04-17-2019
    Location
    USA
    MS-Off Ver
    10
    Posts
    5

    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!

  2. #2
    Forum Expert
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    2013
    Posts
    3,490

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

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

  3. #3
    Registered User
    Join Date
    04-17-2019
    Location
    USA
    MS-Off Ver
    10
    Posts
    5

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

    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

  4. #4
    Forum Expert
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    2013
    Posts
    3,490

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

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

  5. #5
    Registered User
    Join Date
    04-17-2019
    Location
    USA
    MS-Off Ver
    10
    Posts
    5

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

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

  6. #6
    Forum Expert
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    2013
    Posts
    3,490

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

    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

  7. #7
    Registered User
    Join Date
    04-17-2019
    Location
    USA
    MS-Off Ver
    10
    Posts
    5

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

    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?

  8. #8
    Forum Expert
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    2013
    Posts
    3,490

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

    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.

  9. #9
    Registered User
    Join Date
    04-17-2019
    Location
    USA
    MS-Off Ver
    10
    Posts
    5

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

    That was it!

    Thank You, Thank You, Thank You!!

  10. #10
    Forum Expert
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    2013
    Posts
    3,490

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

    You're welcome & thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1