Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to create hyperlink in a cell to another sheet in the same workbook

Do you know how to create a hyperlink in a cell in one sheet to a specific cell in another worksheet in the same workbook? By doing this, you can quickly navigate to specific cell of another sheet by clicking the hyperlink in Excel. The hyperlinks will help you switch to the other worksheet and locate specific cell quickly. Here are two tricky ways to create hyperlinks to specific cell in another worksheet in the same workbook.

Create hyperlinks to specific cell in another worksheet with Hyperlinks

Create hyperlinks to each worksheet in one sheet with Kutools for Excel

Create multiple hyperlinks to all workbooks/files in one folder

Easily insert multiple hyperlinks (or macro buttons) that link to other worksheets in Excel

Normally we can insert a hyperlink to one sheet in one cell by Insert > Hyperlink in Excel. But, with magic Create List of Sheet Names feature of Kutools for Excel, we can quickly insert multiple hyperlinks or macro buttons to each worksheet of active workbook. Full Feature Free Trial 30-day!
ad create list of sheet names link
This Create List of Sheet Names utility also supports to batch insert multiple macro buttons to go to each worksheet (or other worksheets) in current workbook.

Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
  • Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
  • More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words...
  • Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum...
  • Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns...
  • Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Create Mailing List and Send Emails by Cell's Value...
  • Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
  • More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

arrow blue right bubbleCreate hyperlinks to specific cell in another worksheet with Hyperlinks

Actually, we can make hyperlinks to other worksheets with Hyperlinks command easily.

1. Select a cell in one sheet that you want to create a hyperlink to another sheet, and click Insert > Hyperlink. See screenshot:

2. In the Insert Hyperlink dialog box, please do as follows:
(1) Click the Place in This Document button in the Link to box;
(2) Select one sheet that you want to hyperlink to in the Or select a place in this document box;
(3) Enter the text you want to display for the hyperlink in the Text to display;
(4) If you want to hyperlink to specific data in the sheet, please specify the cell in the Type the cell reference.

3. Click OK.

Then the selected cell is added a hyperlink to the specific cell of specific worksheet in the same workbook. See the following screen shot:

Navigation Pane:
List hyperlinks to each sheet

(1) List all opening workbooks;
(2) List all sheets of active workbook;
(3) Show the total number of sheets.

Full Feature Free Trial 30-day!

ad navigation pane book sheet 0


arrow blue right bubbleCreate one hyperlink to each worksheet in one sheet with Kutools for Excel

If you want to create one hyperlink to each worksheet in one sheet of the same workbook, you may need to create a hyperlink for each worksheet again and again. But with Kutools for Excel's Create List of Sheet Names utility, you can quickly create a hyperlink for each worksheet in one worksheet quickly.

1. Click the Enterprise > Worksheet > Create List of Sheet Names. See screenshot:

2. In the Create List of Sheet Names dialog box, specify the settings as follows (see screenshot above):
(1) Please check the Contains a list of hyperlinks option in the Sheet Index Styles section;
(2) Type a name for the new worksheet into the Specify sheet name for Sheet Index box;
(3) Specify the position for the new Index sheet from the Insert the Sheet Index in drop down list;

3. Click the Ok button. And then it will add a new sheet and lists all worksheet names with hyperlinks for navigating to related worksheets. See screenshot below:

Kutools for Excel's Create List of Sheet Names tool can create a list of all worksheet names of the active workbook in a new worksheet, which contains hyperlinks or macro buttons for quickly navigate to other worksheets.


arrow blue right bubble Create multiple hyperlinks to all workbooks/files in one folder

Kutools for Excel’s Filename List utility can batch add multiple hyperlinks to all files or one type of files in a certain folder, such as create hyperlinks to all workbooks, to all word documents, to all text files, etc.

1. Click Enterprise > Import / Export > Filename List.

2. In the opening Filename List dialog box, please (1) specify the folder whose workbooks/files you will create hyperlinks to; (2) check the Specify option and then type the xlsx into below box; (3) check the Create hyperlinks option; (4) and click the Ok button. See screenshot above:

And now multiple hyperlinks are created and linked to all workbooks (.xlsx files) in the specified folder. See screenshot:


arrow blue right bubbleDemo: create hyperlinks to another worksheets or workbooks

