Pictorial representation of formula precedents in Excel
Using formulas we can make wonders in excel and Excel highlights the cells which are being used in formula if you click on formula cell but if you want to highlight the precedents cells then use Trace precedents.
Short way to get Absolute reference in Excel
Press F2 to edit cell which has formula.
Press F4 to create complete absolute reference.
Press F4 again to make absolute row value
Press F4 again to make absolute column value.
Press F4 again to make it normal.
