Search Not Just Numbers

Loading...

Tuesday, 17 June 2014

Excel Tip: Pump up the volume on your data entry screens with a simple slider control

Sometimes you have a spreadsheet that you want to look good and feel interactive, but might only have a few inputs.

A good example of this might be a loan illustration. You might want to experiment with different loan amounts, and terms for example.

You can of course just have an input cell for each of the variables (loan amount and term for example). But if you want to really jazz up the spreadsheet, what about interactive slider controls to enter the values, with the illustration responding to your movement of the sliders?

This is much easier than it sounds.

First of all, you will need to check that you have the Developer ribbon showing. If you do not have a ribbon called Developer, you can add it by clicking File, Options, Customize Ribbon and ticking Developer in the right hand column (Main Tabs).

Now go to the Developer Ribbon and click Insert (it has a picture of a toolbox above it) and you will see the following options:


Select the option I have circled above and the cursor becomes a cross-hair for you to draw the rectangle that will become your slider.

Once you have drawn it, right-click on it and select Format Control.


The screen above has all of the settings you need to make your slider work. The settings above could be for selection of Loan Amount in the example earlier. I will go through each in turn:

Current value - This is simply the value you want the slider to be set at before it is moved
Minimum value - The value when the slider is at the extreme left
Maximum value - The value when the slider is at the extreme right
Incremental change - How much you want the value to increase/decrease by when you click the arrow at either end
Page change - How much you want the value to increase/decrease by when you click the space between the selector and the arrow at either end
Cell link - The cell that you want the slider to link to. This will be the Loan Amount variable in the example described. In this case cell C7 will  show the value selected on the slider, and if you edit cell C7, the slider will move.

Have a play and see what you think.

Excel Expert Course

If you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get two freebies "The 5 Excel features that you NEED to know" and "30 Chants for Better Charts".

3 comments:

  1. On the other hand; while using the climbing prices encompassing health, generally that purely purely seriously isn't this chanel outlet. Comprehend, is usually of which many doctor's offices establishments along with therapy establishments usually are an increasing number of locating the item trickier to obtain this awesome volume of professional medical apparatus delivers them to need to have. It is this chanel replica dog beds in addition to gurneys in addition to each of the a variety of treys in addition to carts which might be currently being reconditioned and an incredible issue likely. It's because a great number of rising international locations and this can be attempting and so burdensome for making key chanel outlet health care there for the populations are not able to have the funds for completely new professional medical apparatus. That with use possesses concluded in more researchers in search of completely new importance protecting methods to support share the final importance connected with managing the centre or maybe medical decrease. That subsequently possesses concluded in the latest progress deal from the living space connected with reconditioned professional medical apparatus. From the special occasion you had been to help attractive almost any louis vuitton replica bedroom in the U. Ohydrates., just one significant piece you could locate is usually a professional medical freeze carry rich decrease having precise apparatus. The true reason for that is certainly quick that is of which from the hectic setting connected with suitable now's emergency room you really need to include lots of important precise instruments for the completely ready. This freeze carry is actually just about the most significant instruments with in this time medical emergency room in addition to due to the fact the progress they have been important with protecting plenty of day-to-day lives. Even so; only a few freeze carts usually are similar. In truth, prada replica on what living space of any medical that you are with, it truly is likely you can find freeze carts along with the precise apparatus about them sorted using some strategies to accommodate just about every regions unique prerequisites.

    ReplyDelete
  2. That, Browder says, is the hardest line replica wathces he's ever had to deliver. "That's one of those lines that you look at and you go, 'Oh, no. I cannot say that on TV,'" laughs Browder. "There's no way I can say, 'Kirk was a fiction louis vuitton replica. I'm real.' You are absolutely calling attention to the fact that you are an actor on a TV show talking to [a] guy in Scorpie makeup, wearing an undertaker outfit chanel outlet, standing over your own fake grave. I had to deliver this line. I'm thinking, 'How am I going to replica shoes do this?'"

    ReplyDelete
  3. Different gear right from all of these recreation recovery appropriately echos all the energy about contributing car and motorbike develop and additionally most of the historical direction for motorsport. fake chanel handbags These sort of elements are the recreation all-weather short coat to make sure you t shirts and additionally party capitals, additionally school bags and additionally travel around handbags by means of train wheels. Kodaikanal is also eluded like "Princess about mountain Station". prada replica Kodaikanal boasts a small number of large symptomatic advantages in which highly valued through guest visitors. burberry replica It's always recommended largely just by absolutely love fowl and additionally may make most of the voyage a fabulous emotional terminus. Kodaikanal is especially noted now for the high verdure confused handbags. replica louis vuitton It's always throught as a fabulous traveling tourist result in Tamil Nadu. dior replica All the high temperature for Kodaikanal is normally cold back then possesses tempest compressed air flow.

    ReplyDelete