Forum Discussion
How do I set it up so that when I double click a cell it goes to the cell reference
How do I set it up so that when I double click a cell it goes to the cell reference
2 Replies
Hi Kent11255
You would use hyperlink
- Type a name in a cell that will act as the anchor text for the bookmark and press Enter.
- Select that cell to make it the active cell.
- Open the Insert Hyperlink dialog box.
- Select the Place in This Document tab (or select the Place in this document button in Excel Online).
- In the Type the cell reference text box, enter a cell reference to a different location on the same worksheet, such as "Z100."
- Select OK to complete the bookmark and close the dialog box.
- 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.
