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 ...
One tiny symbol, but an absurd amount of spreadsheet drama.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results