Create hyperlinks that point to areas in a workbook (Excel 2000/2002/2003/2004/2007)

Excel workbooks can store a huge amount of data, and getting from one place to another in a file can be tedious. You can simplify things by creating hyperlinks that jump exactly to a specific place in the file. To demonstrate, select the cell you want to contain a hyperlink. Then, enter the text that you want the hyperlink to display. Next, choose Insert | Hyperlink from the menu bar. (In Excel 2007, go to the Insert tab and click the Hyperlink button in the Links group.)

Select the Place In This Document button on the Link To bar. If your workbook contains named ranges, you can select a name from the Defined Names list to have the hyperlink jump to it when clicked. Otherwise, select the appropriate worksheet name under the Cell Reference node and enter a cell or range address in the Type The Cell References text box. Click OK. Click the hyperlink and Excel immediately assigns focus to the appropriate range.