Description
In this video I'll show you how to link to another sheet in Microsoft Excel. You can pull a value from another sheet into a formula, so it updates automatically, or you can add a clickable link that jumps right to that sheet.
Timestamps:
Introduction: 0:00
Pull a Value from Another Sheet: 0:18
Insert a Clickable Link to a Sheet: 1:28
Use the HYPERLINK Function: 2:27
Conclusion: 2:48
Check out my website for other great tutorials about all kinds of technology: https://maxdalton.how/
Support this channel by becoming a member: https://www.youtube.com/channel/UCBbDWMccTJCL0WmbMHNLZIw/join
#excel #microsoftexcel #exceltutorial #techtips #tutorial
Video Transcript:
Step 1. Open your Excel workbook. For this example, I'm using a comic book shop's sales workbook, with a Summary sheet and separate sheets for July, August, and September. Each month's sheet has a total at the bottom, in cell D14.
Step 2. On the Summary sheet, click in cell B2, next to July, and then type an equal sign.
Step 3. Click the "July" sheet tab at the bottom of the screen, and then click cell D14.
Step 4. Press "Enter" on your keyboard. Excel takes you back to the Summary sheet, and cell B2 now displays July's total, 6359.31. If you click cell B2, the formula bar shows =July!D14, which is the sheet name, an exclamation point, and the cell.
Repeat these steps for August and September. If a sheet name has spaces in it, Excel automatically adds single quotes around the name in the formula.
Next let's look at how to add a clickable link to a sheet in Excel.
Step 1. Click in cell C2, and then click the "Insert" tab at the top of the screen.
Step 2. Click "Link" in the Links group, or press Ctrl+K on your keyboard. The Insert Hyperlink window opens.
Step 3. Click "Place in This Document" in the menu on the left side of the window.
Step 4. Click "July" in the list of sheets. The Type the cell reference box shows A1, so the link opens at the top of the sheet. You can type a different cell here if you want.
Step 5. Replace the text in the Text to display box at the top of the window with something like Go to July, and then click "OK." The text appears as a link in cell C2. Click it, and Excel jumps straight to the July sheet.
You can also create the same link with a formula. Click a cell, like C3, type =HYPERLINK("#July!A1","Go to July"), and press "Enter." Excel builds a clickable link to that sheet. The pound sign tells Excel the link points to a place inside the current workbook.