How to Link to Another Sheet in Microsoft Excel

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 table related to your current sheet or cell.

Maybe you have an annual budget with separate sheets for each month. Perhaps you have a company workbook with a different sheet for each department. Or maybe you just have a large workbook with dozens of sheets.

You can make it easy for yourself or your colleagues to view 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.

TIED TOGETHER: How to reference cells between Microsoft Excel spreadsheets

Select the cell you want to link. Either go to the Insert tab and choose Links > Insert Link, or right-click the cell and move the cursor to Link > Insert Link.

When the Insert Hyperlink window opens, select Insert into this document on the left. On the right side you see cell reference and defined names. If necessary, expand the cell reference by clicking the plus sign.

You will then see a list of sheets in your workbook. From top to bottom, the Sheets list shows from left to right in the row of sheet tabs.

Select the sheet you want to link, which will highlight it. If you just want to link to the sheet, you can leave the Enter Cell Reference field on the default cell A1. This is the top left cell in the sheet.

However, if you want to link to a specific cell in the spreadsheet, enter the cell reference in this field instead.

When you’re done, click OK to apply the link to the cell. Then just click in! You should jump straight to the other sheet or a cell in it if you have one set.

Edit or remove a link in Excel

After adding a link to another sheet, you may want to edit or remove it. You may want to link to another cell or sheet, or just delete the link altogether.

TIED TOGETHER: How to remove hyperlinks in Microsoft Excel

Right-click the cell with the link and choose Edit Hyperlink to make a change or Remove Hyperlink to delete the link.

You’ll find that you can also open the link using the right-click context menu.

Because it’s so easy to link to another sheet in an Excel workbook, it’s worth setting up if it saves you time navigating to the sheet later — especially if you need to scroll through the sheet’s tab bar to find it .

For more information, see To link another document in your Excel spreadsheet.