Excel 2000, 2002, 2003, 2007 Tips

The Excel Addict - Help with Excel 2007

Publication Date: May 26, 2010

This newsletter is being sent to 16,000+ Excel 'addicts' around the world
using Aweber, the best solution for managing your email campaigns.  

If you having trouble displaying graphics in this email, I have
posted an online HTML version of this week's newsletter here.

Greetings from The Excel Addict

Hi fellow Excel Addict,

Francis Hayes (The Excel Addict)Thanks for joining me for another batch of tips that (I hope) will make you more productive from this day forward.

You know, that's what I love about investing a little time right now to learn new things that I know will pay me back many times over through increased productivity long into the future. Surprisingly, and sadly, many people just never see this logic.

Just today I helped a co-worker reduce a 4-hour per month manual task updating her Excel workbook down to less than 2 minutes. I have been offering to do this for years but 'she didn't have the time for me to show her my way'. It took me about 45 minutes to set it up and show her and now she will save 4 hours every month forever.

Please take the time to learn these tips. I guarantee that it will be time well spent.

To your SUCCESS !
Francis Hayes (The Excel Addict)

If you want to send me an email...

• Please type 'The Excel Addict' in the Subject field of your emails.
• If you reply to this email, please delete the newsletter content before Sending.
• Remove background color in Outlook 2007 - Options, Page Color, No Color.

View The Excel Addict Francis J Hayes's profile on LinkedIn   Find out what The Excel Addict is doing NOW

This week's tips..

1) Prevent Active Cell From Moving After Input  (XL2000-XL2007)
2) Create An Email Message From Excel With One Click (XL2003/XL2007)
3) Scrolling Back Through History

If you're having trouble displaying graphics in this email, I have posted an online HTML version of this week's newsletter here.

Last week's tips were...

1) Quickly Convert Dates To Numbers Or Numbers To Dates (XL2000-XL2007)
2) Sort Dates By Month And Day (Ignoring Year) (XL2003/XL2007)
3) Definitions By Google

You can still find last week's newsletter here.

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


"Give advice; if people don't listen, let adversity teach them" -- Ethiopian Proverb

CAUTION: Make sure you save a copy of your spreadsheet before trying these tips,
just in
case you make an error or the procedure doesn't produce the results you want.

Microsoft Excel Tip #1

Prevent Active Cell From Moving After Input  (XL2000-XL2007)

Have you ever entered various values in the same cell to see how the results affect formula results in other cells? Of course you have.

If you are using Excel's defaults, whenever you type a value in a cell and press Enter, the Active Cell moves down to the next row. You then need to move back up to the cell to enter the next value. If you need to repeat this multiple times, it can get a little annoying.

An easy trick to prevent the Active Cell from moving after you enter a value is to hold down the CTRL key when you press Enter.

Note, you will get the same result (i.e. Active Cell not moving) by clicking the check mark in the Formula Bar after you have typed a new value.

Microsoft Excel Tip #2

Create An Email Message From Excel With One Click (XL2003/XL2007)

http://www.theexceladdict.com/images/email1_sm.jpgIn a earlier newsletter I shared a ‘Non-Excel Tip’ for how you could quickly open a new email message by typing mailto: and an email address in the Start>Run dialog. Maybe there are times when you regularly send short email messages relating to a report in an Excel workbook.

Rather than having to open your email program, type an email address, type a subject and then type the message, what if Excel could automatically create this email message for you in one click?

You may be familiar with Hyperlinks in Excel (I’ve shared several tips in past newsletters). You may also have noticed that if you type an email address in Excel, a hyperlink is automatically created. If you click that hyperlink, your email program opens with a new blank message to the hyperlinked address.

But what most Excel users are unaware of is that email hyperlinks in Excel can be made much more useful with a little extra planning. Yes, you can even have a hyperlink that creates a complete (relatively short) email message – ready to send.

Let’s use a hypothetical situation to illustrate. Assume you have a workbook which you report on to your boss every month with an email telling him that revenues are on plan.

Here’s how…

1) Right-click on the a cell and select Hyperlink to open the Insert Hyperlink dialog;

2) In the Text To Display field, enter the text you want to display in the worksheet cell containing the link;

3) Click the E-Mail Address option in the Link To area (on the left);

4) In the E-Mail Address field, type the email address;

5) In the Subject field, type a subject line for your email;

6) Immediately after the text you typed for the subject (in the Subject field), type &body= and the message you want in the body of your message. 

Note that the maximum number of characters Excel allows in a hyperlink is 255. Therefore, the length of your body text message will be limited to 255 minus the number of characters you have typed for your email address, subject, and also the words 'mailto:', '?subject=', and '&body='. In the graphic below, we will have approximately 198 characters available for the message in the email body.

7) Click OK.

Create an email message from Excel with one click (no VBA)

BONUS TIP: For another closely related, non-VBA, email hyperlink option that allows you to pull data from your worksheet into the Address, Subject and Body of an email, right-click to download this sample workbook.

Right click to download this sample workbook that shows you how to use the HYPERLINK function to create an email message from Excel containing worksheet data in one click

101 Excel Tips revealed in this book
Microsoft Excel 2000 - 2003

Try out the secrets in my ebook for two months. If they don't save you 10 times the price of the book...

If you're not 100% satisfied...

...simply request a full refund from ClickBank.com

There's absolutely no risk to you.

Non-Excel Tip

Scrolling Back Through History

Use the scroll wheen to browse through web pagesIf you hold down the Shift key while turning the scroll wheel on your mouse, you can page back and forward through the web pages you have viewed in the current session.

While you're at it, try holding down the CTRL key and while turning the scroll wheel and you'll find that you can zoom in and out on the page. This comes in handy when your eyesight isn't as good as it once was.

P.S. If you don't have a scroll mouse, invest in one. I never used one until about three years ago and now, I can't function properly without a scroll wheel.


My goal: To reach One Million Excel Users

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(DOT)com

If you would like to share this newsletter with others...

1) Forward this newsletter by email, but first delete the unsubscribe link at the very bottom so you don't get accidentally unsubscribed

2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber(DOT)com

3)  Post a link to TheExcelAddict.com in a company newsletter or website
"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