The 5 Minute Bulletin Board
Here's Your Tip of the Week!
' X ' Marks the Spot...
 
Let's take care of a bit of housekeeping first...
 
If you don't see some beautiful autumn leaves going down the left side of this email, please scroll up to the top of your email and if it says, 'Having trouble viewing this email? Click Here', click there and they should appear in a few seconds. 
 
Okay now, back to business.
 
In MS Excel, when you need to carry a number all the way down a column  - or across a row - there's a simple way to do this.
 
Click on the cell you want to copy. A tiny little 'x' will appear in the bottom right corner when you hover in that area with your mouse.
 
Grab and drag that across the cells you want to populate. It's that easy.
 
A simple application for use with this is to create a column of consecutive dates.
 
Highlight the first three cells (with the dates typed in) and repeat the above process.
 
You will only have access to one 'x' at the bottom of the group of cells you chose, not three of them.
 
Once you drag down, the program 'knows' to keep inserting consecutive dates for you.
 
It's a simple and very handy tool to know.
 
"X" truly marks the spot.
To your home office / small office business success, 
Signature
Tiiu Garrett
The 5 Minute Bulletin Board
Please remember that all my tips and tricks are for use with Microsoft Office version 2007. If you use an earlier version, though, don't despair! Just click the Help button and type in a few appropriate words and they will give you directions for your own version. In addition, if you need further help, visit www.microsoft.com for their own tutorials.