Scrolling to a cell in formula

[F. Lawrence Kulchar]

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

 

[J. Sperry]

Control + g, then type in the cell reference

 

[Niek Otten]

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| 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

 

[FLKulchar]

YES, it works...THANK YOU Mr. Sperry

Control + g, then type in the cell reference

 

[FLKulchar]

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