How to jump to another Excel worksheet?

December 12, 2012 4:00 AM

[Excel 2007 filter] Is it possible to input some text into a cell, e.g. "Click here for Worksheet 2" or similar, and create a hyperlink on that cell to open, uh, Worksheet 2? In the same window, not a new instance. Neither a search of AskMe and/or the Excel help-screens has been successful. Thanks in advance.
posted by aqsakal to Computers & Internet (7 answers total)

I have only the mac version handy (2008?), but I think this is mostly straightforward. (If the menus are quite different, then tell me to go away and I'll look tomorrow...)

So anyway, try:

1) Select the cell to link from.
2) Create a hyperlink (cmd-k for me, ctrl-k for you)
3) Select 'Document' tab.
4) Near 'Anchor' there's a 'locate' button. Press that.
5) Define the cell location you want to link to.

Sorry, I know it's a different version, but generally my windows advice would be "press ctrl-K, and then poke about the menu a bit".
posted by pompomtom at 4:11 AM on December 12, 2012 [1 favorite]

Response by poster: Many thanks for swift answer, pompomtom. (Yes, I tried Ctrl-k first, but - surprisingly - it didn't work, so I went manual to the "Insert" tab on the menus.) That should open a new instance of the whole file, but doesn't. Also, I can't work out the syntax for Worksheet no. 2 of budget.xlsx.
posted by aqsakal at 4:18 AM on December 12, 2012

Ah, then it is a version difference. In my version the anchor part defaults to the current document, and basically begs for a cell reference. Apols for the red herring, will have a squizz at this thread tomorrow, but I'm sure someone more helpful will be along shortly.
posted by pompomtom at 4:42 AM on December 12, 2012

Best answer: Check here.

In summary:
1. Select a cell where you want to place the hyperlink
2. Type a description of the workbook you want to link to
3. Right click on that cell and choose Hyperlink... (or Ctrl+K that ish!)
4. Browse to the file location
5. Select the file you want to link to and click OK

Some more tips on there for extras. Oh, and I actually tried this in Excel 2007.
posted by xiaolongbao at 6:21 AM on December 12, 2012

Since you want to activate a worksheet within the same workbook, all you're doing is creating s hyperlink to a cell on a different worksheet. Note that you must reference a specific range , e.g. cellA1. You cannot just link to the worksheet.
posted by NailsTheCat at 7:30 AM on December 12, 2012

Response by poster: Great, xiaolongbao! Your "Check here" link did it! What I wasn't able to do was link to another worksheet in the same workbook. I hadn't discovered the "Bookmark" option to get to a different worksheet.

Many thanks to all for taking the time to help out.
posted by aqsakal at 12:39 PM on December 12, 2012

Woohoo! Glad it worked/was what you wanted =]
posted by xiaolongbao at 8:14 PM on December 17, 2012