Excel 2000, 2002, 2003, 2007 Tips

The Excel Addict - Help with Excel 2007

Publication Date: April 21, 2010

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

Greetings from The Excel Addict

Hi fellow Excel Addict,

Francis Hayes (The Excel Addict)A little knowledge digested on a regular basis can make a big difference. One of the most common comments I get about this newsletter is that, although it takes only a few minutes each week to learn these Excel shortcuts and techniques, over time, it can make a profound improvement in one's skill set. As the saying goes, "The difference between ordinary and extraordinary is just that little extra."

Once in a while I get an message from someone who has unsubscribed from my newsletter because "...I don't have time to read your tips". Then I get emails from people like Norma, Leo and Susan.

"Hi Francis, you've been a steady and helpful companion for quite some time and helped me and my team to save a lot of time. Thank you!" -- Norma W.

"Thank you, keep up the good work, your tips are invaluable to me and have helped me with a successful start up business in 2008.  I have utilized your tips and saved countless hrs. figuring it out for myself over the last 2 years. & I do mean countless hrs. Your tips and help have helped me succeed in an economy that many are not. Again THANK YOU!!!!" -- Leo B.

"Thank you very much for your hard work. I have made a promise to myself to take the time to read each weekly tip during 2010. If I can save just a fraction of the time I’m wasting with duplicative work that Excel (or Word) can do for me, I can spend more time with my son. That is a goal worth working toward for me! Best regards" -- Susan  M.

Now, that's the difference between ordinary and extraordinary.

To your SUCCESS !
Francis Hayes (The Excel Addict)

If your 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) Keyboard Shortcut To Select All Objects (XL2000-2007)
2) Quickly Create A Series Of Weekdays (XL2003/XL2007)
3) Use Bcc To Keep Forwarded Email Addresses Safe

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) AutoFill Trick For Data Containing Blanks (XL2000-2007)
2) Remove Hyperlinks In Bulk (XL2003/XL2007)
3) Scroll Wheel Precision

You can still find last week's newsletter here.

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


"Our greatest weakness lies in giving up. The most certain way to succeed is always to try just one more time." -- Thomas Edison

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

Keyboard Shortcut To Select All Objects (XL2000-2007)

When you are working with multiple objects in a worksheet, you often will need to select all of the objects, such as if you want to apply identical formatting to all the objects. I work a lot with textboxes so, in the past, I always used F5, Special, Objects, OK to select them all. I thought that it was a pretty cool trick but I recently discovered an even easier and faster keyboard shortcut to select all objects.

First click on one object, then press CTRL+SHIFT+SPACEBAR to select all other objects

Excel keyboard shortcut to select all objects

Note that if you don't first select an object, this keyboard combination will select the current region surrounding the active cell or the entire worksheet if the active cell is not part of a range of data.

Alternatively, to select objects individually, hold down the Shift key and click on each object.

Pull answers from your lists with these 45 LOOKUP formulas

Microsoft Excel Tip #2

Quickly Create A Series Of Weekdays (XL2003/XL2007)

Easily create a series of weekdays only (excluding weekends)Often in reports you will need to record information for weekdays only (i.e. exclude weekends). You may already know that you can type the name of a day in a cell and when you drag the Fill Handle, Excel will automatically fill in the series of days.

Here's another similar but lesser-known trick that helps you quickly fill in just the weekdays (Monday to Friday) in your cells. You begin by selecting the cell with the day you want to start with. Next, drag the Fill Handle (i.e. bottom right corner of the selected cell) with your RIGHT mouse button to fill the range you need. Release the mouse button and a menu will pop up. Select Fill Weekdays and the range of cells will be filled with just weekdays.

Note that this trick works for both weekday names as text and also for dates. Give it a try!

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

Use Bcc To Keep Forwarded Email Addresses Safe

How often do you receive emails from friends, such as jokes or videos, that have dozens or maybe even hundreds of other people's email address listed, who were also forwarded the same message?

If you like the joke or video, you may decide to send it to all of your friends and family. Many of them will do the same. Now your email address and everyone else's has been broadcasted all over the Internet. Did you ever think that these emails may sometimes end up in the Inbox of an email spammer? Not only will the spammer put all these addresses in his database for sending you junk mail, he will also likely sell his list of email addresses to other spammers. The result is everyone begins receiving hundreds of unwanted junk emails.

Do yourself and your friends a big favour. Whenever you want to forward a message to a group of people, (1) add the email addresses to the BCC (blind carbon copy) field of your email message and (2) delete any email addresses in the body of the email. Names entered in the BCC field are not visible to the other recipients of the email.

Use BCC field to hide email addresses

Many email programs, by default, don't show the BCC field. For example, if you are using Outlook 2007 and the BCC field isn't shown, open a new message, click the Options tab and in the Fields group, click Show Bcc. In Outlook 2002-2003, create a new message and do one of the following: If you are using Word as your e-mail editor, on the toolbar, click the drop-down arrow to the right of the Options button, and click Bcc. If you are using Outlook as your e-mail editor, on the View menu, click Bcc Field.

If you use a different email program you may have to check its Help menu.

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