Adding a Scroll Bar in Excel

[@john.h.richards1]

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.

[@lostmysoultoday9005]

Your a real professional, should be on prime time TV.

[@Teacherman1955]

I definitely would love to see more videos on form controls as they increase the efficiency and functionality of spreadsheets!

[@momdoccoleen]

I love MUSE!! Their concerts are amazing!

[@vincentarff5146]

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!

[@peilisun8999]

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

[@serggarcia3467]

Terrific video and you AMAZING music taste!! Depeche Mode for life!!

[@Snejana21]

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!

[@byusuf4953]

Really useful and so clearly explained! I would like to learn more about form controls.

[@sheilac3043]

Thanks for your time in making this videos... dont ever get tired. i learned a lot from u. :)

[@kathyreese9373]

Yes please, to more info on this topic. I would also love more videos for Mac. Your videos are great.

[@jeaninehaack1459]

Yes, please, more information on this subject!

[@unnatigupta4602]

please do all the form control pleaseee you're like really good at this

[@JamesS15011]

Thanks for the video. it was great help! Question, Is there anyway to change incremental unit from an integer to a decimal? Thanks.

[@kmanalade2838]

Very helpful. Thanks

[@hollymcgowan4810]

I saw Muse in concert last year, they were amazing!! I always thought of them as alternative music.

[@querrythis]

That is so cool. Genius and a great tutor.

[@sodiqadebayo1865]

so helpful thanks

[@SpidermanandJeny]

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?

[@tangosettb]

As usual very informative. More information on this subject would be appreciated..

[@JohnMKaya-lm1ry]

Thank you! This is great! More videos/tutorials please!

[@windle4774]

I would love to learn more about form controls. Fascinating!

[@gagiktamrazyan771]

Honestly I liked this topic too much, hope you gonna continue teaching the other options of the developer ribbon))

[@claudiamorato]

Is it possible to correlate or slide multiple scroll bars simultaneously? PLease let me know if this question is not clear.

[@thatistruesophie]

Hi, def did more control functions!! Please make for more, u always do amazing jobs! Thanks !

[@wandagreer9144]

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.

[@princessjaydee5589]

Very helpful :) thank you for sharing your skills. Keep on posting more tutorials on us.

[@juliusbasak112]

Yes I want to learn more on form control.please make more videos

[@techteachersandstudents]

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.

[@PivotalMomentumInc.]

Really liked this video. Thank you! Not even sure if you're still active....

[@KeithAVass]

I am designing a Certificate in Excel. Is there a way of inserting artwork such as Scrollbars in each corner?

[@famade6526]

Awesome. Thanks

[@nodnalneyugn8753]

More videos of form controls please!

[@jurajhanus9499]

Many thanks!

[@princessjaydee5589]

please share to us more info about the form controls. Thank you!

[@PeggywongPeggy]

but do you have the horizontal line?

[@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?

[@MariamaMans-xh3tq]

Nice one

[@garynick4456]

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?

[@SAU_Islamic_Community]

Brother, we want to know more about the ude of developer options.Thanks a lot.

[@صقر_الجزيرة]

excellent big boss

[@cheekypeeky1941]

Thanks

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]

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]

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.

[@rehanjamali5829]

Thank u Sir. I have subscribed u

[@zaksav]

Isn't there an easier way to link to each cell ? like dragging or so ?

[@shawnneil-rafeeq7022]

I don't see how a scroll bar is better/faster than manually inputting the number.

[@techteachersandstudents]

In many cases you’re right. But there are exceptions.

[@flameofthephoenix8395]

​@@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.

[@ysf5171]

The video is very useful, but how to do the same thing with text pleas do tutorial for this

[@gustian_pandu7215]

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?

[@futuresuperstar4life]

form control video??

[@andresolavarrieta8303]

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]

Andres did you ever figure this out?

[@andresolavarrieta8303]

@@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]

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

[@handycraft9119]

hey can you do a tutorial on tables in excel please

[@sush8341]

,

[@sush8341]

,,

[@sush8341]

,

[@sush8341]

,

[@samarztk]

why doesnt this work for excel online???

[@rhys701]

Why doesn’t mine have arrows

[@wabellbahloul4401]

❤

[@CamposWealth]

I tried to turn on the "developer" thing. Excel went bananas! Multiple errors

[@Low.Key.Music01]

👍

[@arlynraymundo452]

👍👍👍

[@daveh4208]

Really don't need to hear about the types of CDs, looking to see how a scroll bar works

[@dachicagoan8185]

a 7 min video? come on bro

[@firozahmed5749]

Your all tutorial is great. but this tutorial Is it useful for us? I don't Understand.

[@elreydelvalley]

Way too tedious to do for every single cell.

[@flameofthephoenix8395]

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]

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]

Done! Here's the link to the practice file: bit.ly/scrollexcel