EXCEL : To know where a cell is getting its value from (reference)
(a) CTRL + [ : Select all cells directly referenced by formulas in the selection.
(b) F5 : Goto - To go back to the cell where Ctrl + [ was pressed
Very useful when dealing with huge amount of data, especially referenced in multiple worksheets.
Try it out.
0 comments:
Post a Comment