Hi Fellow Excel Addict,

I want to wish you a very merry Christmas and a happy, safe and prosperous New Year. It has been a privilege for me to share my tips with you. If you have gotten some benefit from them, that makes it all worthwhile for me. My goal from the beginning was to share my Excel knowledge and experience with as many other Excel users as possible.

For the next two weeks, I will be taking a break from publishing this newsletter and will be starting up again around January 7th.

I will be celebrating Christmas with my wife and two teenage daughters and will also be spending some time with my elderly parents. Again, I wish you and your family a happy and safe Christmas.

Be safe and I'll see you in two weeks.

Have a great week.

To Your Success!
Francis Hayes (The Excel Addict)

Hold down the ALT key and press 0162.

Using ALT+0162 is OK for use in text, however, formatting your numbers to display the cents symbol is a little more involved. I do promise to show you that trick in a future tip.

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 t-shirt 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.

If you use the 'Tell A Friend' link at www.TheExcelAddict.com you could win $10,000 and you will also qualify for my t-shirt draw.

*** Each monthly winner will be notified by email and will have 10 days to reply with a shipping address. If I don't receive a reply within 10 days, another name will be drawn.

T-Shirt Contest Winners
October September August July June	Apollo Tigalo, Angeles City, Philippines Jim Henderson, California, USA Beki Chambers, Indiana, USA Keith Bannister, North Carolina, USA Lisa Hobbs, Pennsylvania, USA

Do you create worksheets for other users to input information?

Wouldn't it be cool if you could set up a worksheet so that when they enter information in one input cell they could quickly jump to the next input cell?

You can do this fairly easily with Excel.

Basically what you do is unlock all of the input cells and protect the sheet. Then, instead of pressing Enter after you input data, you press the Tab key and you will automatically jump to the next input cell. By default, all cells in a worksheet are locked. Locked cells prevent users from inputting data or making changes to them, however, unless the worksheet is protected locking or unlocking cells has no effect.

Here's how to do it ... it's really pretty straight forward.

1. First, select all of the cells you want the user to input data into by holding down the CTRL key while selecting each cell.
2. Since all worksheet cells in Excel are locked by default, you need to unlock just the input cells. With the input cells still selected choose Format, Cells, click the Protection tab, uncheck the Locked option and click OK.
3. Now you need to protect the sheet by selecting Tools, Protection, Protect Sheet, OK.

One thing to keep in mind when designing your input sheet is that, as the user tabs through the (unprotected) input cells, the active cell moves across the row to the next unlocked cell and then down to the next row containing unlocked cells.

Locking cells doesn't prevent a user from selecting them, only making changes to them. However if you have Excel 2002, you can prevent the user from selecting locked cells by removing the check mark from 'Select locked cells' on the Protection tab in Step 2 above.

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.

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.

I use most of these shortcuts every day and now they are second nature to me. When I stop to think about it, I believe they save me a tremendous amount of time.

With a little practice you will be manipulating your text documents like an expert.

Try them. You'll soon understand what I mean.

Cursor Shortcuts:

• CTRL + Home will take you to the top of the document.

• CTRL + Home will take you to the end of the document.

• CTRL + Right Arrow will move the cursor one word to the right.

• CTRL + Left Arrow will move the cursor one word to the left.

• CTRL + Backspace will delete an entire word.

• CTRL + Shift + Home will select all text between the cursor and the top of the document.

• CTRL + Shift + End will select all text between the cursor and the end of the document.

• Shift + Home will select all of the text between the current cursor position and the beginning of current line.

• Shift + End will select all of the text between the current cursor position and the beginning of current line.

Using various combinations of the above shortcuts in addition to the Up Arrow and Down Arrow will have you zipping around and editing your text documents like a pro.