link to a specific worksheet of a workbook with many worksheets

  • Thread starter Thread starter eva cheng
  • Start date Start date
E

eva cheng

In Excel 2003, how can i add a hyperlink (or other method) in a cell that can
link to a specific worksheet in another workbook which have multi worksheets.

thanks
 
Presuming you want to link on a word, type the word (or words) in a cell,
click back on that cell and press CTRL+K. When you see the hyperlink window
appear click on 'Place in this document' down the left-hand side of the
window and then click on the sheet you want to link to.

Andrea Jones
www.stratatraining.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Link cell from Wkbk1 to a cell in a specific Worksht in Wkbk2 4
Hyperlink to a spcific worksheet 6
Creating multiple links between worksheets within a single workboo 1
Excel workbook links 1
Link in worksheet 3
Spelling checker problem on a specific worksheet only 1
link to another document of Excel 2003 2

Back
Top