Imagine you had adjusted the default options in Excel in order to make jumps to the respective source cell by double-clicking on a cell.
Everything is fine as long as there is only one source cell on a different sheet. If there were source cells on more than one different sheet I only jump to the cell on the first different sheet.
So, here is the question:
How can I jump to the other source cells on other different sheets?
Cell A1 = =Tabelle2!A1+Tabelle3!A1
Double-clicking on cell A1 leads me to the source cell on Sheet “Tabelle2”.
How can I get to the source cell on Sheet “Tabelle 3”?
This is one of the Excel options which are a bit ‘buggy’ in my opinion.
The surest way to go about it is to manually write the code you want.
For instance, here it could be:
A1 = Tabelle3!A1+Tabelle3!A1
This is really the best way to create formulas (writing them, instead of using the mouse). The reason is that when using the mouse, Excel is trying to anticipate your intentions and they could be misunderstood.
The 365 Team
Thanks for your comment. Hm, I'm sorry, does your comment fit to my questions really? Sorry, I don't understand how your tip could help…
Thanks for reaching out.
Perhaps there is a more elegant way to solve this, but here’s what I would do.
- After double-clicking on Tabelle1!A1, you will to to Tabelle2!A1, right?
- Then, as shown in the video lecture, nothing will happen if you click on Tabelle2!A1. However, if you press F5 to open the “Go To” window, you can paste the reference from the formula – Tabelle3!A1.
On the picture, “Sheet” stands for what “Tabelle” is in your case, I believe.
Hope this helps.
Hi Martin,thanks for your comment. Your way is possible; but this is a "manual" way, by hand. I appreciate having a automatic way going to source cells on the second and even further additional sheets as well. I suspect that Excel do not offer this feature. It's a pity.
Hi Christoph! Thank you very much for your reply. Perhaps the only possibility will be by using macros and VBA. Best, Martin