Hi Kaitlin, go to insert, hyperlink - select place in this document then
select the place you want to go to. This works better if you have defined a
name for the range in advance.

HTH

Stu

"Kaitlin.uk" wrote:

I am fairly new to Excel and was wondering if it was possible to click into a
cell of one worksheet and that would open another worksheet in the same
workbook? any help would be greatly appreciated