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.
If 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)
If you missed my last newsletter, you can click here to view it online.
If you have a favourite quote, send it to me and I may post it in my newsletter.
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.
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.
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.
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;
4) Now you will see that the left edge of your footer text is perfectly aligned.
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.
|"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