Developer tools in Microsoft Excel
The Option for the slider is located in the so-called "developer tools". With the normal settings will not be visible and must be displayed:
- You go in Excel, in the top left corner "file" > "options".
- Select customize on the left "ribbon".
- To the right you will see the window "main tabs". You put the check in the "developer tools" and confirm with "OK".
Slider in Excel-insert table
- Go to the tab "developer tools".
- Go to "Insert" and select the third icon of the second row ("bar to Move the window content").
- The mouse pointer turns into a cross. Click and drag a box in the desired size and orientation on the Excel spreadsheet.
- The control set up is complete, click with the right mouse button and select at the bottom "format control...".
- Here you can define the cell link as well as the desired values. You can then use the Element in Excel.
Slider in Excel
The manual refers to the Microsoft Office Excel 2010 under Windows 8 Pro. With the developer tools, for example, a drop can create a list. As the exactly is going on, you will learn in this practical tip.
