+ Reply to Thread
Results 1 to 3 of 3

Jump to referenced cell

  1. #1
    Registered User
    Join Date
    02-03-2012
    Location
    Tacoma, WA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Jump to referenced cell

    When you reference another cell on another tab, I could swear somewhere along the line I've seen a shortcut that allows you to jump to that cell on the other tab........

  2. #2
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Jump to referenced cell

    Do you mean Ctrl+[
    Good luck.

  3. #3
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Jump to referenced cell

    Press F5 to open the GoTo dialog and type in the sheet reference.

    Another option, right click the sheet navigation arrows at the bottom left above the status bar and choose a sheet from the list.

    One more way (requires planning and a little more effort)

    One each sheet, you can name a cell then use the Name Box drop down to navigate to the sheet/cell.
    The Name Box is to the immediate left of the formula bar.

    To Name a cell, simply select it, click into the Name Box and give it a name -- no spaces or illegal characters allowed.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1