Office XP - Excel

  • Thread starter Thread starter Ernest
  • Start date Start date
E

Ernest

Hi Anyone,

I have a workbook with two worksheets. I want to create a
link from a cell in the first w/sheet which will take me
to the second w/sheet without clicking the tab at the
bottom. Can anyone help please?
 
Ernest

Right-click on the cell in first sheet.

Select "Hyperlink" from menu.

When dialog pops up select Link to: "Place in this document"

Pick the second worksheet and a cell reference on that sheet.

OK. You're done.

Gord Dibben Excel MVP XL2002
 
Hi Ernest,

Do this:
- Select the cell to insert the link;
- Go Insert menu > Hyperlink.. command to open Insert hyperlink dialog box;
- At "Link to:" list box select "Place in this document" option;
- At "Or select a place in this document:" list box select Sheet2
- and OK


HTH
 
Back
Top