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: 300 new features for Excel, make Excel much easy and powerful, increase productivity immediately.Try now

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.

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:

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!

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

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