How do I add sliders in Excel 2013?
[Pages:4]How do I add sliders in Excel 2013?
1) Turn on DEVELOPER Open Excel, then File, Options, Customize Ribbon, Check Developer
2) Insert Scroll Bar (Slider) from Developer Tab Developer, Insert, Scroll Bar (Under Form Contols) then left click and size control bar
3) Customize Slider Right click on Slider, Format Control
4) Select Slider Options ? Min and Max Values
5) Select Slider Options ? CELL LINK You need to decide what cell you want your slider value to be stored in Click cell link, click cell in spreadsheet where you want sliders values to go
6) Test your slider Click off of the slider and then back on it and scroll right and left (or up and down) Your sliders values should now be linked to the cell you chose
7) Join your slider to your table value You will now need to change the formula in your "yellow" cell to link your slider to the table. The slider is programed to return 1 to 20. If you want your values to be -10 to 10, then change the formula in the yellow cell to (linked cell) ? 10
8) Repeat the process until you've added all sliders that you wish to add.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- how to add last updated date to footer in excel
- the basics of using sas excel add in
- how do i add sliders in excel 2013
- adding bullets in excel
- creating a slider in excel
- creating a macro library file
- adding document groups
- adding error bars to excel graphs
- using ods to generate excel files sas support
- excel formulas and functions for dummies cheat sheet for
Related searches
- how do i invest in stocks myself
- how do i start investing in stocks
- how do i invest in marijuana stocks
- how to add formulas in excel sum
- how do i believe in myself
- how do i write an excel formula
- how do i add apps to desktop
- how do i add apps
- how do i add icons to desktop
- how do i add icon to desktop
- how do i add icons on desktop
- how to add columns in excel sum