In Sheet1 cell A 6 type:-

=Sheet3!A6

In the same cell (Sheet1 cell A6)

- right hand click once

- click on Hyperlink

- Insert Hyperlink should launch

- select Place in This Document (by clicking it) on the left hand side

- in the Type the cell reference: box (field) on the right hand side select
A6

- select Sheet3 (for example) on the right hand side (by clicking on that
option)

- click OK

- Sheet1 cell A 6 will now change format to show that a hyperlink has been
added

- Save the file (if required)

Clicking in Sheet1 cell A6 will now take you to Sheet3 cell A6 automatically.

If my comments have helped please hit Yes.

Thanks.


"accessnovice" wrote:

I would like to be able to click in a cell and have it take me to another
page in the workbook - Any suggestions? Thank you.