Excel 2010 - Text not aligning at bottom of cell!

I specified text to align in the bottom of the cell but it's not doing it.
(See graphic).
I chose align bottom (see button) but it's not happening.
How to fix?
err
brothertruffle880Asked:
Who is Participating?
 
Martin LissConnect With a Mentor Older than dirtCommented:
Here's an easy way to tell. Add this macro to a module and run it.
Sub LineFeeds()
Dim rngAddress As Range
Set rngAddress = Application.InputBox(prompt:="Which cell do you want to check?", Type:=8)

If Len(rngAddress.Value) > Len(Replace(rngAddress.Value, vbLf, "")) Then
    MsgBox "Cell contains " & Len(rngAddress.Value) - Len(Replace(rngAddress.Value, vbLf, "")) & " line feeds"
End If

If Len(rngAddress.Value) > Len(Replace(rngAddress.Value, vbCrLf, "")) Then
    MsgBox "Cell contains " & Len(rngAddress.Value) - Len(Replace(rngAddress.Value, vbCrLf, "")) & " carriage return line feeds"
End If

End Sub

Open in new window

0
 
Martin LissOlder than dirtCommented:
Do you possibly have things like line feeds at the end of the text?
0
 
D PatelD Patel, Software EngineerCommented:
Adjust the cell height and width to fit the contents. They try.

D Patel
0
 
brothertruffle880Author Commented:
Thanks Martin!  Perfect.
0
 
Martin LissOlder than dirtCommented:
You're welcome and I'm glad I was able to help.

If you expand the “Full Biography” section of my profile you'll find links to some articles I've written that may interest you.

Marty - Microsoft MVP 2009 to 2016
              Experts Exchange MVE 2015
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2015
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.