Slider or Scroll Bar via Data Validation
I would like to see a slider or scroll bar become an in-cell data validation option (just as I'd like to see a date picker for dates and a new checkbox option).
This feature could be integrated into the "Whole number" validation criteria with a simple checkbox like "Show scroll bar".
When you double-click or double-tap the cell to edit the value, the scrollbar could appear immediately below or above the cell, as shown in the attached image. (For this image, I used a form field scroll bar, but I think it gets the point across).
I'd like to see this added to all versions of Excel. It would be especially useful when using a touch interface.
Jon Wittwer
shared this idea
2 comments
-
Jon Wittwer
commented
SCROLL BAR:
When you click on a cell that uses a scroll bar data validation option, the scroll bar could appear to the right or left of the cell, allowing you to easily change the number in the cell. Keyboard Behavior: Alt+Right or Alt+Left will incrementSPIN BUTTON:
When you click on a cell that has a number, the spin button would show up to the right of the cell, letting you click Up or Down to increment or decrement the value by 1 (or allow the increment to be specified in the settings). Keyboard Behavior: Pressing Alt+Up or Alt+Down will increment. -
Jon Wittwer
commented
The length of the slider should not be limited to the width of the cell. The slider would need to have a minimum length to be functional. It could extend beyond the width of the cell, like the list box kind of does.
