Scrolling to a cell in formula
 

For example:

Suppose in cell A1, I have: =SUM(A2:A2000)

and, in cell A1, for example, appears the number 244,829.

Now, let's say I would like to see the contents of the A2000 cell.

Is there a way, while working within cell A1, I can easily "jump" to cell
A2000 to verify its contents?

In other words, are there any commands, or 'shortcuts', or whatever(?) that
allows me to JUMP to cell A2000 instantaneously?

Thank you,

FLKulchar

Scrolling to a cell in formula
 

Control + g, then type in the cell reference

"F. Lawrence Kulchar" wrote:

For example:

Suppose in cell A1, I have: =SUM(A2:A2000)

and, in cell A1, for example, appears the number 244,829.

Now, let's say I would like to see the contents of the A2000 cell.

Is there a way, while working within cell A1, I can easily "jump" to cell
A2000 to verify its contents?

In other words, are there any commands, or 'shortcuts', or whatever(?) that
allows me to JUMP to cell A2000 instantaneously?

Thank you,

FLKulchar

Scrolling to a cell in formula
 

Double click A2000 in the formula bar, so it gets highlighted. Press F5 and confirm with ENTER

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"F. Lawrence Kulchar" wrote in message
...
| For example:
|
| Suppose in cell A1, I have: =SUM(A2:A2000)
|
| and, in cell A1, for example, appears the number 244,829.
|
| Now, let's say I would like to see the contents of the A2000 cell.
|
| Is there a way, while working within cell A1, I can easily "jump" to cell
| A2000 to verify its contents?
|
| In other words, are there any commands, or 'shortcuts', or whatever(?) that
| allows me to JUMP to cell A2000 instantaneously?
|
| Thank you,
|
| FLKulchar

Scrolling to a cell in formula
 

YES, it works...THANK YOU Mr. Sperry
"J. Sperry" wrote in message
...
Control + g, then type in the cell reference

"F. Lawrence Kulchar" wrote:

For example:

Suppose in cell A1, I have: =SUM(A2:A2000)

and, in cell A1, for example, appears the number 244,829.

Now, let's say I would like to see the contents of the A2000 cell.

Is there a way, while working within cell A1, I can easily "jump" to cell
A2000 to verify its contents?

In other words, are there any commands, or 'shortcuts', or whatever(?)
that
allows me to JUMP to cell A2000 instantaneously?

Thank you,

FLKulchar

Scrolling to a cell in formula
 

Thank you; occasionally, but not often, I rate replies to my queries with a
"wow".

This is a "WOW!!!"

Thank you...I tried it and it works perfectly. Thank you Mr. Otten.

FLKulchar
"Niek Otten" wrote in message
...
Double click A2000 in the formula bar, so it gets highlighted. Press F5
and confirm with ENTER

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"F. Lawrence Kulchar" wrote
in message
...
| For example:
|
| Suppose in cell A1, I have: =SUM(A2:A2000)
|
| and, in cell A1, for example, appears the number 244,829.
|
| Now, let's say I would like to see the contents of the A2000 cell.
|
| Is there a way, while working within cell A1, I can easily "jump" to
cell
| A2000 to verify its contents?
|
| In other words, are there any commands, or 'shortcuts', or whatever(?)
that
| allows me to JUMP to cell A2000 instantaneously?
|
| Thank you,
|
| FLKulchar