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. Click for 60-day free trial!
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.
Recommended Productivity Tools
Office Tab: Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.Try now
Kutools for Excel: 200 new features for Excel, make Excel much easy and powerful, increase productivity immediately.Try now
Create 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
List hyperlinks to each sheet
(1) List all opening workbooks;
(2) List all sheets of active workbook;
(3) Show the total number of sheets.
Click for 60-day free trial!
Create 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.
Kutools for Excel - Combines More Than 120 Advanced Functions and Tools for Microsoft Excel |
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.
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.
Kutools for Excel - Combines More Than 120 Advanced Functions and Tools for Microsoft Excel |
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:
Demo: create hyperlinks to another worksheets or workbooks
Tip: In this Video, Kutools tab and Enterprise tab are added by Kutools for Excel. If you need it, please click here to have a 60-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. Click for 60-day free trial!
Recommended Productivity Tools
Office Tab
Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.
Kutools for Excel
Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!
200 New Features for Excel, Make Excel Much Easy and Powerful:
- Merge Cell/Rows/Columns without Losing Data.
- Combine and Consolidate Multiple Sheets and Workbooks.
- Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
- Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
- More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...
Comments
i really liked it
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
Thank you
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.
=sum(Sheet1!Column:Column)
Many thanks for any help.
A use case for this would be having a table of contents with titles that autoupdate across a number of sheets.
I need to hyper link the individual sheet with their names in the single spread sheet.Kindly help me.Thanks in advance.
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
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???
I am useing this tool this so nice and super tool.
Thanks Team.
Regards & thanks
Tinku Singh
=+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.
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
Cell No. +92-0300-415104 4
actually this is my personal laptop and i am student , i don't have access to and company server, please help me out.