I used to play formula roulette every time I dragged the fill handle, hoping Excel wouldn't misinterpret my intentions. Was I supposed to lock the column, the row, or both? Then, the dollar signs ...
How-To Geek on MSN
Don’t ignore the power of F4 in Microsoft Excel
F4 is literally the key to excellence in Excel.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results