Step 5: This will create a link to the sheet name called Main Data. Step 4: Select Place in this Document > Sheet Name. Step 3: Select the first sheet name cell, i.e. Step 1: Insert one new sheet and name it has All Sheet Names. I have a total of 8 sheets in this example. Using the hyperlink option, we can create a link to those sheets, and with just a click of the mouse, we can reach the sheet that we want. Example #3 – Create Hyperlink to Work SheetsĪs I have mentioned at the start of this article, if we have 20 sheets, it is very difficult to find the sheet that we wanted. Step 4: Now select the other two cells and follow the same procedure. If you click on Units Sold (F2), it will take you to cell B18. Step 3: It will create the hyperlink to cell B18. Select Place in this Document and Sheet Name. Now, if I want to keep going to Unit Sold total (B18), Unit Price Total(C18), and Sales Value (D18) total, it will be a lot of irritating tasks. At the end of the data, I have a grand total for all these 3 headings. I have a product list with their quantities sold, unit price, and sales value. We can go to the particular cell as well.
Ok, now we know how to open a specific file by creating a hyperlink. Example #2 – Create Hyperlink to Go to Specific Cell In my case, it will open the Sale 2018 file that is located on the Desktop. Step 8: if you click on this link, it will open up the linked file for you. I am giving the name as the file name only, i.e. Step 7: Now, for our understanding, we can give any name to it. Initially, it will create a hyperlink like this. I have selected the Article 1_hyperlinks file. Step 6: Select the files that you want to open quite often. Step 5: If you click on the specified folder, it will show all the files stored in it. In my case, I have selected Desktop and in desktop Hyperlink folder. Select the location of your targeted file. (By default, when you open hyperlink, it has already selected) In Tab 1, we have 4 options, and in Tab 2, we have 3 options.
Mainly there are two tabs available here.
Step 2: There are many things involved in this hyperlink dialogue box. (Shortcut to open the hyperlink) This will open the below dialogue box. Step 1: In the active sheet, press Ctrl + K. I cannot keep going back to the file folder and click to open the workbook rather, I can create a hyperlink to do the job for me. I am creating a Hyperlink to open the workbook that I use very often when I am creating reports.
You can download this HYPERLINK Excel Template here – HYPERLINK Excel Template Example #1 – Create Hyperlink to Open Specific File