Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Perform Double Click Cell Jump in Excel

We often need to find out which dataset consists of our formula. However, when we double-click on the formula cell, we see the formula in the cell. Excel does not jump to the cells that contain the data. In this article, we will show how to perform double-click cell jump in Excel.


Download Practice Workbook

You can download the practice workbook here.


2 Easy Ways to Perform Double Click Cell Jump in Excel

In this article, we will show how to do a double-click jump in Excel in two ways. In the first method, we will use the Excel Advanced option to make the jump. The Advanced option will allow us to disable the editing formula in the cell. In the final method, we will use the Trace Precedents command to jump to a specific cell. This will give us a choice of where to jump.


1. Applying Advanced Option

Excel provides a way to disable the editing of formulas in the formula cell. We will have to apply the Advanced option to access the checkbox that disables the editing of formulas in the formula cell. In this method, we will use the Advanced option to do that.

Steps:

  • To begin with, select the B5 cell and double-click on it.
  • As a result, we will be able to see the formula within the cell depicting the summation of salaries using the SUM function.
  • There is no cell jump.

selecting formula cell to perform excel double click cell jump

  • Again, select the B7 cell and double-click.
  • Here too, we will not see a cell jump.

  • To do the cell jump, first, select the File tab.

going to file tab to perform excel double click cell jump

  • Then, select “Options” from the available options.
  • Consequently, a prompt will be on the screen.

selecting options menu to perform excel double click cell jump

  • In the prompt, first, select Advanced.
  • Then, unmark the box named “Allow editing directly in cells” under the Editing options.
  • Finally, click OK.

going to advanced option to perform excel double click cell jump

  • After that, double-click on the B5 cell again.
  • Consequently, we will see a cell jump.

double clicking on formula cell to perform excel double click cell jump

  • Excel will take users to the dataset that is used in the formula.
  • In this case, the cells containing the salaries of the employee in the Employee Data sheet.

  • After that, double-click on the B7 cell too.

  • As a result, Excel will take us to the dataset comprising the formula.

Read More: [Solved:] Excel Double Click AutoFill Not Working


Similar Readings


2. Using Trace Precedents Command

The Trace Precedents command displays the relationship between the cell and the formula. When we double-click on a formula cell we most often see that the formula is displayed in the cell. However, if we disable the editing formulas in the cell option then Excel will take us to the dataset on which we will apply the formula. But, if we use the default setting then Excel will take us to the first cell of the formula first then the second one, and on and on sequentially. The Trace Precedents command allows us to jump between cells according to our requirements. In this method, we will explore that.

  • Firstly, select the D5 cell and double-click.
  • As a result, we will see that the formula in the cell consists of two data from two different sheets.
  • And also, there will be no cell jump.

choosing formula cell to perform excel double click cell jump

  • Next, go to the File tab.

  • Then, from the prevailing options select Options.
  • As a result, a dialogue box will appear on the screen.

  • In the dialogue box, first, choose Advanced.
  • Then, uncheck the box named “Allow editing directly in cells” under the Editing options.
  • Finally, click OK.

  • After that, select the D5 cell.
  • Then, go to the Formulas tab.
  • Finally, from the Formula Auditing group, choose the Trace Precedents command.

selecting trace precedents command to perform excel double click cell jump

  • As a result, an arrow will appear on the screen.

excel showing arrow sign to perform excel double click cell jump

  • Afterward, double-click on the dotted line.
  • As a result, a prompt will be on the screen.

  • The prompt will show the location of the data that comprises the formula in the D5 cell in the Trace Precedents sheet.
  • We select the second data location.
  • Finally, click OK.

  • As a result, Excel will jump to the D5 cell in the Sales Quantity sheet.

Read More: [Solved] Excel Formatting Not Working Unless Double Click Cell


Conclusion

In this article, we have discussed 2 ways to do a double-click cell jump in Excel. The first one will allow users to jump to cells by the default settings of Excel. The second one will help users to jump to cells according to their requirements. These methods combinedly will help them to establish a proper connection with the formula to the cell. It will also help them to error checking of the dataset that comprises the formula. If you have any questions regarding this essay, feel free to let us know in the comments. Also, if you want to see more Excel content like this, please visit our website Exceldemy.Com and unlock a great resource for Excel-related content.


Related Articles

Tags:

Adnan Masruf

Adnan Masruf

I am an engineering graduate. I graduated from Bangladesh University of Engineering and Technology(BUET), one of the top universities in Bangladesh from department of Naval Architecture & Marine Engineering with a major in structure. I am an avid reader of fiction especially fantasy. I also keep myself abreast of the recent developments in science and technology. I believe diligence will eventually pay off and luck tends to favor those who work hard.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo