The *ONLY* 10 Excel keyboard shortcuts you need to master

[@scottolson4541]

This is brilliant...I thought I knew alot of shortcuts...but this had some I didn't AND they are all perfect for what I do!

[@srinivasn415]

1) ctrl t - Create tables 2) ctrl d - Fill down 3) ctrl shift L - Apply / remove filters 4) ctrl arrow keys - Navigation around worksheet 5) ctrl 1 - Format anything 6) ctrl alt v - Paste Special 7) f2 - Edit a cell 8) f4 - Change ref. style / repeat last action 9) f9 - Recalculate / evaluate portions of the formula 10) ALT key - access everything on the ribbon

[@caraziegel7652]

huh, i've only used 2, 3, 4, and 10

[@kalabhushanam3663]

Ctrl+shift+8

[@68team]

I used all except 9.

[@bhavapritaapara9274]

Thanks

[@angmathew4377]

you saved our 10 mins. 😂

[@nyancole]

Chandoo, you are good at Excel in such a way that you explain so well that the least person with little knowledge understands it perfectly.

[@vikramgupta3827]

The Alt tip is mind blowing, thanks!!!!

[@chandoo_]

You bet!

[@y73]

Ctrl + Shift + 8 is mind blowing! Thank you so much for these!

[@udhayakhanthl6464]

Hey Chandoo, I don't know why I miss this channel. Hey man I am learning from you more..

[@JayshreeZamvar]

Hey happy to know that I knew almost all the shortcuts except F4 (use to repeat last action). Love the way you explain !!!

[@chandoo_]

Great to hear! :)

[@Ar-pl1hl]

hey.... same here ... i didnt know f9... happy to know here... thanks to chandoo

[@saivardhan500]

I have been learning so many things in excel as I was involved in my internship in the very initial days of my Chartered Accountancy course and until now when I'm actually a Chartered Accountant. I'm so grateful and delightful to know all the brilliant smart things in excel from you and the best part is the Wow said by my colleagues when I use these new things in excel (not only shortcuts) which they got to know from me which I had learnt from you........Thanks for your support......Hope you will be teaching us more all the time..!!!

[@chandoo_]

Thanks for this beautiful testimonial Sai... :) More awesomeness to you.

[@Sai-jh5ti]

@@chandoo_ one more CA Student beneficiary here. Thank you chandoo sir

[@CA-Nikhilsharma-10]

One more

[@belkacemseffari7404]

chandooooo you loook amazing with that bear

[@chandoo_]

yeah, the 🐻 was heard to control 😂

[@rahulchopra2030]

Master of the excel .. Excel Guru... sir it’s the best explanation of the shortcuts given by anyone. Thank you sir... Your work is phenomenal

[@chandoo_]

Thanks Rahul. This is new format of video I am experimenting and I am glad you liked it. :)

[@rautorama]

This top 10 of all could become the next hot video series...top 10 excel short cuts..top 10 excel mistakes...top ten excel interview questions....Top 10 excel functions...and so much more

[@chandoo_]

@@rautorama Are you using FORECAST.ETS()? That is what I have in mind...

[@user-wm1bs5pf5e]

Chandoo looking like a Saint 😅

[@JasonMilner]

I LIKE that F9 formula reveal - many thanks!

[@sindhujamadasu3816]

you are looking great chandoo .

[@Anil_Sapavath]

Gaddam bagundhi annoo...😎💖

[@thangaveluraj5366]

Very very useful, thank you so much. One more suggestion for your kind consideration: "alt + =" very often used for summing up. Shortcut for the function: autosum

[@chandoo_]

Great tip!

[@asifgulfarosh6732]

Lot of learning going on from your playlist thanks sir

[@chandoo_]

You are most welcome

[@lloydmcleod629]

This is game-changing

[@edsterling5258]

F4 repeat last action has been my secret weapon for years. Biggest time saver in excel.

[@chandoo_]

You can say that again.. ;)

[@germaingyesah5724]

I have been a silent follower and you inspire me a lot

[@binishthomas2675]

4:19 which is better, 'Ctrl Shift 8' or just 'Ctrl A'. I use 'Ctrl A' as its easy and I can always go for 'Ctrl AA' if want to select the whole sheet. genuinely asking Why is 'Ctrl Shift 8' is preferred? 🤔 what am I missing?

[@PaulWelsh]

Loving your work Chandoo

[@Nitinpaste-k5l]

Chandoo i am fan of you. Great. I know most of them but when you explain it is glad to listen.

[@chandoo_]

Thank you so much 😀

[@kimmyvlog1009]

Your videos are really helpful ❤❤❤❤

[@itsdaj]

As always your content is very useful. Thanks Chandoo!!!

[@PaulNordvik]

Fantastic List!

[@VijayendranRaghavendran]

Thanks Chandoo for this informative video. I am giving a tutorial to my lab colleagues and I shall definitely recommend them to watch this video.

[@chandoo_]

Thank you. :)

[@mochasweet4966]

Very useful. Thank you!

[@aatifrashid5413]

Brilliant Explanation

