![]() Now if you want to link any sheet within same workbook, then open Insert Hyperlink dialog and from the left sidebar select Place in This Document, from right side select the sheet for which to want to create hyperlink, from Text to display enter text you want to display and under Type the cell reference enter the cell location you want to refer. You will see a hyperlink is created in the cell, upon click it will open the desired file. You will reach Insert Hyperlink dialog, from the left sidebar select Existing File or Web Page, from right sidebar select the file for which to want to create hyperlink, from Text to display enter text you want to display instead of file path. Select the cell in which you want to create hyperlink and right-click to select Hyperlink. Now we will be creating hyperlinks in the sheet. For instance, we have included a spreadsheet containing Name, Marks, and Links field, as shown in the screenshot below. ![]() ![]() Launch Excel 2010 spreadsheet in which you want to add links. ![]() By following a simple procedure you will be able to link up important datasheet with other content. Excel 2010 provides a convenient way for linking up cells data with whatever you want. While working on Excel spreadsheet, sometime there is a dire need to create links in cells to files, folders, web pages, images, sheets within workbook, etc to complement spreadsheet in a better way. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |