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

Microsoft Excel is designed to alert users whenever a circular reference is causing problems. Folks who are unable to spot the error can take full advantage of the ...