It could be to help us to control graphs or dashboards as we will see later.
It could be just to get one piece of information or many. The purpose of the scroll bar can be to get a piece of information and use that to create the kind of table we have just seen under the revious example. Thanks to Blog Member azamtokhi for encuraging me to add these! This relates to a NEW example. One more thing, what we have created is a form based scroll bar not an ActiveX scroll bar … not that it really matters here!įollowing on from a comment I have added the following together with a file that you should find helpful. Well, that’s it! A really useful thing to know!
#EXCEL 2016 FOR MAC SHOW SCROLL BARS HOW TO#
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.
#EXCEL 2016 FOR MAC SHOW SCROLL BARS WINDOWS#
0 kommentar(er)
