
DOUBLE CLICKING TO A FORMULA
Double Clicking in a cell to take you directly to the source of data of the formula is possibly one of the most useful tricks available when working with a spreadsheet with multiple worksheets and many formulae. In the example below there is a formula in cell D2 which references somewhere else in the workbook. By Double Clicking the cell it will take you to the source of the formula. Double Clicking the cell not only takes you to the cell, but in this case it also highlights