Here’s my entire playlist of Excel tutorials: 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***: #exceltutorial #excel Information about MUSE’s latest CD: Here’s the practice file that goes with the video:
Tag: cuộn trong excel 2010, scroll bar in excel, excel tutorial, form control, form controls in excel, excel form controls, add a scroll bar, adding a scroll bar in excel, exel scroll bar, exel scrol bar, scrol bar in exel, scroll bar in exel, making scroll bar in excel, making scroll bar in exel
Xem thêm: https://taichinh4u.net/category/review
Nguồn: https://taichinh4u.net
why doesnt this work for excel online???
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!
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 🙁
but do you have the horizontal line?
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?
I am designing a Certificate in Excel. Is there a way of inserting artwork such as Scrollbars in each corner?
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 ?
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.
please share to us more info about the form controls. Thank you!
Very helpful 🙂 thank you for sharing your skills. Keep on posting more tutorials on us.
Is it possible to correlate or slide multiple scroll bars simultaneously? PLease let me know if this question is not clear.
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!
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 would love to learn more about form controls. Fascinating!
Many thanks!
The video is very useful, but how to do the same thing with text pleas do tutorial for this
Yes I want to learn more on form control.please make more videos
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…
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?
Thanks for your time in making this videos… dont ever get tired. i learned a lot from u. 🙂
Honestly I liked this topic too much, hope you gonna continue teaching the other options of the developer ribbon))
I saw Muse in concert last year, they were amazing!! I always thought of them as alternative music.
Thank you! This is great! More videos/tutorials please!
Hi, def did more control functions!! Please make for more, u always do amazing jobs! Thanks !
👍
I don't see how a scroll bar is better/faster than manually inputting the number.
I definitely would love to see more videos on form controls as they increase the efficiency and functionality of spreadsheets!