What is a Scroll Bar in Excel? A Scroll Bar in Excel is like a slider bar. You can make a horizontal scroll bar or a vertical scroll bar. Moving the slider in the scroll bar will change the value of the cell that it is linked to. It works similarly to the Spin Button, […]
What is an Excel Spin Button? An Excel Spin Button is a button made up of an up arrow and a down arrow. Each time you click an arrow, a value will increase or decrease by a certain amount. In other words, when you click the up arrow, the value increases. Click the down arrow […]
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 […]
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.
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 […]
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 […]