I hope you enjoyed last weeks tips on right-clicking with your keyboard, moving around a selected range of cells, and disabling that annoying image toolbar in Internet Explorer 6.

Every week I get emails from readers who suggest alternate ways of accomplishing my tips. The great thing about Excel is that there is usually several ways of doing everything. You just need to find the one(s) that you like and use that. Sometimes someone will tell me a different, and sometimes better, way of doing something that I have been doing 'my way' for years.

I appreciate all your emails and suggestions.

Have a great week and keep on Excelling.

To your success,
Francis J Hayes (The Excel Addict)

P.S. VERY IMPORTANT Please remember to include "TheExcelAddict" in the Subject line of any email you send me. This will help it stand out in the flood of junk email I have been receiving lately.

I need your help. Will you help me reach my goal? As you know, I really love using Excel and sharing my tips with everyone who could use them. My goal is to have my weekly tips going out to 4,000 readers by the end of this year. And I would really appreciate it if you could help me reach my goal by sharing this newsletter with all of your 'Excel-loving' friends and colleagues. You will be helping me and also everyone you share my tips with. Thanks in advance for your support.

DISCOVER NEWFOUNDLAND AND LABRADOR, CANADA:
This is where I grew up: http://www.brigus.net/
This is where I now live: http://www.conceptionbaysouth.ca/
This is my beautiful province: http://www.gov.nf.ca/tourism/

If you are using Excel 2003 and get annoyed by that Paste Options button that pops up on the screen every time you paste something, you can easily turn it off.

Click Tools, Options and click the Edit tab. Now clear the Show Paste Options buttons check box.

Poof! It's gone.

Mark Victor Hansen, author of the mega best-selling 'Chicken Soup' book series wants to help you. Sign up for his weekly 'Rich Results' subscription. It’s absolutely free, no strings attached.

Excel's default setting for sorting is by row. However, sometime you may want to sort by column instead. Here's how...

1. Select the range of data you want to sort.
2. From the menu select Data, Sort
3. The first Sort by option uses the first row by default, however, you can sort by any row in the selection.
4. Click the Options button
5. From the Sort Options dialog, select Sort Left To Right and click OK
6. Choose Ascending or Descending
7. Click OK

Another important thing to remember about sorting is, if you have a range of cells selected, Excel will sort only the data in those selected cells. You can allow Excel to select the sort range by selecting only one cell anywhere in that range. Excel will expand the sort range to all cells in the current region (bounded by blank columns and rows or the edges of the worksheet). To be sure that you sort only the range you want, I suggest that you select the sort range yourself.

There are tens of millions of other Microsoft Excel users all over the world. The vast majority of them have a very limited knowledge of Excel's capabilities. My goal is to share this information with everyone I possibly can and help them to benefit from Excel's amazing capabilities.

Please help me spread the word about my newsletter. If you know other Excel users, please tell them about "Spreadsheet Tips From An Excel Addict". I know they'll appreciate it.

Maybe you know someone who supervises or employs many Excel users. That's where your referral could have a big impact.

VERY IMPORTANT: Please refer only people you know personally, who use Microsoft Excel and would benefit from this newsletter.

CTRL+A is the shortcut, in many programs, for the Select All option. Anytime you need to select everything (i.e. text, graphics, files, email messages, etc...) in a program (i.e. Word, Excel, Windows Explorer, Internet Explorer, email folder, etc...), try pressing CTRL+A.