Aug 29 2005
Q: Is there a way to move to the last cell in a spreadsheet?  I work with several spreadsheets that are quite lengthy and I usually overshoot the end when trying to scroll using the mouse.
A: Yes.  Here's how:

Move to the bottom of a spreadsheet by:
Press CTRL + END at the same time
-This actually places you at the last cell in your spreadsheet - at the bottom most right cell

Move to the top of a spreadsheet by:
Press CTRL + HOME at the same time
This moves you to the most upper left cell in your spreadsheet - usually to cell A1

August 8 2005
Q: I use ACT! to manage the contacts for my business.  When someone calls that is in my ACT! database I usually record the conversation as a Note, but I know this isn't the best way to do it.  How can I quickly record the phone call in this situation?
A: Recording a phone call as a Call and not a Note is a better practice when using ACT!.  In addition to having your Calls saved in the Notes section (ACT 2005 & 2006) it also won't update the Contact Record System Fields - making contact management a more difficult.   You can record your in-bound phone calls as Calls very easily by:

In ACT!:
1. Find the Contact in your Database
2. Contact > Record History...
-Under ‘Activity type:’
3. Select 'Call'
4. Enter any details relevant to the call.  Perhaps include a reminder to follow-up.
That's it!

August 1 2005
Q: When working on spreadsheets I sometimes want to get a quick total of several cells without inserting a formula, Is there a way to do this?
A: Yes.  Here's how:

1. Click on the first cell

2. Hold down the CTRL key on your keyboard

3. Click on the next cell

The total is displayed in the lower center of the Excel Status Window as ‘Sum=X’.  You can also use the SHIFT key to select adjacent cells.  Just click on another cell to cancel the summary.

August 22 2005
Q: Does Microsoft Office update as part of the Automatic Updates sent to Windows XP?
A: Microsoft Office does not automatically update.
You have to do this manually.  Here's how:

1. Go to the Microsoft website: http://office.microsoft.com/en-us/officeupdate/default.aspx
-Under the 'Office Update' section
2. Click 'Check for Updates'
Note: You may be asked to insert your Microsoft Office CD so be sure you have it handy before you start this process.