The Excel Addict - Help with Excel 2013, 2010, 2007, 2003
October 22, 2015

Greetings from The Excel Addict
"If you think adventure is dangerous,
try routine; it is lethal.”
-- Paulo Coelho --
If you have a favourite quote, send it to me and I may post it in my newsletter.

Hi fellow Excel Addict,

Francis Hayes (The ExcelAddict) www.TheExcelAddict.com Conception Bay South, Newfoundland, CanadaAfter some unseasonably warm weather here last week, we are finally beginning to feel the effects of fall. With such a short summer season here in Canada, we always wish for the warm weather to stay as long as possible. So I'm hoping to see a few more warm days yet, though it's more likely that I'll have to wait till next spring. And that's such a l-o-o-o-o-n-g wait.

How's the weather where you are? Please send me a photo from where you live.
I love getting emails from my readers.

I hope that you'll find today's tip helpful. Let me know what you think.

Keep on Excelling and don't forget to share these tips with your friends and colleagues.

Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com



If you missed my last newsletter, you can click here to view it online.

You can access even more tips on my website by going to my members' page


LAST DAY TO SAVE 20% on Mynda's Excel Dashboard Course


"I didn’t even know some of those things were possible in Excel!"
WHAT IS A DASHBOARD? Find out here...

HOW DO YOU CREATE A DASHBOARD? Learn how in this FREE 1-hour webinar.
Go here to register...

HOW MUCH DOES MYNDA'S EXCEL DASHBOARD COURSE COST?
Find out here...

EXCELADDICT Bonus E-book
As a bonus for anyone who enrolls in Mynda's Excel Dashboard Course and uses my coupon code EXCELADDICT on the checkout page, you will receive a free copy of my 'Excel in Seconds' e-book when it is released.

Excel Dashboards Webinar by Mynda TreacyExcel Dashboards Course by Mynda Treacy

In the past two years, more than 1,000 Excel Addict
subscribers
have taken Mynda's Dashboard course



Today's Microsoft Excel Tip

Easily Fix Wrapped Text Alignment Problems

You know that when you enter text that is wider than a column, Excel will automatically wrap the text in the cell and
the height of that row adjusts to allow the text to display entirely within the cell. By default, the contents of cells is aligned to the bottom of the cells.

Typically, you expect to see a row's contents aligned along the top. However, I often see reports with wrapped text have the contents of some cells displayed at the bottom of the row while other cells with longer text is wrapped to the top. In my opinion, this doesn't look very professional and makes it harder to read the data.

Wrap Text Alignment Problem in Microsoft Excel 2003, 2007, 2010, 2013, 2016_365
Although, all of the cells are 'aligned' to the bottom, due to Excel's autofitting the row height, the cells with wrapped text appear to be aligned to the top.

However, there is a simple solution to help you avoid this problem AND make your reports look great. All you need to do is change the vertical alignment of all cells in your table to the top.

Here's how...

1. Select all of the cells in your table;

2. On the Home tab, in the Alignment group, click the Top Align command;

3. Click OK.

That's how easy it is to make your workbooks with wrapped text look great.

Wrapped Text Align To Top in Microsoft Excel 2003, 2007, 2010, 2013, 2016_365


Excel Dashboard Course


Thanks for supporting this newsletter and website


Subscription Information: Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter. If this newsletter was forwarded to you and you would like to get your own copy, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com

 If you would like to share this newsletter with others...
1) Share a link to this page
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com
3)  Post a link to TheExcelAddict.com in a company newsletter or website.

Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
"Spreadsheets Tips From An Excel Addict" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630