See Links Between Cells. Select any blank cell in the worksheet. Step 1 Select the cell that you want to create your link in.
Remember or jot down that name. A cell relationship diagram shows a detailed interactive diagram of all links from the currently selected cell to other cells in the same worksheet other worksheets or even other workbooks. You can create a shortcut link in any cell in your spreadsheetStep 2 Click the Insert tab and then click Hyperlink This will open a.
Ive searched this and other forums but came up blank.
To link to a specific sheet or cell click the Bookmark button in the right-hand part of the Insert Hyperlink dialog box select the sheet and type the target cell address in the Type in the cell reference box and click OK. It is best to take the full name including the xls or whatever at the end or enough of the name so that it will be unique. The link formula syntax is SheetName. Actually we can make hyperlinks to other worksheets with Hyperlinks command easily.
