Interesting+Excel+Tricks

__//EXCEL//__//-l// // ent tricks! //
Each individual cell on the excel form can receive and hold its own comment. In order to insert a comment you must:
 * Right click the cell in which you want to insert a comment for.
 * Click insert comment and type your reminder.
 * Click and hold the comment box to drag and move properly.

Here is a demonstration of the comment tool.

media type="youtube" key="-5xENBEoViY" height="344" width="425"

Here's another a trick to use an important function of Microsoft excel, Absolute Refrence. 1.First you would click the two cells you will be using. (ex. B2 & B4) 2. The you would click the F4 button which will put dollar signs on the letter & number of the second cell you have highlighted. 3. Then you will drag the cross at the bottom right corner of the cell and drag it in the direction of you work to finish filling in the empty cells.

Here's a demonstration for further guidance.

http://www.youtube.com/watch?v=NmVMjQzseLA