Another example: If you have cells named SubTotal and Tax, and type a formula =subtotal*tax Excel converts that to =SubTotal*Tax automatically. Because of this and because Excel puts functions in all ...

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 ...