• Did you order new AirTags? We've opened a dedicated AirTags forum.

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.
 
Comment

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?
 
Comment

Herdfan

macrumors 6502
Apr 11, 2011
270
6,594
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.
 

Attachments

  • Cell Box.jpg
    Cell Box.jpg
    10.6 KB · Views: 534
Comment

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.:)
 
Comment
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.