excel go to a particular row

mary86004

macrumors member
Original poster
Apr 16, 2011
48
0
How can I make the cursor jump to row 2378 for example instead of having to scroll there?

Thanks for any tips.:)
 

Narayan40

macrumors newbie
Mar 17, 2012
1
0
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

macrumors member
Original poster
Apr 16, 2011
48
0
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?
 

mary86004

macrumors member
Original poster
Apr 16, 2011
48
0
thanks!

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