When your spreadsheet has formulas, it’s easy for unexpected problems to occur within your formulas, particularly if you copy and paste or autofill your formulas. This tip is one way to get a clear visual of what’s happening with any given formula.
Double-click on the cell you want to check. The formula will appear in the formula bar, but looking at it in its resident cell, you can see each cell reference is a different color. A1 is blue, A2 is green, and C3 is purple.
In my graphic, you can see that cell C3 has nothing in it. I really wanted that to be A3 instead. A quick, easy fix for that is to click and drag the purple box up to C3. Hit enter.
Thanks for stopping by!