Everything about linking in Excel what you did not know and was too afraid too ask. In this article, we will learn how to link different types of objects in Excel, including hyperlinks, documents, objects, and text boxes. We will also learn how to check if an Excel file is linked to another.
First things first. Let’s start from something easy.
How to insert a hyperlink?
Learn how to create hyperlinks in Microsoft Excel effortlessly:
Click on the “INSERT” tab and then click on “Hyperlink”.
To link to a document on your computer, use the “look in” feature to locate the folder and select the desired document.
If linking to a website, simply enter the website’s name in the Address bar.
Besides documents, you can also link images, songs, and videos to your Excel file using Hyperlinks. These links will appear in BLUE color.
How to Link Two Documents
Linking different Excel files to each other is what we will be doing together.
Create two different Excel files.
Open the document, which you want to link another one to.
Copy and paste the values.
Click under Total, type =B5+C5.
Double-click on the small square in the cell’s bottom-right corner.
In the source document, copy the desired data.
Return to the target document.
Right-click on the cell under Price and choose Paste Special.
Select Paste Link.
By linking documents, changes in one document will instantly update the linked data in the other. This is valuable for efficient reporting in business scenarios.
How to Link Objects
Follow the steps below to learn how to create linked objects in Excel.
Open both Word and Excel document hat contains the data that you want to create a linked object.
In Excel select the range of cells (containing data) or the charts that you want and copy them (CTRL + C)
Next, go to Word and then click where you want the information to appear. On the Home tab click on Paste and select Paste Special. In the As list select Microsoft Office Excel Object.
Click Paste or Paste Link.
Click on the Insert tab and then click on Table and then click on Excel Spreadsheet. Fill in the worksheet with the information you want.
You can also insert an object to your spreadsheet.
To do that just click on insert and then on shapes .
Choose a drawing object.
Press and hold the left button on the mouse while moving the mouse to draw the object.
Linking Text Box to a Specific Cell
Here’s how to link a TextBox to a specific Excel cell:
- Go to the Insert tab in the ribbon.
- Click the Text Box button.
- Draw a text box on your worksheet.
- Select the text box.
- In the Formula Bar, type the address of the cell (e.g., B2).
- Your text box will display the content of the linked cell.
How to check if an workbook is linked to another?
Learn how to check if an Excel file is linked to external workbooks or references:
- Use Ctrl + F to open the Find dialog.
- Type “.xl” in the Find what box.
- In the Within box, select “Workbook”.
- In the Look in box, choose “Formulas”.
- Click “Find All”.
If there are any external links it will show up like above.
Advanced Excel Linking Techniques
Here are some advanced techniques for linking data in Excel:
- Hyperlink to specific cells: You can create hyperlinks that point to specific cells within a worksheet. This can be useful for navigating to frequently used data or for creating dynamic hyperlinks that change based on the data in the worksheet.
- Create dynamic hyperlinks: You can use the HYPERLINK function to create hyperlinks that change based on the data in a worksheet. This can be useful for creating hyperlinks that point to websites, files, or other resources that are referenced in the worksheet.
- Consolidate data with external links: You can use Excel’s linking capabilities to consolidate data from multiple workbooks or worksheets into a single location. This can be useful for creating summary reports or for analyzing data from multiple sources.
- Manage links effectively: As your Excel workbooks become more complex with numerous links, it is important to manage them effectively. This includes regularly auditing your links to ensure they are up to date and functioning correctly.
By mastering these advanced linking techniques, you will be better equipped to handle complex data analysis and reporting tasks in Excel.