Scrolling to a cell in formula

  • Thread starter F. Lawrence Kulchar
  • Start date
F

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
 
N

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
 
F

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
 
Top