Hi Fellow Excel Addict,

After all the great weather we had here in Newfoundland last week we almost got nailed by Hurricane Kate today. Luckily it missed us and we just got some heavy rain.

There are Excel users from all over the world reading this newsletter today. I'm sure there are many interesting stories in the various things we use Excel for. I would like get to know your Excel background a little better. Please share your story with me at francis@TheExcelAddict.com

Have a great week.

To Your Success!
Francis Hayes (The Excel Addict)

To print these headings for a particular worksheet, select File, Page Setup, click on the Sheet tab, select the Row And Column Headings check box, and click OK. Note that this setting applies only to the current worksheet.

If you subscribed to this newsletter prior to this current month, you can still get your name in for the draw each month by helping me share this newsletter.

All you have to do each month is click here to recommend my newsletter and website to a friend. For each person that you refer, your name will go into the draw. The more Excel friends you refer, the more chances you have of winning a t-shirt. But please, recommend it only to people you know and who are Microsoft Excel users.

• You could select each row, one by one, and delete them individually. If you have dozens or hundreds of rows, this could be time consuming.
• You could sort the rows alphabetically, which would put all the blank rows together, and then delete that group of blank rows. However, there will be times when you may want to maintain the order of your list, so this would not be an option.
• You could filter the list for blanks, select these rows (i.e. visible cells) and delete them.
• You could use a little-known shortcut to quickly select the blanks in your list and delete them.

This week I will cover option number 4 and next week I will cover option number 3. The first two are self-explanitory and usually are not your best choice, so I won't discuss those.

Suppose you receive a list of data that contains blank rows that you want to remove without affecting the order of the list. This technique will allow you to delete all rows that have blank cells in a particular column. Here's the fastest way to do it.

1. First, before you make any drastic changes to any workbook always make sure you have a backup copy or a recently saved copy in case you need to restore the original data .
2. Now, select the cells in one column from the top of your list to the bottom.
3. Make sure that all the blank cells in this selected range are the rows you want to delete.
4. Select Edit, Goto (or press F5).
5. Click the Special button.
6. Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected.
7. Now choose Edit, Delete, select the Entire Row option and click OK.

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'm sure they'll appreciate it.

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

We are all familiar with navigating the Internet using Internet Explorer's Back and Forward buttons on our browser. Some of us have even discovered that if your press the Backspace key on your keyboard it will work the same as the browser's Back button. But here's a great keyboard shortcut that I just recently discovered and I find it great for moving back and forth through the pages I've already visited when I'm in 'keyboard mode.'.

To move Back, hold down the ALT key while pressing the left arrow on your keyboard. To move Forward press ALT + right arrow.