View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LavenderBush
 
Posts: n/a
Default can I 'hyperlink' within a workbook from the first worksheet?

Wow guy's you're quick :-) when I read Dav's response I saw the 'place in
this document'

Thanks so much, it's been nearly 5 years since I spent any amount of time on
Excel, so I'm still figuring out the updates.

Gotta go and play :-D



"George" wrote:

Yes it can,
When inserting a hyper link, down the left hand side 'Link To:'
Select 'Place in This Document'

Then choose the appropriate Sheet and Cell or Named Range etc.

George

LavenderBush wrote:
Hi,

I'm working on a spreadsheet that will probably have 20+ worksheets. I'd
like to make this as 'idiot proof' as possible. I want to create a worksheet
that has clickable links to the page the User wants to view - Can this be
done?

Thanks in advance