excel go to a particular row

[mary86004]

How can I make the cursor jump to row 2378 for example instead of having to scroll there?

Thanks for any tips.

 

[Narayan40]

Use the Cell or range finder

There is a white box on the very left hand side of the formula bar (where you enter your functions and calculations). It is directly above column A. Type the cell you wish to go to in that box and hit the return/enter key. EG type A2378 and hit return. This works the same for named ranges you have in the sheet. Type the name of the range you have previously named and hit enter and you will see the range highlighted. Hope this helps.

 

[mary86004]

There is a white box on the very left hand side of the formula bar (where you enter your functions and calculations). It is directly above column A. Type the cell you wish to go to in that box and hit the return/enter key. EG type A2378 and hit return. This works the same for named ranges you have in the sheet. Type the name of the range you have previously named and hit enter and you will see the range highlighted. Hope this helps.

Thank you for your replly.
It isn't on my tool bar. If I go to view, I can turn on the formula bar but I don't see a cell or range finder. Do you know where i would go to turn it on?

 

[Herdfan]

Do you know where i would go to turn it on?

For me it turns on and off with the Formula Bar. It's the box with A1 in it right above Column A.

 

[mary86004]

thanks!

Thanks for the picture. I see it now. Yes it works perfectly. Thanks for your help.