You want to navigate to a certain sheet by clicking in a cell? Is that right?
Create a hyperlink to a specific location in a workbook
To link to a location in the current workbook or another workbook, you can
either define a name (name: A word or string of characters that represents a
cell, range of cells, formula, or constant value. Use easy-to-understand
names, such as Products, to refer to hard to understand ranges, such as
Sales!C20:C30.) for the destination (destination: General term for the name
of the element you go to from a hyperlink.) cells or use a cell reference.
1. To use a name, name the destination cells in the destination workbook.
ShowHow?
1. Select the cell, range of cells, or nonadjacent selections
(nonadjacent selection: A selection of two or more cells or ranges that don't
touch each other. When plotting nonadjacent selections in a chart, make sure
that the combined selections form a rectangular shape.) that you want to name.
2. Click the Name box at the left end of the formula bar (formula
bar: A bar at the top of the Excel window that you use to enter or edit
values or formulas in cells or charts. Displays the constant value or formula
stored in the active cell.) Formula bar.
Name box
Callout 1 Name box
3. Type the name for the cells.
4. Press ENTER.
Note You cannot name a cell while you are changing the contents of
the cell.
2. In the source (source file: The file that contains information that
was used to create a linked or embedded object. When you update the
information in the source file, you can also update the linked object in the
destination file.) workbook, right-click the text or graphic you want to
represent the hyperlink (hyperlink: Colored and underlined text or a graphic
that you click to go to a file, a location in a file, a Web page on the World
Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups
and to Gopher, Telnet, and FTP sites.), and then click Hyperlink on the
shortcut menu.
3. Do one of the following:
*
To link to a location in your current workbook, click Place in
this document under Link to.
*
To link to a location in another workbook, click Existing file
or Web page under Link to.
4. If you chose Existing file or Web page, locate and select the workbook
you want to link to, and then click the Bookmark button.
5. Do one of the following:
*
In the list under Cell Reference, click the sheet you want to
link to, and then type the cell reference in the Type in the cell reference
box. Click OK.
*
In the list under Defined Names, click the name that represents
the cells you want to link to. Click OK.
6. To assign a tip to be displayed when you rest the pointer on the
hyperlink, click ScreenTip and then type the text you want in the ScreenTip
text box. Click OK.
HTH,
Ryan---
