How do I "Double-click" only using the keyboard?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to click through a cell to the referenced cell without
having to reach for my mouse, put the cursor in the cell, and double-click.
I want to be able to hit a keyboard shortcut, and have excel take me to the
referenced cell. Is this possible?
 
I think you might be after Trace Dependants.

Select the cell and Press F2 (Edit Key) To show dependant cells.
Alternatively:
Select cell(s) with formulas, choose Tools,Auditing, Trace Dependants.

The VB syntax would be

Selection.ShowPrecedents


Peter
 
For my job, I use a workbook with multiple sheets. One sheet is used to
explain the numbers in my other sheets. So on the first sheets (with the
numbers) there is a cell with an {a}, {b}, etc... You can double click on
it and it will take you the last page and to the cell with the explanation.
The formula in the "{a}" cell is =Lastpage!A3. Then on that page, I put a
link back to the original cell, =firstpage!c5, out to the side of the
explanation. It helps me read an explanation and quickly find the number it
is describing. Thanks for any help
 
You could try:

<Ctrl> <[>
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

For my job, I use a workbook with multiple sheets. One sheet is used to
explain the numbers in my other sheets. So on the first sheets (with the
numbers) there is a cell with an {a}, {b}, etc... You can double click on
it and it will take you the last page and to the cell with the explanation.
The formula in the "{a}" cell is =Lastpage!A3. Then on that page, I put a
link back to the original cell, =firstpage!c5, out to the side of the
explanation. It helps me read an explanation and quickly find the number it
is describing. Thanks for any help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I open a hyperlink with the keyboard only (not using mouse) 5
what is the keyboard shortcut for double-click? 2
How do I double click a cell and jump to cell's referenced cell 2
Use autocomplete function with keyboard instead of double-clicking 1
Keyboard Shortcut 3
Keyboard shortcut for double click in Excell cell 10
Stepping in to a cell 3
Protecting cells but still able to see referencing equations 1

Back
Top