It's great to find so many people from all around the world who are eager to discover the many hidden treasures of Excel. After more than 10 years, I'm still discovering exciting things about Excel. I'm sure, by now, you too are starting to realize that there is virtually no end to Excel's capabilities.

A couple of weeks ago I told you I was planning on switching this newsletter to an HTML version. After consulting with some other newsletter editors, I have learned that, due to the widespread use of email/spam filters by most Internet Service Providers and email services, HTML email has an even higher likelihood of being stopped by these filters.

I don't want to risk not having my newsletter delivered to you so I will continue sending my newsletter in plain text format, with an online HTML version available to you on my website. As time permits, I will be adding more practice files to my website over the coming weeks.

If you have any suggestions that would help me deliver a better service to you, please let me know.

Till next week, 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.

Will you help me reach my goal? As you know, I really love using Excel and sharing my tips with everyone who can benefit from 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. Go ahead, email this newsletter right now to three people you know who use Excel. 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 frequently use cell Comments in Excel, I'm sure you've experienced trying to edit a comment only to have it hide away on you whenever you click away from the comment, such as when you need to check some information in another part of the worksheet that is out of view as you are working on the comment.

If you want to keep the Comment in view until YOU decide you are finished with it, simply right-click on the cell containing the Comment and select Show Comment. It will stay visible whether you are editing it or not. When you are done editing your comment, right-click the cell again and select Hide Comment.

Sometimes you may have a worksheet that has two or more distinct sections. For example, one section may be smaller and have fewer columns than another section. Normally you would be forced to print both of these sections using the same print settings.

Maybe one section you want printed as Portrait and the other you want printed as Landscape. Often people will resort to printing one section, changing the print settings for the second section, printing the second section, and then changing back the settings for the first section. Fortunately for you (and unfortunately for Excel users who aren't reading this tip), Excel has a Custom Views option that few users know about.

1. Set up the first section of your worksheet the way you want it to look (selected cells, cells in view, hidden rows/columns, etc...) and print (i.e. Page Setup settings including the Print Area).
2. Now that you have this section set up as you want it, you will name this as a Custom View. On the View menu, click Custom Views..., and click the Add... button.
3. In the Name box, type a name for the view. If you will be creating Custom Views in more than one sheet, it is good practice to include the sheet name in the Custom View name.
4. You will notice that you can choose to include the print settings and the hidden rows/columns and filter settings. Uncheck the boxes for any settings you don't want saved with the View.
5. Click OK
6. Repeat steps 1 to 6 for each Custom View you want to create.

To delete a View, select View, Custom Views..., select the view from the list and click Delete.

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. Go ahead, email this newsletter right now to three people you know who use Excel.

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.

Most people know that when you delete a file in Windows it goes into the Recycle Bin. But there may be times when you really want to delete the file so that someone else with access to your computer cannot just go to the Recycle Bin, restore the file and view it. Maybe its a sensitive file that you want gone.

You could right-click on the Recycle Bin icon and empty it, but there is a way to have a file deleted without having it go into the recycle bin. Simply hold down the Shift key when you delete a file.

A word of caution: When you delete a file in this manner, IT IS GONE. If you accidentally delete the wrong file IT IS GONE. Make sure, when you delete a file in this way, that you have the right file. Believe me, I learned this the hard way.