anything in Excel...

It's Excel-o-lozy...

Trick - Jump between formulae...

How do we jump within formulae???

Say if we wish to go to the cell on which our calculation of current cell is dependent...

What to do??? Press F2 and see which cell is outlined in color???

Much Simpler way is...


Press:

Ctrl + [   or   Ctrl+Shift+{
for jumping to precedent cell

Ctrl + ]  or Ctrl+Shift+}
for jumping to dependent cell

Dont expect me to give example here.
Plz open your respective excel files and try it... enjoy it...

2 comments: