The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Double-Click and Go Back (F5)

Back to all questions

Double-Click and Go Back (F5)

3 weeks ago
Vote Up Vote Down
0
Votes
2
Answer

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?

Example:

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”?

2 Answers

365 Team 2 weeks ago
Vote Up Vote Down
0
Votes

Hi Christoph,
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.
Best,
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…

– 2 weeks

365 Team 2 weeks ago
Vote Up Vote Down
0
Votes

Hi Christoph!
Thanks for reaching out.
Perhaps there is a more elegant way to solve this, but here’s what I would do. 

  1. After double-clicking on Tabelle1!A1, you will to to Tabelle2!A1, right? 
  2. 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.
Best,
Martin

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.

– 2 weeks

Hi Christoph! Thank you very much for your reply. Perhaps the only possibility will be by using macros and VBA. Best, Martin

– 3 days
You must to answer this question.