Dashboards have limited space, which is why tables that allow you to scroll & sort are a must.
‍ Excel Dashboards course: https://bit.ly/3ymPBbT

️ Download the example file here and follow along: https://bit.ly/4d8aE11

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

They enable us to embed an extract of data from a larger table in our Dashboard. Users can then scroll to see all the records and toggle which column to sort by and set the sort order.

In this video, I’m going to use dynamic array formulas which are available in Excel 2021 and 365. If you don’t have dynamic arrays, there is an alternate solution for earlier versions of Excel which I cover in my Excel dashboard course and you’ll find a link to it in the video description.

LEARN MORE
===========

EXCEL NEWSLETTER – join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up

FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/

EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum

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

#Excel #ExcelDashboard #ExcelTutorial

Please take the opportunity to connect and share this video with your friends and family if you find it useful.