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...
Said
I think it has to be "Ctrl + [" and "Ctrl + ]"
Said
Boss,
"{" and "[" are on same button...
but your skills are appreciated as
"[" can be used without shift key so i shud av quoted Ctrl+[ or Ctrl+Shift+{
Thanx for correction...