(From the Table of Contents to other pages, and from the page titles back to the ToC, etc.) These worked fine in Excel 2007 when I used "Create PDF", but now that I'm remaking this file in Excel 2016, the hyperlinks do not come across in the PDF creation process. Basically, you’re just dragging a cell from one sheet to another.I have a workbook created to be a PDF report when complete, with hyperlinks to various points inside the file itself. It might take a time or two to get the feel of this drag-and-drop technique.
Select Create Hyperlink Here from the resulting shortcut menu. Release the key and select the cell where you want to position the link and release the mouse (A2). Excel will make the TOC sheet the current sheet. Hold down the key while you drag the mouse to the appropriate sheet tab-in this case, that’s the TOC (table of contents) tab. Right-click the border (the standard left click will not work) and the regular mousepointer will replace the four-sided arrow. Hover the mouse over any of the selected cell’s borders until the four-sided cross arrow pointer appears. Select the cell you want to link to (B1 on the Products sheet). To create the same hyperlink using drag-and-drop, do the following: This technique doesn’t require a named range.) (You can delete the Products named range, or not. In addition, it won’t work with a new, unsaved file so be sure to save the file first. It’s a drag-and-drop technique, but the sheet tabs must be visible for this technique to work. 
There’s another way that you might find a bit easier. Notice that the hyperlink uses the text in the named cell. The result is a hyperlink that selects cell B1 on the Products sheet.
Select the named range in the Or Select A Place In This Document list. Click the Place In This Document link to the left. In Excel 20, click Hyperlink in the Links group on the Insert menu. Or, right-click the cell and choose Hyperlink. 
In Excel 2003, choose Hyperlink from the Insert menu. In this case, that’s cell A2 on the TOC sheet (shown above). Select the cell where you want to insert the hyperlink. Now, to create a hyperlink to Products (the named cell) do the following): In this case, assign the name Products to cell B1 on the Products sheet.Ĭreating the name was certainly easy enough. Enter the string you want to assign as the cell’s name and click Enter. Select the Name box (left of the Formula bar). This cell contains a title for the sheet. To get started, let’s add a named range (cell really) to the Products sheet as follows: You can work with any workbook you want, you just need two sheets. In this first example, we’ll insert a hyperlink in a sheet named TOC for Table of Contents. The hyperlink will link to a product list on a sheet named Products (shown below in the first numbered list). Then, you create a hyperlink to that name. First, you assign a name to the area of the sheet that you want to link to. The traditional method requires a named range. First, I’ll show you the traditional way. You can use a menu command to create a hyperlink to a named range or you can use a simple drag-and-drop trick.Īdding a hyperlink to an Excel sheet is a simple enough task, but like so many Office tasks, there’s more than one to get the job done. Tip: A quick way to create hyperlinks in Excel
0 kommentar(er)
