Something changed on my work computer and I do not know how to change it back.
When double clicking on a cell in excel, all cells referenced in the formula of the clicked cell are highlighted, and my active cell changes from the one i clicked on to the first referenced cell in the cell i clicked on.
I would like help getting back to the way it used to work where when you double clicked on a cell, you could edit the formula in the cell and all referenced cells were colored to match the text in the formula.
Any help would be appreciated.
Thanks
When double clicking on a cell in excel, all cells referenced in the formula of the clicked cell are highlighted, and my active cell changes from the one i clicked on to the first referenced cell in the cell i clicked on.
I would like help getting back to the way it used to work where when you double clicked on a cell, you could edit the formula in the cell and all referenced cells were colored to match the text in the formula.
Any help would be appreciated.
Thanks