Drop Down List of Hyperlinks - Excel Tip

In this video, we create a drop-down list of hyperlinks to other sheets in the workbook.

I have created videos in the past on the HYPERLINK function and creating dynamic links from text on the worksheet.

In this video, though it is selected from a dropdown. A great idea for a report, table of contents or dashboard page. Where space is limited but you want simple and dynamic ways to navigate.

For this to work, we got smart we some Excel formulas using the INDIRECT and ADDRESS functions.

Find more great free tutorials at;


*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ►
Excel VBA for Beginners ►
Advanced Excel Tricks ►
Excel Formulas Made Easy ►
Creating Sports League Tables and Tournaments in Excel ►

Connect with us!

Google+ ►
Facebook ►
Twitter ►

Microsoft Excel,Excel Hyperlinks,INDIRECT Function,Excel Formulas,Computergaga,