An Excel scroll bar can be used for practical (and sometimes boring) things, like testing the effect of price changes, or adjusting a chart’s date range. But this is the festive season, so let’s use a scroll bar for something more, well, festive!
Trim the Tree
In this example, instead of accounting and finance, you’ll see how to use an Excel scroll bar to decorate a Christmas tree, without macros. Unfortunately, it can’t make hot chocolate or eggnog, so you’ll need to provide your own.
It’s not just for the holiday season though — the sample file has useful features that you can adapt to other workbooks too:
- Scroll bar lets users change a number quickly and easily
- A text box that displays a changing message based on VLOOKUP formula
- conditional formatting shows hidden cells when target number is reached
- named ranges make it easy to work with specific cells
Watch the Video
To see how the tree trimming scroll bar works, you can watch this short Excel video.
Video Link on YouTube: http://www.youtube.com/watch?v=6UCJCB2vtHA
Excel Scroll Bar Sample File and Instructions
For instructions on creating the Excel scroll bar file, and to download the sample file, please visit the Contextures website: Excel Scroll Bar Christmas Tree Example.