How to create Hyperlink to link spreadsheets in Excel
By creating Hyperlink in Excel spreadsheets, we can access any web page or manage spreadsheets in different sheets in the same data file. This makes it easier for users to move between spreadsheets, especially active files with multiple sheets, saving time and manipulation while working on Excel.
There are many different tricks for using Excel Hyperlink. And how to create Hyperlink in Excel between spreadsheets is different from creating Hyperlink in Excel with normal data. The following article Network administrators will guide you how to create Hyperlink to move to another spreadsheet in the same Excel file, and create Hyperlink to link to a completely new data file.
1. Create Hyperlink to link the workbook and Excel file:
How to create this Hyperlink will help you to link the spreadsheets located in the data sheets in the same Excel file together.
For example, with the spreadsheet below, an Excel file consists of 3 different working sheets. The first worksheet is List A1, and we will proceed to create Hyperlink to link with the remaining spreadsheets including List A2 and A3 List.
Step 1:
Select the cell containing the data to which you want to link to another spreadsheet. Then, right-click and select Hyperlink . in the drop-down list.
Step 2:
In the Insert hyperlink dialog interface, we select the Place in This Document item in the list to the left of the interface. Then look to the right of the Cell Referenc e entry, check the worksheet that we want to create the link and click OK .
The spreadsheet results will look like the image below. When we click on the created Hyperlink, you will be immediately transferred to the linked worksheet.
2. Create Hyperlink linked to another Excel file:
This way will help you quickly open another Excel file saved in your computer.
Step 1:
Also in the spreadsheet, select the data box you want to create a link to another Excel worksheet, then right-click and select Hyperlink . in the list.
Step 2:
Also appears the Insert hyperlink dialog interface. Here, click on Existing File and Web page on the left side of the interface.
To the right, we find the folder containing the Excel file we want to add to the link , click and then click OK .
When you return to the spreadsheet you will also see the Hyperlink link created. If you click on it, the Excel file will be opened.
So with creating Hyperlink on Excel, we can create links with Excel spreadsheets in the same file or with a separate file. This will help you manage and open the data sheet faster, saving you time when working.
I wish you all success!
You should read it
- This is a simple way to find and delete Hyperlink in Excel
- Instructions on how to create Hyperlink in Excel
- How to create Hyperlink to link in Excel
- How to use the Hyperlink function in Excel
- Create Hyperlink in Excel
- How to create hyperlinks in excel is extremely useful
- How to create links in PowerPoint
- How to Insert Hyperlinks in Microsoft Excel
May be interested
- Insert images into Word 2016 and align images in Word 2016adding images to word 2016 is a way to make your document more attractive, easily highlighting important information with photos and adding emphasis to existing text.
- How to edit images in Word 2016photo editing, image formats in word 2016 will make images appear more professional in word, you can make cards, make cards and many other types of documents easier in word 2016 without the need for additional software.
- How to use Excel Online online for freeexcel online is located in the completely free microsoft office online suite with full features, from the ability to create spreadsheets, use calculation functions, ...
- How to use Word Online to edit text onlineword online is located in microsoft's online office editor. users will not need to install the software, but can still edit content with all the same features as office word.
- Turn your Google spreadsheet into a brilliant rainbowworking with spreadsheets has almost never come with the word 'fun' because the numbers and calculations always hurt you. but with a little change from google below, your spreadsheet will become much more attractive.
- Summary of common Microsoft Word shortcutsword shortcuts help to manipulate faster text processing, save time and increase professionalism for users.