HomeTechnologyNewsHow to link to another sheet in Microsoft Excel

How to link to another sheet in Microsoft Excel

- Advertisement -
- Advertisement -
- Advertisement -
- Advertisement -

[ad_1]

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 worksheet 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 just have a large workbook with dozens and dozens of sheets.

You can make it easy for yourself or those you’re collaborating with to view 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 Worksheets

Choose the cell you want to link. Go to the Insert tab and select Links > Insert Link or right-click in the cell and move the cursor to Link > Insert Link.

Insert Link in Link Popup Menu

When the Insert Hyperlink window opens, choose “Place in this document” on the left. On the right, you will see Cell Reference and Defined Names. Expand Cell Reference, if necessary, by clicking the plus sign.

Expand the cell reference to see the list of sheets

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

Sheet list and row of tabs

Select the sheet you want to link to the highlighted one. If you just want to link to the sheet, you can leave the “Type cell reference” field in the default cell A1. This is the top left cell of the sheet.

Selected sheet with default cell

But, if you want to link to a particular cell in the spreadsheet, enter the cell reference in that box.

Selected sheet with a certain cell

When finished, click “OK” to apply the link to the cell. So, give it a click! You should jump directly to the other sheet, or cell within it if you designated one.

Cell linked to a sheet in Excel

Edit or delete a link in Excel

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

RELATED: How to remove hyperlinks in Microsoft Excel

Right-click the cell containing the link and choose “Edit Hyperlink” to make a change or “Remove Hyperlink” to remove the link.

Edit hyperlink and Delete hyperlink in context menu

You’ll notice 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 a minute or two to set it up if it saves you time navigating to the sheet later, especially if you have to scroll through the sheet’s tab bar to find him. .

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

[ad_2]

- Advertisement -
- Advertisement -
Stay Connected
16,985FansLike
2,458FollowersFollow
61,453SubscribersSubscribe
Must Read
- Advertisement -
Related News
- Advertisement -