When working on a single worksheet, one can double click on a formula and highlight all cells that make up the formula. However, when the cells referenced in the formula come from another sheet, double clicking will take you to the sheet, but only highlight one cell. Is there a way to have exel highlight all of the cells in the formula referenced on the other sheet? Thanks
Bookmarks