FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

The Excel Addict - Help with Excel 2013, 2010, 2007, 2003
August 25, 2016
 

Greetings from The Excel Addict
Hi fellow Excel Addict,

Thanks for joining me today for my 'Excel in Minutes' tip.

Sorry. I'm a little late again due to my earlier technical difficulties.

Earlier this week the Canadian Forces Snowbirds performed an air show here in Conception Bay South. There's a link below to one of my videos on YouTube if you're interested.

I hope you find today's tip useful. Please feel free to share it with your friends—chances are they will too.

I
f you missed my 'Excel in Seconds' newsletter from Tuesday, I showed how to 'Resize the Filter Dialog to Display Long Text Values'. You can read the tip here.

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

Francis Hayes - TheExcelAddict.com


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


 
TheExcelAddict.com Quote of the Day

"Don’t try to stand out from the crowd;
avoid crowds all together."

-- Hugh McCloud --

If you have a favourite quote, send it to me and I may post it in my newsletter.

Today's Microsoft Excel Tip

Left Align Text In Your Right Header or Footer

A reader asked me if there is a way to left-align text in his right header.  As you will notice, when you enter a right header or footer, the text is right-aligned by default so when you enter multiple lines, the left edge of the text does not line up. Unfortunately there are no alignment options for headers and footers.

One option you may consider would be to add 'padding' spaces to the right of the text.

Although you can add spaces to the left of the text in your left header/footer, when you add spaces to the right of the text in your right header/footer they are ignored.

Right Aligned Right Footer in Microsoft Excel 2007 2010 2013 2016 365
Let's say for example that you want to put your name address in the right footer and you want to have the left edge of the text lined up.

Align Header / Footer Text To Left in Microsoft Excel 2007 2010 2013 2016 365
There is no obvious way to do this so we'll need to play a trick on Excel by insert characters to the right of the footer text and format those characters with a white font color.

This solution works best if you format your footer text with a mono-spaced font such as Courier New.

Here's how to align the right footer text to the left...

1) Type a character (such as a dash) at the end of each footer line until it aligns with the longest line of text;

2) Now, for each line of text in the footer, drag to select the dashes. If you are working in the HEADER & FOOTER TOOLS/DESIGN tab, a text formatting menu should pop up from which you can choose the white font color.

White Font Characters In Header Footer Will Be Invisible in Microsoft Excel 2007 2010 2013 2016 365

If you are creating your footer using the Page Setup dialog, drag to select the dashes, then click the Font tool (the one with the A) and choose a white font color;

White Font Characters In Header Footer Will Be Invisible Page Setup in Microsoft Excel 2007 2010 2013 2016 365
4) Now you will see that the left edge of your footer text is perfectly aligned.

Align Left Edge Of Header Or Footer Text in Microsoft Excel 2007 2010 2013 2016 365
Another option would be to create an image of the left-aligned text for your footer (or header) but I think the above solution is easier and faster to implement.


FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

Thanks for supporting this newsletter and 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. 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 you will get your money...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