This tutorial demonstrates how to link Excel files or Google sheets.
Link Files in Excel
In your Excel file, you can easily link a cell to another workbook using links. This works the same as inserting hyperlinks in your document. To link to another file in Excel, follow these steps:
1. Select the cell where you want to insert a link (here, B2), and in the Ribbon, go to Insert > Link. You can also right-click a cell and choose Link (or use the keyboard shortcut CTRL + K).
2. The Insert Hyperlink window opens with the Existing File or Web Page tab selected by default. Select the file to link (here, Link File.xlsx), enter the Text to display (Link File) – this is the text that will appear as the text of the link – and click OK.
By default, you’re taken to the same folder as the open workbook. To choose a file from a different folder, click on the Browse icon. In a similar way, you can link any other type of document (Word, PowerPoint, Picture, etc.).
As a result, a link to the Link File.xlsx file is inserted in cell B2. If you click on it, the file is opened in a new Excel window.
If you delete the linked file, you’ll get an error message when you click on the link. You can also use VBA to insert hyperlinks and link to another file in Excel.
Link Files in Google Sheets
Since all Google Docs and Google Sheets files are stored in Google Drive, you can’t browse for them in folders, so you need to use a hyperlink to another file’s URL. To link a Google doc from a Google sheet, follow these steps:
1. Copy the URL of your Google doc (you can find it in the address bar in your browser).
2. In your spreadsheet, select the cell where you want to insert a link to a file and in the Menu, go to Insert > Insert link. You can also right-click a cell and choose Link (or use the keyboard shortcut CTRL + K).
3. In the pop-up window, paste the link you copied, enter the text to display in the cell (If you don’t enter this text, the full link to the file in Google Drive is displayed.), and click Apply.
As a result, the link to the file is inserted in cell B2. When you position your cursor over the cell, you see the link and a preview of the document.