Relative Content

Tag Archive for excel-formulaformat

Recent Changes To Cell Highlighting When Clicking Formula

Previously, when I clicked into an excel formula to edit it, I would see the cells that the formula referenced get highlighted. This was especially helpful as different colors were used for different ranges in the formula. Now, I cannot see any highlighting unless I actually change the range (e.g. A1:20 to A1:A2. Is there a way to change this feature back?