# Looking for help with Excel / Google Sheets -- Change Value Of Cell When Button Clicked **URL:** \ **Category:** The Free For All Lounge\ **Created:** [May 12, 2017, 4:53pm UTC](https://mpsocial.com/t/looking-for-help-with-excel-google-sheets-change-value-of-cell-when-button-clicked/14822 "2017-05-12T16:53:22Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![BrandonBerner](https://mpsocial.com/user_avatar/mpsocial.com/brandonberner/32/9354_2.png) [@BrandonBerner](https://mpsocial.com/u/BrandonBerner)\ **Post date:** [May 12, 2017, 4:53pm UTC](https://mpsocial.com/t/looking-for-help-with-excel-google-sheets-change-value-of-cell-when-button-clicked/14822/1 "2017-05-12T16:53:22Z")
Hey guys, I have been spending hours researching on a solution to this problem, and I cant seem to find the right answer. Was hoping someone here could help 🙂 The Goal is to click an up or down arrow ( + or - ) to increase or decrease the cell value by 1. All the solutions I have found require scripts / macros. I would prefer not to use them. Instead I would like to hopefully find a way to acheive this using a formula of some kind. Here is the link to the Google Sheet: [https://docs.google.com/spreadsheets/d/15uIZwQTTwJ-rcZg1EiTnJbADg0Shuzj1W42oOBvN6iY/edit?usp=sharing](https://docs.google.com/spreadsheets/d/15uIZwQTTwJ-rcZg1EiTnJbADg0Shuzj1W42oOBvN6iY/edit?usp=sharing) PS: If there is absolutely no possible way to acheive this without a script, then is it possible to eliminate the need to click the cell before clicking the button to change the value? Thanks in advance 😃 ---
**Author:** ![orion.wills](https://mpsocial.com/user_avatar/mpsocial.com/orion.wills/32/4757_2.png) [@orion.wills](https://mpsocial.com/u/orion.wills)\ **Post date:** [May 13, 2017, 2:04am UTC](https://mpsocial.com/t/looking-for-help-with-excel-google-sheets-change-value-of-cell-when-button-clicked/14822/2 "2017-05-13T02:04:35Z")
There’s really no easy way to do what you want with buttons if you’re not going to use VBA/scripts. I mean the only thing I can think of is use data validation and have a drop-down. ---
**Author:** ![mindeswx](https://mpsocial.com/user_avatar/mpsocial.com/mindeswx/32/13863_2.png) [@mindeswx](https://mpsocial.com/u/mindeswx)\ **Post date:** [May 13, 2017, 2:33am UTC](https://mpsocial.com/t/looking-for-help-with-excel-google-sheets-change-value-of-cell-when-button-clicked/14822/3 "2017-05-13T02:33:55Z")
Why do you need that button so much ? ---
**Author:** ![BrandonBerner](https://mpsocial.com/user_avatar/mpsocial.com/brandonberner/32/9354_2.png) [@BrandonBerner](https://mpsocial.com/u/BrandonBerner)\ **Post date:** [May 13, 2017, 4:24am UTC](https://mpsocial.com/t/looking-for-help-with-excel-google-sheets-change-value-of-cell-when-button-clicked/14822/4 "2017-05-13T04:24:36Z")
> [@orion.wills](#): > > There’s really no easy way to do what you want with buttons if you’re not going to use VBA/scripts. Thanks for your input. Sucks to hear though. > [@orion.wills](#): > > I mean the only thing I can think of is use data validation and have a drop-down. The drop down will be way to long as I have to change random cell values all throughout the day. Thanks 🙂 ---
**Author:** ![BrandonBerner](https://mpsocial.com/user_avatar/mpsocial.com/brandonberner/32/9354_2.png) [@BrandonBerner](https://mpsocial.com/u/BrandonBerner)\ **Post date:** [May 13, 2017, 4:30am UTC](https://mpsocial.com/t/looking-for-help-with-excel-google-sheets-change-value-of-cell-when-button-clicked/14822/5 "2017-05-13T04:30:08Z")
> [@mindeswx](#): > > Why do you need that button so much ? I have a very long list of repeated tasks which must be recorded in excel. Each task will be on its own row. I would like to track how many times each task has been completed throughout each day. I could enter the values manually, but since I am changing hundreds of values each day (soon to be thousands), manual input would increase the time spent entering data dramatically. Click a button would be much simpler, and more productive. The problem is, if the list is lets say 1000 rows long, adding a button on each row + using a script would not be good performance wise (correct me if I am wrong). Got any solution for me master @mindeswx ---
**Author:** ![mindeswx](https://mpsocial.com/user_avatar/mpsocial.com/mindeswx/32/13863_2.png) [@mindeswx](https://mpsocial.com/u/mindeswx)\ **Post date:** [May 13, 2017, 2:11pm UTC](https://mpsocial.com/t/looking-for-help-with-excel-google-sheets-change-value-of-cell-when-button-clicked/14822/6 "2017-05-13T14:11:01Z")
I’m actually only using libreoffice , so i am nowhere close to being good with google sheets, but for this task i would just use something like this- > **[brandon](https://docs.google.com/spreadsheets/d/1NApU6WezyHoTiKcmrB2J3-toC5z9wUhmwBB4-03aMlM/edit?usp=sharing)** > > Sheet1 > > result, your input values, 5,<== how much to add > 105, 100 > 205, 200 > 305, 300 > 505, 500 > 505, 500 > 1005, 1000 > 505, 500 > 505, 500 > 505. 5, 500. 5 > 105. 1, 100. 1 > 505, 500 > 505, 500 > 505, 500 > 505, 500 > 505, 500 > 505, 500 > 505, 500 > 505,... add your values in C2 , in A2 insert formula =SUM(C2+NamedRange1) and on f1 right click and select define range name , it should be “NamedRange1” I might completely misunderstood your issue , but sometime simple solution can help 😃