How to Add Up and Down Buttons in Excel (2 Suitable Examples)

Sometimes you need to increase or decrease the cell value. It is tough to change cell value every time. In that case, Excel gives you a perfect solution to add up and down buttons through which you can easily increase and decrease cell value. This article will show you how to add up and down buttons in Excel effectively. I hope you find this article very interesting and informative.


Download Practice Workbook

Download the practice workbook below.


Steps to Add Up and Down Buttons in Excel

To add up and down buttons in Excel, you need to perform some valuable steps through which you can get the up and down buttons. All of these steps are fairly easy to understand. Before doing anything, you need to add the Developer tab on the ribbon. To include the Developer tab on the ribbon, follow the link How to Show the Developer Tab on the Ribbon.

  • First, go to the Developer tab on the ribbon.
  • Then, select Insert drop-down option from the Controls group.

  • After that, select Spin Button (Form Control) from the Insert drop-down option.

Gather Up and Down Buttons in Excel

  • Then, the mouse cursor becomes the plus (+) sign.
  • Drag the plus sign to give the shape of the up and down buttons in Excel.

Add Up and Down Buttons in Excel

  • Then, right-click on the up and down button.
  • Select Format Control from the Context Menu.

  • As a result, the Format Control dialog box will appear.
  • First, select the Control tab at the top.
  • Then, set the Current value, Minimum value, Maximum value, and Increment change.
  • Finally, define the Cell link.
  • Here, 30000 can be the maximum value. But if you think you need more then you can define cell link in another place. After that, use this cell reference to your desired cell.

  • As a result, you will get the desired up and down buttons in Excel.

2 Suitable Examples to Use Up and Down Buttons in Excel

To use up and down buttons in Excel, we have found two suitable examples through which you can have a clear overview of the topic. Here, we would like to show two examples including the monthly payment of a taken loan amount and the yearly earnings of an employee. Both of cases, we will utilize the up and down button. To understand it carefully, follow the examples.


1. Calculating Monthly Payment

In this example, we would like to calculate the monthly payment of a taken loan amount. Here, we take a dataset that includes the loan principal amount, annual interest rate, and loan duration. By using these, we will calculate the monthly payment. Follow the steps properly.

Steps

  • First, we need to calculate the initial monthly payment for given values using the PMT function.
  • To do this, select cell C8.
  • Then, write down the following formula.
=PMT(C5/12,C6*12,C4)

  • Press Enter to apply the formula.

  • Next, we need to add the up and down buttons for the dataset.
  • So, go to the Developer tab on the ribbon.
  • Then, select Insert drop-down option from the Controls group.

  • After that, select Spin Button (Form Control) from the Insert drop-down option.

  • Then, the mouse cursor becomes the plus (+) sign.
  • Drag the plus sign to give the shape of the up and down buttons in Excel.

  • Then, right-click on the up and down button.
  • Select Format Control from the Context Menu.

  • As a result, the Format Control dialog box will appear.
  • First, select the Control tab at the top.
  • As the loan principal amount is $15000, set this value in the Current value section.
  • Then, set the minimum value as zero.
  • After that, set the maximum value as 30000.
  • Then, provide the incremental change of 100.
  • Next, set the Cell link where you want to put your results.
  • Finally, click on OK.

Calculating Monthly Payment to Use Up and Down Buttons in Excel

  • As a consequence, you will get the desired up and down button in Excel.
  • Now, if you click on the up button, the loan principal amount will increase. At the same time, the monthly payment will also increase.

Estimating Monthly Payment to Use Up and Down Buttons in Excel

  • Then, if you click on the down button, the loan principal amount will decrease. At the same time, the monthly payment will also decrease.

Estimating Monthly Payment to Utilize Up and Down Buttons in Excel

  • Then, we would like to add up and down buttons for the annual interest rate.
  • Follow the same procedure as the previous one.
  • Here, you need to change the Format Control for this section.
  • Then, right-click on the up and down button.
  • Select Format Control from the Context Menu.

  • As a result, the Format Control dialog box will appear.
  • First, select the Control tab at the top.
  • As the current annual interest rate is 10, set this value in the Current value section.
  • Then, set the minimum value as zero.
  • After that, set the maximum value as 20.
  • Then, provide the incremental change of 1.
  • Next, set the Cell link where you want to put your results.
  • Finally, click on OK.

