Make Scroll Bar in Excel

Подписаться 573 тыс.

Просмотров 71 тыс.

50% 1

Make Scroll Bar in Excel to scroll list in excel ! We can create a scroll bar in excel with ease and add it list , tables ,etc.
I have used the Offset formula to create this vertical scrollbar in excel and it works perfectly well. the only issue that i find with this scroll bar is that you cant color it much.
Hope you enjoy this video to make scroll able list in excel.
** Useful Excel formulas and Functions **
10 Most Used Formulas MS Excel
• 10 Most Used Formulas ...
Learn Basic Excel Skills For Beginners || Part 1
• Learn Basic Excel Skil...
10 Most Used Excel Formula
• 10 Most Used Excel For...
*Most Imporant Excel Formuls Tutorials*
Learn Vlookup Formula For Beginners in Excel
• Learn Vlookup Formula ...
5 Excel Questions Asked in Job Interviews
• 5 Excel Questions Aske...
Create Speedometer Chart In Excel
• Create Speedometer Cha...
Learn the Basic of Excel for Beginners || Part 2
• Learn the Basic of Exc...
Create Pareto Chart In Excel
• Create Pareto Chart In...
How to Create Dashboard in Excel
• How to Create Dashboar...
Excel Interview Questions & Answers
• Excel Interview Questi...
To watch more videos and download the files visit www.myelesson.org
To Buy The Full Excel Course visit . www.myelesson.o... or call 9752003788
Connect with us on Facebook - / excelmadeasy
Connect with us on Twitter - / excelmadeasy

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

3 окт 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 48

@atta101md 3 года назад

I have used this technique in two companies in various roles... And every time minds are blown. Thank you so much!!!

@SyedMaqsoodmakku 4 года назад

Thanks a lot sir.... corona vacation taught me to scroll.

@sudhirathavale4243 4 года назад

Dear sir , Very Clear and focused lovely guidance .

@vinaysharma7585 2 года назад

Very easy explanation thanks

@sass1330 9 дней назад

Only there first row changes when moving the scroll bar

@AdeKaryadi 4 года назад

nice tutorial

@nishadhanjikawathiyakawath1113 5 лет назад

Sir voice is really good

@GuruJii 5 лет назад

Thanks

@PeggywongPeggy 3 года назад

How to do it in a Horizotal way?

@mikejamroz2787 4 года назад

Maximum value is where the game comes!

@TIRTHSHAHsodast 3 года назад

Thank you so much sir! for this commendable video. really helped me

@acadroit 3 года назад

Thank you so much, sir, You made it so simple.

@GuruJii 3 года назад

Welcome

@sysysysy6437 Год назад

Thank you for your wonderful tip!! i want to copy the chart and the scroll bar to the PPT , if it's possible. Do you know how to do it?

@thevoiceoftruth5116 Год назад

vous meritez good job

@Shubhamnakoti2501 3 года назад

Thank you

@jayprakashprasad754 5 лет назад

Very very well sir.

@rayhanmohammad 2 года назад

Nice

@rohitarora3261 5 лет назад

Thank You Sir 👍

@Nice-gu8vo 3 года назад

Is that means to make the scroll thing I have to create 2 table so that i appears in the secund table ?

@SyedMuzammilMahasanShahi 5 лет назад

Amazing. Thanks for the share

@GuruJii 5 лет назад

Welcome

@umeshchaudhari7481 5 лет назад

Thanks sir

@GuruJii 5 лет назад

Welcome Friend

@chughtaionline5041 5 лет назад

Very informative, Guru gee.. I want to ask one question regarding drop box in excel, I'm facing a problem that when i want to select my desire entry from drop box, I've to scroll down to find that particular name and then select it. my question is that is it possible that rathar than selecting, may I type some letters and remaining part of the entry will show and then i select it ??

@shrutithegreat 5 лет назад

n I'm your big fan😀

@GuruJii 5 лет назад

Thanks Shruti

@krishnagroupgzp2641 5 лет назад

Nice sir....

@PeggywongPeggy 3 года назад

I also want to do in the others way Horizontal

@chetanzope432 5 лет назад

Main ek data banaya scrollbar kar ke par uske niche muze subtotal bhi chaiye to kase karegn pls help me thank you

@pinacolada7849 4 года назад

Sir how about horizontal scroll bar?

@ihsan19711 5 лет назад

Really i appreciate your hard work

@Nice-gu8vo 3 года назад

And i appreciate Ur appreciation, Since something in comman here can i get to know you better 😁

@ihsan19711 3 года назад

@@Nice-gu8vo sure bro. It my honor

@Nice-gu8vo 3 года назад

@@ihsan19711 Entschuldigung ich dachte du bist ein Mädchen 🙊

@ihsan19711 3 года назад

@@Nice-gu8vo sorry I didn't understand

@Nice-gu8vo 3 года назад

@@ihsan19711 I thought you r fraue

@diprodey817 3 года назад

how do you copy it to word? when I copy it to word the scroll bar doesn't work.

@FORYOU-wb1rx 5 лет назад

मेरे पास एक सवाल है अगर इसका उत्तर दे सको तो मानूँ सवाल- जब एक्सेल में किसी cell पर एंटर करते है तो एंटर हमें चारों दिशा में ले जा सकता है, मैं चाहता हूं कि एंटर हमें चारों में से किसी एक दिशा में न लेजाकर पेज को हमारी तरफ लाये माना हम नीचे की तरफ स्क्रोल करें तो पेज हमारी तरफ आना चाहिए न कि हम नीचे की तरफ जायें क्या ऐसा संभव है?

@sandipsarang2112 5 лет назад

स्क्रोल लॉक करके ट्राय करो ।

@gokceuraz 2 года назад

Here is the question. Think in your data sheet you have a filter and you would like to see only the filtered data in your scroll down list. How to do that?

@GuruJii 2 года назад

Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources

@PeggywongPeggy 3 года назад

cause I need to do a annual leave record by days and month