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 one hyperlink to each worksheet in one sheet with Kutools for Excel good 3

Create multiple hyperlinks to all workbooks/files in one folder

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. See screenshot below:

ad remove all hyperlinks 2

Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Read More      Free Download Now

Recommended Productivity Software

Office Tab: Use tabbed interface in Office as the use of web browser Chrome, Firefox and Internet Explorer.
Kutools for Excel: Adds 120 powerful new features to Excel. Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Brings back your familiar menus to Office 2007, 2010 and 2013 (includes Office 365).

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

Hint


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:


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.

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. Free Download Kutools for Excel Now


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.

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:

Read more         Free Download Kutools for Excel Now


Is your problem solved?

Recommended Productivity Tools

The following tools will greatly save your time and effort, which one do you prefer?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: 120 powerful new functions for Excel, Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 More than 120 powerful advanced functions which designed for Excel:

  • 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...

Screen shot of Kutools for Excel

btn read more     btn download     btn purchase

Add comment


Security code
Refresh