Find precedent cell in Excel

[gary brown]

In the US version we can double left-click on C1. It will
take us straight to H100.
HTH,
Gary Brown

 

[Dave Peterson]

In the USA version, I also have to have Tools|Options|Edit tab
"Edit directly in cell" unchecked

And I could look at excel's help for shortcuts ("Keyboard shortcuts") and click
the show all (at the top right corner).

Then search for [ (open square bracket).

I found this:
CTRL+[ (opening bracket)
Select all cells directly referenced by formulas in the selection.

Maybe you'll see the equivalent in your language (if you read the descriptions).

It was under the "Select cells with specific characteristics" category.

Thanks.

Unfortunately that does not work in my version. Furthermore I was trying to
avoid using the mouse, and only the keyboard

"gary brown" skrev:

In the US version we can double left-click on C1. It will
take us straight to H100.
HTH,
Gary Brown

-----Original Message-----
I am trying to find out how to jump from one cell (C1) to the cell C1 is
dependent on, i.e. C1's precedent cell on a Danish keyboard. In the UK I did
it using CTRL+ [

Example: if C1 is "=H100" and I am in C1, how do I get to H100 by using
shortcuts?

.

 

[Dave Peterson]

from a private reply:

I recorded a macro when I hit Edit|goto|special|precedents and got this line:

Selection.DirectPrecedents.Select

=====
Added here.

maybe just create a macro and assign it the keyboard shortcut of your choice.

Dave,

Thanks

Actually my version of Excel (MSN Office) is a US/UK version, so am able to
find the CTRL + [ descripion in the Help function.

The issue is I have a Danish keyboard where [ (Left Sq. Bracket) does not
have its own key, but is placed on the 8 key, so I have to press ALT GR + 8
to make a [ (Left Sq. Bracket).

I could probaly change the shortcut to something else, but not sure how to
do it?
Do you?
Many thanks

Palle

"Dave Peterson" skrev:

In the USA version, I also have to have Tools|Options|Edit tab
"Edit directly in cell" unchecked

And I could look at excel's help for shortcuts ("Keyboard shortcuts") and click
the show all (at the top right corner).

Then search for [ (open square bracket).

I found this:
CTRL+[ (opening bracket)
Select all cells directly referenced by formulas in the selection.

Maybe you'll see the equivalent in your language (if you read the descriptions).

It was under the "Select cells with specific characteristics" category.

Thanks.

Unfortunately that does not work in my version. Furthermore I was trying to
avoid using the mouse, and only the keyboard

"gary brown" skrev:

In the US version we can double left-click on C1. It will
take us straight to H100.
HTH,
Gary Brown

-----Original Message-----
I am trying to find out how to jump from one cell (C1) to
the cell C1 is
dependent on, i.e. C1's precedent cell on a Danish
keyboard. In the UK I did
it using CTRL+ [

Example: if C1 is "=H100" and I am in C1, how do I get to
H100 by using
shortcuts?

.