Just like linking to another place in a Word document, you can link to another sheet in an Excel workbook. This is a handy way to quickly jump to a spreadsheet related to your current sheet or cell.
Maybe you have a yearly budget with separate sheets for each month. Maybe you have a company workbook with a different sheet for each division. Or maybe you simply have a large workbook with dozens and dozens of sheets.
You can make it easy for yourself or those you’re collaborating with to see the data on another sheet with just one click.
Link to Another Sheet in an Excel Workbook
You can link a specific cell to another sheet whether that cell contains text, numbers, or even a formula.
RELATED: How to Cross Reference Cells Between Microsoft Excel Spreadsheets
Choose the cell you want to link. Either go to the Insert tab and select Links > Insert link or right-click the cell and move your cursor to Link > Insert Link.
When the Insert Hyperlink window opens, choose “Place in This Document” on the left. To the right, you’ll see Cell Reference and Defined Names. Expand Cell Reference, if necessary, by clicking the plus sign.
You’ll then see a list of the sheets in your workbook. From top to bottom the list shows sheets from left to right in the sheet tab row.
Select the sheet you want to link to which highlights it. If you simply want to link to the sheet, you can leave the “Type the Cell Reference” field at the default cell A1. This is the top left cell in the sheet.
But, if you want to link to a particular cell in the spreadsheet, enter the cell reference in that box instead.
When you finish, click “OK” to apply the link to the cell. Then, give it a click! You should jump directly to the other sheet, or cell within it if you designated one.
Edit or Remove a Link in Excel
After you add a link to another sheet, you may want to edit or remove it. Maybe you decide to link to a different cell or sheet, or simply delete the link altogether.
RELATED: How to Remove Hyperlinks in Microsoft Excel
Right-click the cell containing the link and pick “Edit Hyperlink” to make a change or “Remove Hyperlink” to delete the link.
You’ll notice that you can open the link using the right-click shortcut menu as well.
Because it’s so easy to link to another sheet in an Excel workbook, it’s worth a minute or two to set it up if it saves you time from navigating to the sheet later—especially if you have to scroll through the sheet tab bar to find it.
For more, look at how to link to another document in your Excel spreadsheet.