Increase or decrease cell value automatically using Excel

In Excel, there are a lot of secret tricks that are easy to use. In this tutorial on Excel, I'll show you how to use Spin Button to automatically increase or decrease the value of a cell. You could link the spin button to any cell, you could set up the maximum value, minimum value and incremental change. The only shortfall is that you can't use decimal value as an incremental change. However, I'll show you a trick that you could use to create decimal increment changes without any coding.

Introduction - 00:00
Excel spin button increment Integer - 00:44
Excel spin button increment decimal - 02:31

If you have any questions, please let me know in the comments below 😊

#BhupinderTube #excel #tutorial

[ดาว-บผ]

Hi ! This one was so helpful ! Thank you so much

[MrPranavsr]

Very Helpful, Is there any ways to do this to multiple cells like I need all the rows in D column to have a spin button that increases or decreases corresponding values in the C row by 1. Thanks in advance.

[eoopeter]

Hi. I like what you do and be sure this tutorial was of great help. What if I wish to have what you just did change automatically. Say, the cell value increases by 1 after 1 day without my intervention.

[agyeifrancis]

that's a great one there, please is there a way out, if i want to add up values entered in one cell. eg cell A1, Type 2, then again type 3 in the same cell and gives me 5.

[Me-dxrg]

Is there any way to automate the slider click?

[xelag.]

Great Tutorial. What if you want to decrease to negative values, is it possible? Could you do a sample please? Thanks

[anilmathangi]

Sir how to shift cell from 1 place to another

[mirali]

in column a i have some numeric value for example value is 100 its updating live in every 2 minutes with new value might it will be 90 as new value. so copied the 1st updated value 100 in next column assign formal =a2+b2 so value will be 190 but next 2 minute the update value is in column a is 35 so its need to add 190+35 but unfortunately it's adding 35 +100 not incrementing with new value. can any 1 help what formula need to use.

[vasanthsathiyanarayanan]

Hi I need help is it possible to add a certain number to a cell automatically daily
Ex A1 0 today by seeing tomorrow I want 35 in A1 next day I want 70 in A1 automatically it needs to change

[amitdixit]

Sir ye content kisiko pasand nhi ahra hai tabhii app ye hi banye jarhe ho

[puddingz]

his voice is indian, that's when you know he meant business

[mirali]

in column a i have some numeric value for example value is 100 its updating live in every 2 minutes with new value might it will be 90 as new value. so copied the 1st updated value 100 in next column assign formal =a2+b2 so value will be 190 but next 2 minute the update value is in column a is 35 so its need to add 190+35 but unfortunately it's adding 35 +100 not incrementing with new value. can any 1 help what formula need to use.