Tuesday, 17 March 2015

Excel Tips & Tricks Part 1


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.



1 comment:

  1. As stated by Stanford Medical, It's in fact the one and ONLY reason women in this country live 10 years longer and weigh an average of 19 kilos lighter than us.

    (By the way, it is not about genetics or some secret-exercise and really, EVERYTHING to related to "how" they eat.)

    P.S, What I said is "HOW", and not "what"...

    TAP this link to see if this brief questionnaire can help you unlock your true weight loss possibility

    ReplyDelete