[@abdulbasital-sufyani6828]

Always adding value Thanks

[@suvzar6194]

I know I am late but glad to find your channel. Will watch all videos niw

[@Debbie1304]

OMG with that right mouse key button on the keyboard I think you've just changed my life!

[@chandoo_]

Isn't that key AWESOME 🔥🔥🔥😍

[@rautorama]

Also the good old Alt + =, to do a quick sum !

[@chandoo_]

Great addition :)

[@angmathew4377]

pure gold. Thank you Sir!

[@ExcelWithChris]

Great one! Thanks Chandoo.

[@chandoo_]

Thanks Chris. :) I am glad you liked this.

[@querrythis]

I like F9. Very useful indeed. BTW, like the jokes. Great sense of humor.

[@philippehenrion5199]

Hi Chandoo, I always thought the D in Ctrl-D was for Down (from Fill-Down), as R in Ctrl-R is for Right (from Fill-Right)

[@Merewah97]

Hi Chandoo. Can u the next 10 best shortcuts? That’d b awesome

[@shaikusman536]

Awsome chandoo...$productivity = $Time Save ....>$Money.......*Thanks*

[@davidhush7772]

Brilliant. I always learn something new from these videos.

[@jermsbestfriend9296]

Thank you Chandoo

[@bairikrishna0808]

I am glad that I use all of the 10 short cut key in my day to day work and good hands on,except F9 something new for me. Thanks for sharing knowledge Chandu.

[@chandoo_]

That is awesome...

[@terihandrick2333]

Thank you Chandoo outstanding as always

[@chandoo_]

My pleasure!

[@rautorama]

Thanks chandoo..I very often also use ALT +N+V to activate/insert pivot table

[@chandoo_]

Great 👍 I normally resort to mouse once Pivots come in to play as there are too many things in Pivots needing mouse use.

[@dkgdkg546]

YOUR VIDEOS ALWAYS GREAT THANK YOU VERY MUCH.

[@brendensong8000]

Thank you for saving many hours of clicking same keys working on my excel spreadsheets!

[@chandoo_]

I hate click tax...

[@wayneedmondson1065]

Hi Chandoo.. very useful video. I use each of your examples on a daily basis. I would also consider CTRL-Z for undo and CTRL-Y for redo as essential. There are so many good ones. You could easily make the list longer.. which happens naturally.. the more you work with EXCEL. Thanks for the insights. Thumbs up!!

[@chandoo_]

Great suggestions. Thanks for the love :)

[@ramachandusharma5867]

Very useful video. Thanks for sharing

[@cleofaspintolimalima1627]

Wonderful teacher

[@afsarbmahmud]

The dishwash idea with F4 is awesome. Wish it worked. Thanks for this video, very helpful :)

[@chandoo_]

🤣

[@BhageshwarDham-sz7wt]

Wow! Nice one❤

[@adrianaghita1520]

you are UNIC,with your fine sns of humor...and timing for thuse jokes....when the circuites of brain are ready to be burned..it comes a joke .BRILLIANT!

[@laurak5196]

Congratulations on 200K and thanks so much for all of your time and efforts, Chandoo! We really appreciate you 🙏🏻😀

[@chandoo_]

Thanks Laura.. 😀

[@analiesianogueiracruz6912]

Thats crazy fine, thanks.

[@Sreejithmusic]

Thanks bro for all the valuable information and you remind me of one of my buddies🙂

[@duarte.arthur]

Thanks for the tips Chandoo!! Regards from Brazil!!

[@chandoo_]

My pleasure!

[@pragadesh923]

Sml addon Ctrl + A will also helps to select whole table:)

[@claudegiguere8731]

I wish I knew you before, I really appreciate your work Chandoo, many thanks 😊 I will let you know if I find a shortcut for the dishes... 😅

[@Global_Analysis]

Good move Chandoo

[@sureshy344]

Thank you Chandoo for all the excel shotcuts

[@IASEAGLE5]

I've been using CSL for years and it has saved me so much time. Now I see the CS8 and it's going to be a game changer.. thanks!

[@SanthoshKumar-xy3zm]

Very helpful....I was not knowing many.Thank you....🙏🙏🙏🙏🙏

[@chandoo_]

My pleasure 😊

[@Rip_pro1000]

very useful,,,, thank you so much

[@santoshmn]

Its nice explanation. Excel is just awesome and interesting to learn. Thanks to Mr. Chandu

[@satishkhubchandani520]

Hi Chando, I wish I had found your channel years back. Although most of these shortcuts are basic but I was not aware of few 2 years ago when you uploaded this video. I am now watching all your videos and learning alot.. Thank You so much! ❤

[@amarindani9881]

Shift+F10: (Short cut key for right mouse click key) {Not all key board has right mouse click} so can use this combo instead.

[@chandoo_]

That is great...

[@sunjulie1009]

this is awesome!!!! thank you

[@chandoo_]

Glad you like it!

[@redheelerdog]

Chandoo you are awesome! I have been on your email update list for years and have showed many others how awesome your tips and tricks are, keep up the good work my friend.

