Forum Discussion
Excel 365 - Cells Highlighted as part of a formula
Excel used to highlight all cells referenced in a formula by putting a colored box around each section when in the cell or formula bar with a formula. It is no longer doing that. I can find no toggle for this functionality in the ribbon or Options. Anybody have an idea?
5 Replies
MelissaGriggs Try clicking on the cell with the formula and hitting F2.
- MelissaGriggs Click inside the formula bar to show cells/ranges referred to in a formula.
- Not working. No clue what's happened.
MelissaGriggs So you don't see something like this (see picture) when you select a cell with a formula and click inside the formula bar. Strange!
