Creating a Hyperlink from a cell to a worksheet in the same workbook? Excels help file is useless?

Question

I have an Excel workbook; file name Book1. On Sheet1, cell A1, I want to create a Hyperlink (or anything similar) that, if I click on Cell A1, Excel will jump to Sheet2 in the same workbook. I have tried all the Microsoft help, and as usual it doesn’t work!

Answer 1

Try this - works in Access 2003
Put your cursor in cell A1 on Sheet1, Right click in the cell and choose Hyperlink. Type a name for your link, for example: Go to Worksheet2. Click the Bokmark button and choose Sheet2 (add a cell location if you want). Click OK.
You should now see the text "Go to Worksheet2" in Cell A1 of Sheet1, click on the text and you should jump to Sheet2.

Good luck

Answer 2

I do it by creating a button the recording a macro.

You click on the button then it'll take you to the sheet you want.

Hope that points you in the right direction.

Answer 3

Try this site http://www.ozgrid.com/Excel/hyperlinks.htm they have lots of information on Excel