Using Spin Buttons in Excel
HTML-код
- Опубликовано: 2 авг 2024
- Learn how to add spin buttons to your Excel spreadsheets, making it much easier to adjust numbers up and down with just the click of a button. Spin buttons are some of the most useful form controls that Excel has to offer. ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... My entire playlist of Excel tutorials: bit.ly/tech4excel Here's the practice file that goes with the video: bit.ly/excelspinbutton #excel #exceltutorial
Хобби
Very nice, I did not even know this option existed in Excel!
Nice simple and easy to understand. Nice speed of video too. Thanks
I don't use Excel but your video inspired me to research and figure out how to do this on LibreOffice Calc. It took a while, because some of the controls are different, but I did it! Thank you for teaching me something I didn't even know I wanted or needed!!
I love the spin button! That's what I needed! I've never used that before, so this is cool.
Thanks so much.
The best teacher I ever had online. I like it when you said 'That's too bad isn't true' for the total earnings' hahaha XD.
Stay blessed and healthy, teacher.
Love your videos! So helpful for students like me who are not tech-savvy! I would love to see a video for tips and tricks to maximize OneNote for students :)
This was extremely helpful, thank you!
I like this!! Very Informative..
Always thought coding was necessary. Thank you soooo much.
Great videos....one begins to fathom how one can get into trouble with spreadsheets. Still good stuff!! TY. Jim.
Thought buttons like this need macros, but Developer tab can do it. Thanks so much.💖
Great instruction and video. couldn't be more clear
I need this so much... Thank you
Thank you!
Thanks a lot! Very easy to understand! :)
Great video! Thanks! Using this feature for an inventory counter, is there a trick to allow negative inventory counts in the event our count is off so we know that something is missing?
Thanks again for sharing.
The Active X spin control option in the Developer tab allows the user to set a maximum value in excess of 30000.
Thanks a lot teacher
OOOOHHHHHH Thank you I am a Muslim and I need to for counting something So this video helped me how to activate developer mode May Allah (God) bless you
Tricky and clever!
0:30 You can right click on the Ribbon as well to Customize.
9:55 I did have a question, but you accidentally answered it. 😂
“What if you wanted a spin button for the unit, tens, hundreds, thousands, and so on?”
You just make a spin button for each and put a formulae in the result cell that multiplies each spin button value by the proper power of ten.
=(E2*1000)+(F2*100)+(G2*10)+(H2)
If you want to get really tricky, just put the multiplier at the top of the column and use an absolute reference to the multiplier so you can drag fill which still allows you to adjust the multiplier without going into each cell to adjust it.
Thanks for the video.
+1 Sub
+1 Like
very helpful
Excellent...👍
Thank you 🤜🏻🤛🏻
Thankk you i like it 💞
Wow ! Awesome
Great video. Is there a way I can create multiple Spin Buttons without individually having to assign a cell link to each one? I can't seem to drag it like I can with formulas to have it assign to a corresponding cell. Is there a way?
thanks for your video!; it it possible to assign the cell to just a one spin button, but when you select a different cell, the spin button will move is ''control'' in automatic way?
Thanks for this video.
But can we control a dropdown list with this spin buttons?
That's great
Nice
how do I do the alt function in Mac? for example when on windows we use Alt+C+V+V to paste values without having to use the mouse
Can you please make a tutorial for beginners for Power Point, and Microsoft Word
Given the file Sir.
bit.ly/excelspinbutton
How do you rotate the spin bar?
Hi, great video. Is there a way to to control more than one cell eg A1: A10 with just one spinner button, thanks.
Apparently not, but I (partially) figured out how to do it! I first tried clicking on several cells while setting the cell links, and it seemed to work, but after OK the button failed to execute the change in the other cells. So here's how I (almost) solved it: Suppose you want a spinner button located at E2 to increment the value in cells A2, B2, C2, and D2 by X amount, Proceed to link your spinner button to cell A2. Then add a formula to each of cells B2, C2, and D2 that says =A2. Bingo! Every time A2 changes because you hit the spinner button, so will B2, C2, and D2. The problem is that this only works if you want B2 through D2 to all be the same as A2. But if you want to start with different values in each of these three cells, then I could not figure out how to make those cells respond to the increment in cell A2 since no matter what I tried I kept getting a circular reference error. Ideally what is needed is a formula that applies "what you've got plus just the change in A2 as it happens" and I could not figure out how to do that. Sorry.
Hi. I have a lot of columns to put my spin button (I need a counter for each task on different days). Is there a shortcut for me to copy and paste the info I have for my format (info I entered in Format Control) but I want the result to come out on a specific cell without having to manually enter and select the cell link? Is there a drag and drop option? Thank you!
thank you for this video ...its very useful ..can you plz show me how to convert a pdf to word ..i have MS word 2016 and when i try to open my pdf file in word i cant .plz help me !!
just search “convert pdf to word” on Google, upload your pdf file and then download the word file
How to use 30+2 as number.
When I write 30+2 in excel it is as a text than how to use it as a number in excel.
Ex.
30+2
50+5
34+1
I want to use it as a number in excel and want to perform sum, multiple function with this.
Good Day Sir, can you take the average of text for example.
A1 TEXT1
A2 TEXT1
A3 TEXT1
A4 TEXT2
A5 AVERAGE of A1,A2,A3,A4
But if use this formula =CONCATENATE(A1,A2,A3,A4) the result i get for A5 is this (TEXT1TEXT1TEXT1TEXT2),
i just want to show is the a average which is IN A5 TEXT1.
Is there any way to link this button to PowerPoint, and to keep it dynamic
How do you transfer FROM a cell TO another cell with each click?
great sir, this video is very useful for me, continue to improve our ability in the field of administration, so that we are able to bring order in our office. My channel topic also covers microsorf office, hopefully we can always share it. introduce me from indonesia sir🙏🙏🙏
That's right, friend, I hope this will benefit us all
Good brother 👍👍👍
great, that's right, indeed we should understand the whole microsoft office if we want to conquer our work, especially for students, this is very important
Verry good. 👍👍
👍👍👍
Sir can you make a video is power querry video excel
Thanks for your suggestion. I will consider making a video on that.
How to use that button to make a change from YES or NO
Hi How do you format the cell to get $ - ? I am alwasy getting lost in a glass of water 😅
First
Not useful in common setting
I hoped this video would explain me spin buttons but more than the half of the video is BORING. A waste of my time ....