Adding a Scroll Bar in Excel
Вставка
- Опубліковано 5 сер 2024
- Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Learn how to add a scroll bar on an Excel spreadsheet so you can control data in a cell simply by dragging the scroll bar. This is an exciting form control that can improve a spreadsheet's usability.#excel #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... #exceltutorial #excel Information about MUSE's latest CD: amzn.to/2DUXG8q Here's the practice file that goes with the video: bit.ly/scrollexcel
- Навчання та стиль
I definitely would love to see more videos on form controls as they increase the efficiency and functionality of spreadsheets!
Your a real professional, should be on prime time TV.
Terrific video, informative as always. My one suggestion or ask would be that you upload the excel worksheet as a file and include it in the description so we could follow along without manually inputting any of the data. Thanks again, great work!
When you want to copy and paste multiple control items going down the page; the place where you enter the cell number you want to control, remove the dollar signs ($) on the first one and it should allow you to copy and paste without having to go back in to correct the box you want to control.... I enjoy your videos.
I saw Muse in concert last year, they were amazing!! I always thought of them as alternative music.
Thanks for introducing this interesting function. One suggestion: it would be nice to remind the learners that in order to drag the scrollbar, one need to first select that cell. It was one blocker for me when I was practising the function myself...
Really useful and so clearly explained! I would like to learn more about form controls.
You speak very nicely, like a teacher. I need to make more friends with Excel...So I will be going through your videos, thank you!
Yes please, to more info on this topic. I would also love more videos for Mac. Your videos are great.
Terrific video and you AMAZING music taste!! Depeche Mode for life!!
Thank you! This is great! More videos/tutorials please!
I love MUSE!! Their concerts are amazing!
Thanks for your time in making this videos... dont ever get tired. i learned a lot from u. :)
Yes, please, more information on this subject!
Hi, def did more control functions!! Please make for more, u always do amazing jobs! Thanks !
I would love to learn more about form controls. Fascinating!
Very helpful :) thank you for sharing your skills. Keep on posting more tutorials on us.
As usual very informative. More information on this subject would be appreciated..
Very helpful. Thanks
That is so cool. Genius and a great tutor.
so helpful thanks
please do all the form control pleaseee you're like really good at this
YES! More please! These video's are amazing. Wish I would have had you as an instructor when I was in college. Thanks for anything you want to share. I would personally like to see a troubleshooting video. I have issues sometimes with files that seem to be lost. When I click restore the file, I get error saying it is not available to restore. Is there hope for this? Thanks.
Many thanks!
Honestly I liked this topic too much, hope you gonna continue teaching the other options of the developer ribbon))
Awesome. Thanks
Thanks for the video. it was great help! Question, Is there anyway to change incremental unit from an integer to a decimal? Thanks.
excellent big boss
Really liked this video. Thank you! Not even sure if you're still active....
Yes I want to learn more on form control.please make more videos
Thanks for your comments. I did make more form control videos and I’ll make more in the future. I’ve posted videos on checkboxes and spin buttons.
Is there a way to make a scroll bar for a particular column, so that you can scroll through a column (or row I suppose) without having to move entire page?
Nice one
More videos of form controls please!
please share to us more info about the form controls. Thank you!
Is it possible to correlate or slide multiple scroll bars simultaneously? PLease let me know if this question is not clear.
Thank u Sir. I have subscribed u
Thanks
Dear sir, could you teach how to create and make goods details at the data head or data base automatically appear at the invoice sheet or purchase order sheet then easy to printing? Could you teach how to make it?
I am designing a Certificate in Excel. Is there a way of inserting artwork such as Scrollbars in each corner?
Brother, we want to know more about the ude of developer options.Thanks a lot.
I'v got a question about this. If you have hundreds of rows and you want to add a scroll bar to each can you use the formula brush from the home tab to copy the scroll formula all the way down or are you resigned to add this to each cell one at a time?
but do you have the horizontal line?
Very clear. I would want to use the scroller to scroll through the content of the cell without having to change it's size. Is that possible? I tried this but it only shows me the amount of values I defined :(
I also want that, the only way I've found so far to do something like that is using the =OFFSET Formula, and even then you have to define the list in a bunch of other cells off screen. It works, but it looks choppy.
Interesting information. however I have 2 questions:
1. the scroll bar properties shows current value in the cell as "10". The real value in the cell was 11. So now by putting your scroll bar in a cell with existing data, the value has been overwritten?
2. I believe it is easier to type something like 175 than scrolling the slider until I reach the correct value as I can see it is easier to get over or under that value and then it will take some time to move it to the correct value.... Just typing seems more appropriate in this case.
But this is just my opinion. Nice tutorial video though, thank you.
Isn't there an easier way to link to each cell ? like dragging or so ?
The video is very useful, but how to do the same thing with text pleas do tutorial for this
I've followed... the problem is that if you click on it once, the scroll is like a sign, it keeps scrolling, so how do fix it?
❤
👍👍👍
form control video??
I don't see how a scroll bar is better/faster than manually inputting the number.
In many cases you’re right. But there are exceptions.
@@techteachersandstudents Yes, but is there a better way to use a scroll bar for its more common purpose? Actually, scrolling through information? I have an assignment, and ran out of room in a cell to fit text, even with word wrapping. I'd like to scroll through the text like traditional scroll bars, this way I can fit more information into the cell in a user-friendly way.
hey can you do a tutorial on tables in excel please
,
,,
,
,
👍
why doesnt this work for excel online???
Why doesn’t mine have arrows
I tried to turn on the "developer" thing. Excel went bananas! Multiple errors
Using 2013 Excel. The maximum limit is 30,000. I have millions of dollars (not) that i wish to add. How do i make the limit practically unlimited?
Andres did you ever figure this out?
@@Dannyboyjr naw, what i did find is that they do this on purpose for special reason. One those reasons is so people can purchase features somehow. I gave up on it.
@@andresolavarrieta8303 broski I figured it out. What you can do is times the output number by .01 or .1. For example let's say you max out the slider bar and it gives you 30,000. Take that number and *.01 or .1
Really don't need to hear about the types of CDs, looking to see how a scroll bar works
a 7 min video? come on bro
Your all tutorial is great. but this tutorial Is it useful for us? I don't Understand.
Way too tedious to do for every single cell.
It's possible that you could, with the VBA editor make just one scroll bar for all the cells. You simply tell which cell you need.
Terrific video, informative as always. My one suggestion or ask would be that you upload the excel worksheet as a file and include it in the description so we could follow along without manually inputting any of the data. Thanks again, great work!
Done! Here's the link to the practice file: bit.ly/scrollexcel