If you have a favourite quote, send it to me and I may post it in my newsletter.
Hi fellow Excel Addict,
After 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)
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.
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.
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.
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.
|"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