Тёмный

Adding a Scroll Bar in Excel 

Technology for Teachers and Students
Подписаться 1,5 млн
Просмотров 270 тыс.
50% 1

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

Хобби

Опубликовано:

 

7 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 75   
@vincentarff5146
@vincentarff5146 5 лет назад
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!
@Teacherman1955
@Teacherman1955 5 лет назад
I definitely would love to see more videos on form controls as they increase the efficiency and functionality of spreadsheets!
@lostmysoultoday9005
@lostmysoultoday9005 5 лет назад
Your a real professional, should be on prime time TV.
@john.h.richards1
@john.h.richards1 3 года назад
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.
@hollymcgowan4810
@hollymcgowan4810 4 года назад
I saw Muse in concert last year, they were amazing!! I always thought of them as alternative music.
@byusuf4953
@byusuf4953 5 лет назад
Really useful and so clearly explained! I would like to learn more about form controls.
@momdoccoleen
@momdoccoleen 2 года назад
I love MUSE!! Their concerts are amazing!
@jeaninehaack1459
@jeaninehaack1459 5 лет назад
Yes, please, more information on this subject!
@kathyreese9373
@kathyreese9373 5 лет назад
Yes please, to more info on this topic. I would also love more videos for Mac. Your videos are great.
@peilisun8999
@peilisun8999 4 года назад
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...
@JohnMKaya-lm1ry
@JohnMKaya-lm1ry 4 года назад
Thank you! This is great! More videos/tutorials please!
@thatistruesophie
@thatistruesophie 4 года назад
Hi, def did more control functions!! Please make for more, u always do amazing jobs! Thanks !
@serggarcia3467
@serggarcia3467 2 года назад
Terrific video and you AMAZING music taste!! Depeche Mode for life!!
@windle4774
@windle4774 4 года назад
I would love to learn more about form controls. Fascinating!
@princessjaydee5589
@princessjaydee5589 4 года назад
Very helpful :) thank you for sharing your skills. Keep on posting more tutorials on us.
@tangosettb
@tangosettb 5 лет назад
As usual very informative. More information on this subject would be appreciated..
@kmanalade2838
@kmanalade2838 5 лет назад
Very helpful. Thanks
@sheilac3043
@sheilac3043 4 года назад
Thanks for your time in making this videos... dont ever get tired. i learned a lot from u. :)
@Snejana21
@Snejana21 3 года назад
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!
@sodiqadebayo1865
@sodiqadebayo1865 5 лет назад
so helpful thanks
@JamesS15011
@JamesS15011 2 года назад
Thanks for the video. it was great help! Question, Is there anyway to change incremental unit from an integer to a decimal? Thanks.
@querrythis
@querrythis 2 года назад
That is so cool. Genius and a great tutor.
@gagiktamrazyan771
@gagiktamrazyan771 4 года назад
Honestly I liked this topic too much, hope you gonna continue teaching the other options of the developer ribbon))
@jurajhanus9499
@jurajhanus9499 4 года назад
Many thanks!
@wandagreer9144
@wandagreer9144 2 года назад
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.
@famade6526
@famade6526 3 года назад
Awesome. Thanks
@unnatigupta4602
@unnatigupta4602 2 года назад
please do all the form control pleaseee you're like really good at this
@nodnalneyugn8753
@nodnalneyugn8753 2 года назад
More videos of form controls please!
@cheekypeeky1941
@cheekypeeky1941 2 года назад
Thanks
@princessjaydee5589
@princessjaydee5589 4 года назад
please share to us more info about the form controls. Thank you!
@PivotalMomentumInc.
@PivotalMomentumInc. 2 года назад
Really liked this video. Thank you! Not even sure if you're still active....
@SpidermanandJeny
@SpidermanandJeny 4 года назад
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?
@صقر_الجزيرة
@صقر_الجزيرة 2 года назад
excellent big boss
@MariamaMans-xh3tq
@MariamaMans-xh3tq 9 месяцев назад
Nice one
@juliusbasak112
@juliusbasak112 4 года назад
Yes I want to learn more on form control.please make more videos
@techteachersandstudents
@techteachersandstudents 4 года назад
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.
@rehanjamali5829
@rehanjamali5829 2 года назад
Thank u Sir. I have subscribed u
@PeggywongPeggy
@PeggywongPeggy 3 года назад
but do you have the horizontal line?
@claudiamorato
@claudiamorato 4 года назад
Is it possible to correlate or slide multiple scroll bars simultaneously? PLease let me know if this question is not clear.
@SAU_Islamic_Community
@SAU_Islamic_Community 3 года назад
Brother, we want to know more about the ude of developer options.Thanks a lot.
@garynick4456
@garynick4456 4 года назад
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?
@KeithAVass
@KeithAVass 3 года назад
I am designing a Certificate in Excel. Is there a way of inserting artwork such as Scrollbars in each corner?
@thomaskroepfl
@thomaskroepfl Год назад
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?
3 года назад
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 :(
@flameofthephoenix8395
@flameofthephoenix8395 10 месяцев назад
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.
@marcq877
@marcq877 3 года назад
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.
@ysf5171
@ysf5171 4 года назад
The video is very useful, but how to do the same thing with text pleas do tutorial for this
@zaksav
@zaksav 3 года назад
Isn't there an easier way to link to each cell ? like dragging or so ?
@shawnneil-rafeeq7022
@shawnneil-rafeeq7022 5 лет назад
I don't see how a scroll bar is better/faster than manually inputting the number.
@techteachersandstudents
@techteachersandstudents 5 лет назад
In many cases you’re right. But there are exceptions.
@flameofthephoenix8395
@flameofthephoenix8395 10 месяцев назад
​@@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.
@handycraft9119
@handycraft9119 5 лет назад
hey can you do a tutorial on tables in excel please
@sush8341
@sush8341 3 года назад
,
@sush8341
@sush8341 3 года назад
,,
@sush8341
@sush8341 3 года назад
,
@sush8341
@sush8341 3 года назад
,
@wabellbahloul4401
@wabellbahloul4401 2 года назад
@gustian_pandu7215
@gustian_pandu7215 2 года назад
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?
@Low.Key.Music01
@Low.Key.Music01 4 года назад
👍
@futuresuperstar4life
@futuresuperstar4life 2 года назад
form control video??
@arlynraymundo452
@arlynraymundo452 Год назад
👍👍👍
@samarztk
@samarztk 3 года назад
why doesnt this work for excel online???
@rhys701
@rhys701 8 месяцев назад
Why doesn’t mine have arrows
@andresolavarrieta8303
@andresolavarrieta8303 3 года назад
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?
@Dannyboyjr
@Dannyboyjr 3 года назад
Andres did you ever figure this out?
@andresolavarrieta8303
@andresolavarrieta8303 3 года назад
@@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.
@Dannyboyjr
@Dannyboyjr 3 года назад
@@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
@Iurecamposcfp
@Iurecamposcfp 3 года назад
I tried to turn on the "developer" thing. Excel went bananas! Multiple errors
@daveh4208
@daveh4208 2 года назад
Really don't need to hear about the types of CDs, looking to see how a scroll bar works
@firozahmed5749
@firozahmed5749 5 лет назад
Your all tutorial is great. but this tutorial Is it useful for us? I don't Understand.
@dachicagoan8185
@dachicagoan8185 4 месяца назад
a 7 min video? come on bro
@elreydelvalley
@elreydelvalley Год назад
Way too tedious to do for every single cell.
@flameofthephoenix8395
@flameofthephoenix8395 10 месяцев назад
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.
@sagorkhan1674
@sagorkhan1674 4 года назад
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!
@techteachersandstudents
@techteachersandstudents 4 года назад
Done! Here's the link to the practice file: bit.ly/scrollexcel
Далее
Using the Trim Function in Excel
5:07
Просмотров 328 тыс.
Advanced Excel - Creating Pivot Tables in Excel
13:11
Luiza Rasulova #luizarasulova
00:37
Просмотров 697 тыс.
The Hardest Challenge!
00:37
Просмотров 7 млн
How to Create a Scrolling Table in Excel
13:19
Просмотров 188 тыс.
How to Create a Vertical Scroll Bar in Excel
10:42
Просмотров 4,9 тыс.
Excel for Beginners - The Complete Course
54:55
Просмотров 5 млн
Beginner's Guide to Excel Dashboards
14:03
Просмотров 791 тыс.
WOW! Dynamic Scroll & Sort Table in Excel
10:25
Просмотров 38 тыс.
How to Create a Scroll Bar in Excel
9:53
Просмотров 156 тыс.
Make Scroll Bar in Excel
7:55
Просмотров 69 тыс.
Excel Conditional Formatting in Depth
17:39
Просмотров 277 тыс.
Прошёл босиком 3600 метров
0:59
Просмотров 1,5 млн