How do I set it up so that when I double click a cell it goes to the cell reference

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3151955%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EHow%20do%20I%20set%20it%20up%20so%20that%20when%20I%20double%20click%20a%20cell%20it%20goes%20to%20the%20cell%20reference%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3151955%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHow%20do%20I%20set%20it%20up%20so%20that%20when%20I%20double%20click%20a%20cell%20it%20goes%20to%20the%20cell%20reference%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3151955%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

How do I set it up so that when I double click a cell it goes to the cell reference

2 Replies
To which cell reference? One contained in a formula of the cell you double-click on? Control+[ selects all precedent cells of a cell which are on the same worksheet, or takes you to the first reference if it is on another worksheet.

Hi @Kent11255 

 

You would use hyperlink 

  1. Type a name in a cell that will act as the anchor text for the bookmark and press Enter.
  2. Select that cell to make it the active cell.
  3. Open the Insert Hyperlink dialog box.
  4. Select the Place in This Document tab (or select the Place in this document button in Excel Online).
  5. In the Type the cell reference text box, enter a cell reference to a different location on the same worksheet, such as "Z100."
  6. Select OK to complete the bookmark and close the dialog box.