WOW! Dynamic Scroll & Sort Table in Excel

Dashboards have limited space, which is why tables that allow you to scroll, and sort are super handy.

In this video I show you how to link dynamic array formulas to form control buttons and scroll bars to control the sorting and rows visible in the table.

⬇️DOWNLOAD the template file here: https://www.myonlinetraininghub.com/e...

🎓DASHBOARD COURSE technique for earlier versions of Excel: https://www.myonlinetraininghub.com/e...

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

📢 Please leave me a COMMENT. I read them all!

🎯 CONNECT with me on LinkedIn:   / myndatreacy  

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...



⏲ TIMESTAMPS
0:00 How to Create a Scrolling Table in Excel
0:38 The data
1:06 Activating the Developer Tab
1:28 Inserting Option Buttons
3:07 Inserting the Scroll Bar
3:26 Linking Form Controls to Cells
4:33 Symbols for Sort Order
5:37 Linking Scroll Bar to a Cell
6:16 Naming Form Control Cells
6:28 Formula for Scroll & Sort Table
8:35 Conditional Formatting Selected Column