Shortcuts

[UNK]

Can you make a shortcut that takes you to a certain worksheet within a
workbook?

 

[Sean Timmons]

If you are within the workbook in question, you can use a hyperlink. Insert >
hyperlink > place in this document.

 

[Gord Dibben]

Not without VBA

But you could add a clickable hyperlink to go to another sheet.

CTRL + Pageup and Pagedown will cycle through sheets.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

The thing that's very nice about David's syntax is that if you insert or delete
rows/columns in Sheet3, then the formula will point to the new location.

You could also use this syntax:
=HYPERLINK("#Sheet3!C5","Click Here")

Will always point at C5 of Sheet3--no matter if you insert/delete rows or
columns.

So you'll want to choose the one that fits your requirements.