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
