A Scroll Bar in Excel is like a slider bar. You can add a horizontal scroll bar or a vertical scroll bar. Knowing how to add a scroll bar in Excel is such a great way to make your spreadsheet interactive! – As you move the slider in the scroll bar, it changes the value […]
Form Controls
Excel Spin Button: How to Add and Customize
Spin Buttons in Excel will instantly make your spreadsheet interactive and help it look more professional. Let’s take a look at how you can add an Excel Spin Button to your sheets. What is an Excel Spin Button? An Excel Spin Button is a button made up of an up arrow and a down arrow. […]
How to Add a Spin Button + a Slider to a Chart in Excel – Tutorial
Excel tutorial on how to insert a Spin Button in Excel and how to add a Slider to a chart in Excel. We’ll do this to make our example chart more interactive. The Spin Button will help us update our example chart by allowing us to update the year chosen by simply clicking up or […]
How to Use Option Buttons to Filter a Chart in Excel – Tutorial
Excel tutorial on how add Option Buttons to filter a chart. One of the Form Control tools, the Option Buttons will also help make the chart interactive. In the example in this tutorial, we’ll assign macros to the Option Buttons, or Radio Buttons, to filter the chart just by selecting a button.
How to Make Drop Down List + List Box Using Form Controls in Excel – Tutorial
Excel tutorial on a couple of ways to make lists in Excel where users can select items using Form Controls. We’ll create a drop down list and then make a List Box. We’ll do both using Form Controls. What are Form Controls??? Located in the Developer Tab, Form Controls in Excel are objects that make […]
Macro Buttons in Excel – ALL You Need to Know (+ video tutorial)
If you’ve recorded a macro to automate spreadsheet actions, you’ll need to know how to make a macro button in Excel. Automating your spreadsheet with macros can save you insane amounts of time. But, sifting through a list of macros to find the one you need can be a pain. Having a macro button to […]