Jump directly to linked cell (in separate sheet) in a formula

[PP3321]

I have formula like this, which combines 4 cells from 4 different worksheets.

worksheet1!A1 + worksheet2!A1 + worksheet3!A1 + worksheet4!A1

I want to jump between these 4 cells to check its content.

I tried following method but it did not work:

1. CTR + [
2. CTR + ALT + ->

http://forum.chandoo.org/threads/jump-directly-to-linked-cell-in-a-formula.13636/

 

[chirayu]

Method isn't working because you're referring to 4 different sheets. Not just 1 sheet like the example.

 

[PP3321]

Thank you @chirayu
Is there any method to jump between different worksheets...?

 

[Deepak]

What about Watch Window

http://chandoo.org/wp/2015/08/30/watch-window/

 

[PP3321]

@Deepak

1. Thank you! I did not know Watch Window.

2. Let us say in Summary Sheet, I have following formula.
=Worksheet1!A1 + Worksheet2!A1 + Worksheet3!A1
It is 50.

I want to jump to each cell in other worksheets.

Watch Window unfortunately does not help me with that...

 

[Deepak]

As u have taken it wrongly...

Check this..

 

[bosco_yip]

Or, try this,

In Summary Sheet A1, enter formula :

=SUM('*'!A1)

Regards
Bosco

 

[PP3321]

@Deepak
Thank you...how did you add the 3 cells to Watch Window...?
Do I have to add cells manually one by one?

@bosco_yip
Thank you for your trick...

 

[Deepak]

@Deepak
Thank you...how did you add the 3 cells to Watch Window...?
Do I have to add cells manually one by one?

@bosco_yip
Thank you for your trick...

I have actually used the same what bosco written.

I have added them to WW manually.

but VBA way..
Something like this...

Application.Watches.add([A10])

for more visit:
https://msdn.microsoft.com/en-us/library/office/ff195056.aspx

 

[PP3321]

@Deepak
Thank you!!! I forgot that I could do VBA way...

 

[PP3321]

@Deepak,
I also found following method:
1. F5 or Ctr + G
2 Select Formulas
3. Add all