excel go to a particular row

Discussion in 'Mac Apps and Mac App Store' started by mary86004, Mar 17, 2012.

  1. mary86004 macrumors member

    Joined:
    Apr 16, 2011
    #1
    How can I make the cursor jump to row 2378 for example instead of having to scroll there?

    Thanks for any tips.:)
     
  2. Narayan40 macrumors newbie

    Joined:
    Mar 17, 2012
    #2
    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.
     
  3. mary86004 thread starter macrumors member

    Joined:
    Apr 16, 2011
    #3
    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?
     
  4. Herdfan macrumors 6502

    Joined:
    Apr 11, 2011
    #4
    For me it turns on and off with the Formula Bar. It's the box with A1 in it right above Column A.
     

    Attached Files:

  5. mary86004 thread starter macrumors member

    Joined:
    Apr 16, 2011
    #5
    thanks!

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

Share This Page