PlayInfoBox

Home /Utilities /How to Link a Cell to Another Sheet in Excel

How to Link a Cell to Another Sheet in Excel

Tap through the steps below to see exactly how it works.

  1. Select the cell for your link

    Click the cell you want to turn into a button that jumps to another sheet.

  2. Choose "Place in This Document"

    In the panel on the left, select "Place in This Document".

  3. Pick the destination sheet and cell

    Choose the sheet you want to link to, and if needed, type the exact cell reference to land on.

  4. Why this is useful

    In a workbook with many tabs, build a "Table of Contents" sheet with links to every other sheet, and you can jump to any section instantly instead of hunting through tabs.

Build a table of contents sheet

In workbooks with a dozen or more tabs, clicking through each one to find the right sheet wastes time. Create a dedicated "Contents" sheet, list every sheet name in a column, and turn each one into a link. Now the entire workbook is navigable from a single home page.

Keep links working when you rename sheets

Internal hyperlinks in spreadsheets point to a sheet name and cell address, not a fixed ID. If you rename a sheet or move data around after creating a link, the link can break silently. Get your sheet names finalized before you start linking, or plan to re-check every link after a big reorganization.

Frequently Asked Questions

Can I add a way to jump back to the original sheet after clicking a link?

Yes. Add a matching link back on the destination sheet, or simply click the sheet tab directly to return β€” both work fine.

Does renaming a sheet break the link?

It can. Internal links reference the sheet by name, so renaming it afterward may disconnect the link β€” always double-check and re-link if needed after a rename.