Almost a year ago, we talked about creating a table of contents sheet in Excel. In that post, one of the suggestions was to type a list of sheets on a worksheet, then change each sheet name into a hyperlink.
Create Hyperlinks By Dragging
Well, forget all that typing -- here's a method that's even easier. Instead of typing, you can drag cells to create hyperlinks.
In this example, there's a table of contents sheet (TOC), a Sales sheet, and an Expenses sheet. We'll create a hyperlink to the Sales sheet, on the TOC sheet.
- First, save the workbook, if you haven't done so already. If you're in a new workbook, that hasn't been saved, this technique won't work.
- Next, select a cell that you want to link to. In the screen shot below, the Sales sheet is activated and cell A1 is selected.
- Point to the selected cell's border, and press the right mouse button.
- We want to drag the cell to the TOC worksheet. Press the Alt key on the keyboard, and drag the cell over the TOC sheet tab.
- The TOC sheet will be activated, and you can release the Alt key.
- Drag to cell B4, and release the right mouse button
- In the popup menu that appears, click Create Hyperlink Here
A hyperlink is automatically created, using the text from the Sales Report cell that you dragged.
To go to the Sales sheet, click the Sales Report hyperlink.
Watch the Create Hyperlinks Video
To see the steps performed, you can watch this short Excel tutorial video.