Solved

Excel 2010 - Text not aligning at bottom of cell!

Posted on 2016-11-18
5
17 Views
Last Modified: 2016-11-19
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
0
Comment
Question by:brothertruffle880
  • 3
5 Comments
 
LVL 45

Expert Comment

by:Martin Liss
ID: 41893841
Do you possibly have things like line feeds at the end of the text?
0
 
LVL 45

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 41893849
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
 
LVL 5

Expert Comment

by:D Patel
ID: 41893973
Adjust the cell height and width to fit the contents. They try.

D Patel
0
 

Author Comment

by:brothertruffle880
ID: 41894417
Thanks Martin!  Perfect.
0
 
LVL 45

Expert Comment

by:Martin Liss
ID: 41894425
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

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Redacting a row in Excel based on a term. 17 36
Add macros on Open 9 32
Cells protection in Excel 7 22
excel time calculation 11 28
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now