[@chandoo_]

Awesome! Thank you so much for being a member all these years and supporting my work :)

[@Toni-Marie]

Chandoo, you are my Hero...Ctrl + Shift + 8 !!!!!!! Oh the agony of doing it the way I knew. Thank you Kindly Sir :-)

[@chandoo_]

Thanks Toni-Marie... 😍

[@Toni-Marie]

@@chandoo_ ❤️

[@althaflifestyle]

Good short cut for Excel, kinldy do it in practical also .

[@Mu00lia]

Thanks 👍

[@adrianaghita1520]

Many thanks ,there are very usefuly in my financial work

[@ruthieisham5939]

Thank you for making these videos! They are easy to understand, helpful, and the jokes are funny!

[@chandoo_]

Thanks Ruthie... :)

[@justjacqueline2004]

Brilliant.

[@ArmandoReportes]

My ten selections : Ctrl T for tables, Ctrl Shift T for totals on tables. Ctrl (move a lot) and direction keys (arrows, home, end, pgup pgdn). Shift (select) and the direction keys. Ctrl Shift and direction keys. Ctrl space to select columns. Shift space to select rows Ctrl + insert Ctrl - delete And the most useful, Ctrl Z. ... And f2, f4, f5, Ctrl Shift L, Ctrl alt L,... I just can't choose.

[@chandoo_]

Great ones...

[@rajudugar]

Hey Chandoo good to see you after long time.i used to browes your blogs since 2010..Happy to say that i knew all of these formulas except Alt+Shit+8..instead used Ctrl+A

[@chandoo_]

Thank you Raju for being on this journey for over a decade. Good to see you here too.

[@22boali]

Simple and professional explanation, thank you very much

[@chandoo_]

Glad you liked it

[@julitacastro17]

very useful😍

[@parth_pm16]

Thanks for making this video! Even I’m learning excel and I got to learn 3 new shortcuts👍

[@govindarajugatiganti4893]

Good explanation

[@chandoo_]

Thanks Govind... :)

[@HariKumar-ru9no]

Impressive thumbnail. Chandoo look was amazing. Beard waala...😀😀😀

[@chandoo_]

🧔😍

[@createthenew3062]

There was time I was scared of excel during my childhood days and thought will certainly do something in my career where excel is not used.And my father scolded me one time why I ignore excel and I felt shy since I was growing and took it is as a challenge for myself and today I rate myself above 7 out of 10. If 10 is maximum .Chandoo classes is an added advantage for me .I love my excel also because of these classes as they are easy to remember. One request while explaining formulas pls maximise the screen for us to see in detail though the explanation is good.

[@ASHOKKUMAR-jm6yn]

Lots of love to u chandu

[@chandoo_]

Thank you Ashok.

[@Kingx7565]

Love the way how you explain i know all the shortcuts except Ctrl + shift + 8

[@chandoo_]

Thanks Hasnain...

[@neelamzaidi1683]

So proud of myself I use these all 10 every day!!

[@abhaysinghbhosale2748]

This beard is best.....keep it again like this.....I am learning from your channel about POWER BI

[@EricaDyson]

Perfect! Thanks so much. Really helpful

[@chandoo_]

Glad it was helpful!

[@venkatiyer7459]

Thanks again for the nice explanation

[@rakeshchoubay3983]

Thank you sir. Its really helpful.

[@manx306]

Knew all of these except 1), 2), and 5), but I had actually searched for 2 and couldn't find an answer (shortcut for fill down) and here it is!

[@mohitagarwal437]

Brilliant sir

[@chandoo_]

Thanks Mohit...

[@adin6429]

I use Ctrl+R a lot to fill to the right which is similar to Ctrl+D to fill down.

[@maurolimaok]

Nice video. Thanks!

[@chandoo_]

Glad you liked it!

[@juandeleon789]

Thank you very helpful. I would like to see vlookup formula.

[@arunsureshbabu2708]

Very much helpful.

[@mauricelee2219]

Very nice, thank you for sharing this video to us.

[@vk9h]

Thanks nice tuto

[@sushantachoudhury7021]

Thanks, Chandoo, awesome as always. 2 things from my experience. If we do Ctrl+A it will select all. Similar to Ctrl+shft+8 but much quicker. Another one is the paste special dialog box. Instead of ctrl+Alt+V we can also use Alt+E+S which is from old school excel and still works well with latest versions. I am sure many veterans might be using this now also.

[@chandoo_]

Great tips. In fact, I too use ALT ES (and usually follow it with v - values, t - formats, n - links or f - formulas). As most people starting with Excel are not familiar with key sequence concept, I chose to talk up CTRL+ALT+V :)

[@s.laxmankumar.5707]

Great tips Chandoo awesome

[@sampatel7471]

Excellent Sir, Yes it very useful Thanks for sharing

[@chandoo_]

You are most welcome

[@jaliali84]

Amazing, really helpful

[@evelynwald9132]

Wish I had known some of these sooner. Great tips and I love short cuts.

[@chandoo_]

Thank you