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.
How to Perform Double Click Cell Jump in Excel: 2 Easy Ways
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.
- 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.
- Then, select “Options” from the available options.
- Consequently, a prompt will be on the screen.
- In the prompt, first, select Advanced.
- Then, unmark the box named “Allow editing directly in cells” under the Editing options.
- Finally, click OK.
- After that, double-click on the B5 cell again.
- Consequently, we will see a 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: How to Make Excel Move Automatically to the Next Cell
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.
- 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.
- As a result, an arrow will appear on the screen.
- 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.
Download Practice Workbook
You can download the practice workbook here.
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.
Related Articles
- How to Shift Cells Up in Excel
- How to Shift Cells Right in Excel
- Fix: Excel Cannot Shift Nonblank Cells
- How to Use the Arrows to Move Screen Not Cell in Excel
- How to Move Down One Cell Using Excel VBA
- Move One Cell to Right Using VBA in Excel
- How to Move Cells without Replacing in Excel
- How to Move Filtered Cells in Excel
- How to Move Highlighted Cells in Excel
- How to Move a Group of Cells in Excel
- How to Shift Cells Down in Excel
- How to Shift Cells Down in Excel Without Changing Formula
- [Fixed!] Unable to Move Cells in Excel
- Move and Size with Cells in Excel