Well, that’s it! A really useful thing to know! If you want decimals … well, see if you can work out how to make that work … it’s not too difficult! you can only use integers for the values to put into the scroll bars minimum value, maximum value and incremental value, that is.arrange them as YOU want … remembering who will use you work and how.

Now click away from the scroll bar to deselect it and then use it!.Finally, click on the cell link: this is the cell where your appraisal score will appear … in the section 3 screenshot we would choose cell link F26 for the score for “Delivering results and quality”.leave the page change at 10 … if you click in a scroll bar next to the slider rather that on the scroll bar arrows, your numbers change by 10 not incrementally one by one … change it to 3 or 5 of 20 as you wish.we want the incremental change to be 1 … that is, if you use the Windows version of Excel, click on the scroll bar arrows and the bar moves one number at a time.we want the maximum value to be 100 … in your case that might not be true.the current value is 0 … in some cases this might not be true, it depends which cell you have selected when you create the scroll bar … change it to WHATEVER value you want … 0 is fine here.

Creating cell menues in excel for mac