How to Create a Vertical Scroll Bar in Excel

Поделиться
HTML-код
  • Опубликовано: 14 янв 2025

Комментарии • 2

  • @justind3172
    @justind3172 11 месяцев назад +1

    Hello, great video and this helped me have a big breakthrough for my dashboard! By chance, would you be able to provide a formula that allows me to insert a data validation/and or combo box for a particular column, to get specific results in the scroll window?

    • @exceldemy2006
      @exceldemy2006  11 месяцев назад

      Dear @justind3172,
      Thank you for your feedback. Regarding your question on how to show the results in the scroll window for a particular column.
      Yes, this can be done easily just follow the steps:
      Use the Data Validation to create a drop-down list with the column names. In our example, we chose the B4:E4 column headers.
      Use this updated formula: =INDEX($B$5:$E$34,$G$4+ROWS($B$5:B5),MATCH($I$4,$B$4:$E$4,1))
      Insert the vertical scroll bar from the Form Controls. The Format Controls of the scroll bar will remain the same as shown in the video. You are good to go!
      Download the sample Excel file from the link below:
      www.exceldemy.com/wp-content/uploads/2024/01/Create-a-Vertical-Scroll-Bar.xlsm
      Make sure to stay connected with ExcelDemy! 🎉❤. Have a good day.
      Regards,
      ExcelDemy