Drop Down List of Hyperlinks - Excel Hyperlinks 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. 5 great INDIRECT function examples - https://youtu.be/rYdAsxf9EG0 Here are the video timings. 00:00 - Introduction 00:59 - Create the drop-down list 01:38 - Explanation of our approach 02:53 - Sample link in the drop-down 03:37 - INDIRECT function to hyperlink to another sheet 06:58 - Demonstrate the completed drop-down hyperlink list Find more great free tutorials at; https://www.computergaga.com