In this Video, Kutools and Kutools Plus tabs are added by Kutools for Excel. If need it, please click for 30-day free trial without limitation!

One click to delete all hyperlinks in selected range, active sheet, or active workbook

For removing multiple hyperlinks in a selected range, Kutools for Excel’s Delete Hyperlinks utility can help you archive with just one click. This utility can also delete all hyperlinks in active sheet, selected sheets, or active workbook with just one click. Full Feature Free Trial 30-day!
ad remove all hyperlinks 2


Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Dennis · 6 months ago
    After linking one sheet to a second sheet, how can I hide the second sheet but still keep it active and responsive to the link?
  • To post as a guest, your comment is unpublished.
    Acehnk · 1 years ago
    Really helpful, well written, easy to follow...and it worked!
  • To post as a guest, your comment is unpublished.
    Snehal · 2 years ago
    I have to create relative path of images to excel sheet such that sheet is independent of location
  • To post as a guest, your comment is unpublished.
    ashish kumar · 2 years ago
    i am getting error your organisation's policies are preventing us from completing this action for you. for more information , please contact your help desk.
    actually this is my personal laptop and i am student , i don't have access to and company server, please help me out.
  • To post as a guest, your comment is unpublished.
    Jamal · 2 years ago
    I want to insert a hyperlink to a worksheet displaying the worksheet name dynamically, so if I rename the worksheet, the hyperlink display changes to the new name. is there a solution?
  • To post as a guest, your comment is unpublished.
    yogesh · 3 years ago
    Sir how can I link the excel document to another pc or server
  • To post as a guest, your comment is unpublished.
    Muhammad Shafeeq · 3 years ago
    Hi,

    I want to create different type of charts like District Wise, Specialty Wise, Private and Public etc. from one data source. is it is possible that i enter data in a sheet and excel filter them from District, Specialty and public or private based data.

    Waiting for your quick and positive response.

    Best regards

    Muhammad Shafeeq Rashid
    Email: mshafiqrashid@gmail.com
    Cell No. +92-0300-4151044
  • To post as a guest, your comment is unpublished.
    sfdgsg · 3 years ago
    "Do you know how to create a hyperlink in a cell in one sheet to a specific cell in another worksheet in the same workbook" If I did, I WOULDNT BE VISITING THIS FUCKING PAGE.
  • To post as a guest, your comment is unpublished.
    Deepak · 3 years ago
    Very Nice Sir thank u so much
  • To post as a guest, your comment is unpublished.
    Shohidur Rahman · 3 years ago
    Please solution below describe problem:
    =+Sheet1!E15 (This is the linked cell) I want to go directed sheet1, Cell-E15 from linked sheet (Sheet2) linked cell.
    How it's possible ? please give me a solution.
  • To post as a guest, your comment is unpublished.
    Octavio · 4 years ago
    What if I need the hyperlink to go to an specified cell and keeps following it even if I move that cell of its original place? hope you can answer, thank you
  • To post as a guest, your comment is unpublished.
    TINKU SINGH · 4 years ago
    i have a excel of two sheet , one sheet has a image and want to refer this image as a hyperlink on the first tab , could you please help me , how can i do that & may I ask how to direct the user to a certain row within the spread sheet when they click on the link within the course to access the file

    Regards & thanks
    Tinku Singh
  • To post as a guest, your comment is unpublished.
    Amar · 4 years ago
    hello,

    I am useing this tool this so nice and super tool.

    Thanks Team.
  • To post as a guest, your comment is unpublished.
    Michelle · 4 years ago
    Hi, may I ask how to direct the user to a certain row within the spread sheet when they click on the link within the course to access the file? :D
  • To post as a guest, your comment is unpublished.
    Cass Winterton · 4 years ago
    I have hyperlinked one cell to another in the same workbook. BUT how do I make if reference that same cell even if it moves?
    eg. i link sheet 1 cell A1 to sheet 2 cell A5. i then go and add a line into sheet two which now pushes A5 to A6. Is there a way of making sure my hyperlink will jump down to A6 as well???
  • To post as a guest, your comment is unpublished.
    mohsin khan · 4 years ago
    Thank you very Much Sir G,
  • To post as a guest, your comment is unpublished.
    sandeep · 4 years ago
    Hi
    i have a excel of two sheet , one sheet has a image and want to refer this image as a hyperlink on the first tab , could you please help me , how can i do that

    thanks
    sandeep
  • To post as a guest, your comment is unpublished.
    Zeeshan · 4 years ago
    hello sir i want to make a excel result finder i mean to say if i write a roll number and press inter after the result i see................ please tell me how to i do
  • To post as a guest, your comment is unpublished.
    Alberto · 4 years ago
    Thank you for this manual. It was very useful
  • To post as a guest, your comment is unpublished.
    Siddesh · 4 years ago
    How can we add a hyperlink to a particular string within a cell?
  • To post as a guest, your comment is unpublished.
    Titus · 4 years ago
    HI
    I need to hyper link the individual sheet with their names in the single spread sheet.Kindly help me.Thanks in advance.
  • To post as a guest, your comment is unpublished.
    Rita · 5 years ago
    very useful manula. Thx :)
  • To post as a guest, your comment is unpublished.
    Sherry · 5 years ago
    I did these steps when adding the hyperlink to a simple shape. When i opened the excel book on an iPad none of the pictures or text on the shapes appeared, and the hyperlinks didn't work. Do you know what could cause this?
  • To post as a guest, your comment is unpublished.
    Sherry · 5 years ago
    I did this, but when my boss opened the worksheet on his iPad the links didn't work. I connected them to shapes that I made with either pictures or words on them. The shapes appeared, but the pictures and words didn't, also the hyperlinks didn't work.
  • To post as a guest, your comment is unpublished.
    8gorkha · 5 years ago
    This helped a lot. Thanks.
  • To post as a guest, your comment is unpublished.
    Basavaraj · 5 years ago
    Its very useful thank you so much
  • To post as a guest, your comment is unpublished.
    Jeremy · 5 years ago
    Thanks for this help
  • To post as a guest, your comment is unpublished.
    Lucy · 5 years ago
    Can I create a link by name in stead of cell number, for example if my column A contains item A, Item B, Item C, and my worksheeet 2 have column A with same information, but with detail in column B, I want a link of items A in between worksheet in a dynamic way so that if I add items it will automatically link the cell between 2 sheets?
  • To post as a guest, your comment is unpublished.
    j sawyer · 5 years ago
    cannot print sent to email.
  • To post as a guest, your comment is unpublished.
    Michaela · 5 years ago
    Hi is it possible to have two identical sheets in one workbook, and whatever changes are made in the first sheet will automatically appear in the second sheet?
    Many thanks for any help.
    • To post as a guest, your comment is unpublished.
      Kenny P · 5 years ago
      Yup, you would have to link to the cell within the sheet.

      A use case for this would be having a table of contents with titles that autoupdate across a number of sheets.
  • To post as a guest, your comment is unpublished.
    charan · 5 years ago
    thank you soo much for giving me the valuable information
  • To post as a guest, your comment is unpublished.
    HARRY · 5 years ago
    SIR, HOW CAN I LINK CELL FROM SHEET1 TO A CELL OF SHEET2.
    LIKE A TOTAL OF A CELL LINKED TO A CELL OF DIFF. SHEET. AND IF I CHANGE THE AMT OF CELL OF SHEET1 THAN CELL OF SHEET2 AUTOMETICLY CHANGED.
  • To post as a guest, your comment is unpublished.
    Chelsea · 5 years ago
    Great How To, very user friendly. Thank you. Is there any way to go a step further and filter the view of the worksheet that is being hyper-linked? I click on a name on one sheet and it hyperlinks to another sheet in a filtered view? (All in same workbook)
    Thank you
  • To post as a guest, your comment is unpublished.
    ashish · 5 years ago
    Thank you. keep up the good work of spreading knowledge.
  • To post as a guest, your comment is unpublished.
    jaishiv meena · 5 years ago
    thanks you so much ,very useful.
  • To post as a guest, your comment is unpublished.
    monkeydude · 5 years ago
    hey..

    i want to create a link to an Excel file on a website. however, i want the link to direct it to a specific sheet

    how do i go about this

    thanks for the help
  • To post as a guest, your comment is unpublished.
    ali · 5 years ago
    thank you :-)
    i really liked it
  • To post as a guest, your comment is unpublished.
    uruser · 5 years ago
    this link was very useful . very well written and simple to use