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 -    • 5 Excel INDIRECT Function Examples - Learn...   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 ** Online Excel Courses ** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2t3netw Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J Connect with us! LinkedIn ►   / 18737946   Instagram ►   / computergaga1   Twitter ►   / computergaga1