Computing Monthly Payment to Use Up and Down Buttons in Excel

  • Here, we use different cell link because we need percentages of the annual interest rate.
  • This cell reference will be used in the original place as a percentage.

  • Now, select cell C5.
  • Then, write down the following formula.
=F5%

  • Press Enter to apply the formula.

  • As a consequence, you will get the desired up and down button in Excel.
  • Now, if you click on the up button, the annual interest rate will increase. At the same time, the monthly payment will also increase.

Counting Monthly Payment to Use Up and Down Buttons in Excel

  • Then, if you click on the down button, the annual interest rate will decrease. At the same time, the monthly payment will also decrease.

Counting Monthly Payment to Utilize Up and Down Buttons in Excel

Read More: How to Make a Calculate Button in Excel (with Easy Steps)


Similar Readings


2. Calculating Yearly Earnings

In this example, we would like to calculate the yearly earnings of an employee. In a year earnings include monthly income and some additional income. Combing them for 12 months will get you the required yearly earnings. Follow the steps properly.

Steps

  • First, we need to calculate the yearly earnings for the initial monthly salary and additional monthly earnings.
  • To do this, select cell C6.
  • Then, write down the following formula.
=C4*12+C5*12

  • Press Enter to apply the formula.

  • Next, we need to add the up and down buttons for the dataset.
  • So, go to the Developer tab on the ribbon.
  • Then, select Insert drop-down option from the Controls group.

  • After that, select Spin Button (Form Control) from the Insert drop-down option.

  • Then, the mouse cursor becomes the plus (+) sign.
  • Drag the plus sign to give the shape of the up and down buttons in Excel.

Calculating Yearly Earnings to Use Up and Down Buttons in Excel

  • Then, right-click on the up and down button.
  • Select Format Control from the Context Menu.

  • As a result, the Format Control dialog box will appear.
  • First, select the Control tab at the top.
  • As the current monthly salary is $5000, set this value in the Current value section.
  • Then, set the minimum value as zero.
  • After that, set the maximum value as 20000.
  • Then, provide the incremental change of 100.
  • Next, set the Cell link where you want to put your results.
  • Finally, click on OK.

Estimating Yearly Earnings to Utilize Up and Down Buttons in Excel

  • As a consequence, you will get the desired up and down button in Excel.
  • Now, if you click on the up button, the monthly payment will increase. At the same time, yearly earnings will also increase.

Computing Yearly Earnings to exercise Up and Down Buttons in Excel

  • Then, if you click on the down button, the monthly payment will decrease. At the same time, yearly earnings will also decrease.

  • Then, we would like to add another up and down button for additional monthly earnings.
  • Follow the same procedure as the previous one.
  • Here, you need to change the Format Control for this section.
  • Then, right-click on the up and down button.
  • Select Format Control from the Context Menu.

  • As a result, the Format Control dialog box will appear.
  • First, select the Control tab at the top.
  • As the current additional monthly earnings are $300, set this value in the Current value section.
  • Then, set the minimum value as zero.
  • After that, set the maximum value as 1500.
  • Then, provide the incremental change of 10.
  • Next, set the Cell link where you want to put your results.
  • Finally, click on OK.

  • As a consequence, you will get the desired up and down button in Excel.
  • Now, if you click on the up button, the additional monthly earnings will increase. At the same time, yearly earnings will also increase.

  • Then, if you click on the down button, the additional monthly earnings will decrease. At the same time, yearly earnings will also decrease.

Counting Yearly Earnings to Use Up and Down Buttons in Excel

Read More: How to Create a Macro Button in Excel (3 Quick Methods)


Things to Remember

  • In this up and down button, the maximum limit is 30000. So, if you need more than this value, you have to change the cell link from the original place. Then, use this cell reference in the original place and multiply it by your required number.
  • This button helps to show the future output. By using this, we can take an initial step for further measurement which will help to reduce loss.

Conclusion

We have shown the necessary steps and two effective examples to add up and down buttons in Excel. All of these examples are fairly effective. We also included how to modify the button so that you can set it accordingly. If you have any questions, feel free to ask in the comment box. Don’t forget to visit our Exceldemy page.


Related Articles

Durjoy Paul

Durjoy Paul

Hi there! I'm Durjoy. I have completed my graduation from the Bangladesh University of Engineering and Technology. I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo