How to create a slider in Excel:

You can create a slider in Excel. This means that you don’t always have to set individual values manually. But: the option is well hidden.

Create a slider in Excel: Go to developer tools

The option for the slider can be found in the so-called “developer tools”. These are not visible with the normal settings and must first be displayed:

• In Excel, go to “File” ☻ “Options” in the upper left corner.

• Select “Customize Ribbon” on the left.

• On the right, you will see the “Main Tabs” window. Check the “Developer tools” box and confirm by clicking “OK”.

Insert a slider in an Excel spreadsheet

To insert a slider in an Excel spreadsheet, proceed as follows:

• Switch to the “Developer” tab.

• Go to “Insert” and select the “Window’s content slider bar” icon (two arrows, one pointing up, one pointing down).

• The mouse pointer turns into a selection cross. Click and drag the cursor to create a field of the desired size and orientation in the Excel spreadsheet.

• To fully customize the control, right-click right mouse button and select “Format Control…” at the bottom of the list.

• Here you can define the cell link and the desired values. You can then use the element in Excel.