Using Spin Buttons in Excel

Рет қаралды 101,924

Technology for Teachers and Students

Күн бұрын

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

Пікірлер: 59

@LK-3000 4 жыл бұрын

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!!

@emeraldschreier6659 4 жыл бұрын

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 :)

@bigpossum 4 жыл бұрын

Very nice, I did not even know this option existed in Excel!

@wakeupamerica2971 2 жыл бұрын

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.

@BlondieSL Жыл бұрын

I love the spin button! That's what I needed! I've never used that before, so this is cool. Thanks so much.

@chrispodkowa2305 10 ай бұрын

Nice simple and easy to understand. Nice speed of video too. Thanks

@wot_hog 2 жыл бұрын

This was extremely helpful, thank you!

@anasser 3 жыл бұрын

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.

@marcel1016 4 жыл бұрын

I like this!! Very Informative..

@maujo619 4 жыл бұрын

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?

@jamesfarnham1976 4 жыл бұрын

Great videos....one begins to fathom how one can get into trouble with spreadsheets. Still good stuff!! TY. Jim.

@hamaa8017 2 жыл бұрын

I need this so much... Thank you

@MrY1313 4 жыл бұрын

Thank you!

@bradlyweir624 Жыл бұрын

Great instruction and video. couldn't be more clear

@Hey_Delight 4 жыл бұрын

Thought buttons like this need macros, but Developer tab can do it. Thanks so much.💖

@nielsfjord462 Жыл бұрын

Thanks a lot! Very easy to understand! :)

@lukmanaliyuyahaya Жыл бұрын

Thanks for this video. But can we control a dropdown list with this spin buttons?

@querrythis 2 жыл бұрын

Always thought coding was necessary. Thank you soooo much.

@FaysalEasyExcel 4 жыл бұрын

very helpful

@timon-ullrichmaier2419 3 жыл бұрын

Tricky and clever!

@boonyarithcharaho1044 2 жыл бұрын

Excellent...👍

@sophanasorn6218 3 жыл бұрын

Thanks a lot teacher

@rahulmehra7784 Жыл бұрын

Thank you 🤜🏻🤛🏻

@abbottkatz8830 3 жыл бұрын

The Active X spin control option in the Developer tab allows the user to set a maximum value in excess of 30000.

@nengtech6914 4 жыл бұрын

Wow ! Awesome

@zaldebano9275 2 жыл бұрын

Thankk you i like it 💞

@Dexter101x 4 жыл бұрын

How do you rotate the spin bar?

@maurodefalco2346 9 ай бұрын

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?

@LeighGalas-Espino Жыл бұрын

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!

@gordonprice2 3 жыл бұрын

Hi, great video. Is there a way to to control more than one cell eg A1: A10 with just one spinner button, thanks.

@wot_hog 2 жыл бұрын

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.

@sophanasorn6218 3 жыл бұрын

That's great

@ladiesloveswag 5 ай бұрын

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

@surajchhetri9452 3 ай бұрын

Nice

@josephcoon5809 2 жыл бұрын

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

@abdullatifhasan2541 Жыл бұрын

Is there any way to link this button to PowerPoint, and to keep it dynamic

@coolvideos6788 4 жыл бұрын

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 !!

@salihzekiusta 4 жыл бұрын

just search “convert pdf to word” on Google, upload your pdf file and then download the word file

@VikasSingh-em3ol 4 жыл бұрын

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.

@iadiramorales68 2 жыл бұрын

Can you please make a tutorial for beginners for Power Point, and Microsoft Word

@ubaidillahmuhammad20 4 жыл бұрын

Given the file Sir.

@techteachersandstudents 4 жыл бұрын

bit.ly/excelspinbutton

@darliemagbanua1200 4 жыл бұрын

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.

@casterMobile Жыл бұрын

How do you transfer FROM a cell TO another cell with each click?

@Raj-cf6fe Жыл бұрын

How to use that button to make a change from YES or NO

@Atanepes 2 жыл бұрын

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

@robdf9024 11 ай бұрын

Hi How do you format the cell to get $ - ? I am alwasy getting lost in a glass of water 😅

@zeeshanhussain5997 4 жыл бұрын

Sir can you make a video is power querry video excel

@techteachersandstudents 4 жыл бұрын

Thanks for your suggestion. I will consider making a video on that.

@VikasSingh-em3ol 4 жыл бұрын

👍👍👍

@zulmichannel 4 жыл бұрын

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🙏🙏🙏

@rere5578 4 жыл бұрын

That's right, friend, I hope this will benefit us all

@selalaras384 4 жыл бұрын

Good brother 👍👍👍

@ranti5189 4 жыл бұрын

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

@muamalah6877 4 жыл бұрын

Verry good. 👍👍