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

Want to learn some useful Excel shortcuts, but not sure which ones? Here is my choice of top 10 shortcuts to learn. Master these and your productivity will soar.
They are:
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
For a full list of important shortcuts, see this page - chandoo.org/wp/35-tips-data-a...
More:19 of my favourite Excel Shortcuts - • 19 Excel Shortcuts you...
#ExcelShortcuts #Top10Shortcuts

[@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. 😂

[@y73]

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

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

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

[@davidhush7772]

Brilliant. I always learn something new from these videos.

[@raziajeena9861]

i love the right mouse key on the keyboard, to access context sensitive menus and love all your explanations. Thanks!

[@sureshy344]

Thank you Chandoo for all the excel shotcuts

[@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! ❤

[@foodcity9875]

Great effort and inputs added in your discription it is very useful and you did value added time to everyone 👏❤️ many thanks

[@pavansuranani6670]

Thankyou for this valuable information.You make excel so much easy .Thankyou for the great service 🙏

[@itsdaj]

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

[@vikramgupta3827]

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

[@chandoo_]

You bet!

[@rakeshchoubay3983]

Thank you sir. Its really helpful.

[@laurak5196]

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

[@chandoo_]

Thanks Laura.. 😀

[@angmathew4377]

pure gold. Thank you Sir!

[@svensonjacob]

Awesome video, thank you Chandoo!

[@singhalsachin2003]

Great Stuff Chandoo...Thanks for this video.

[@jermsbestfriend9296]

Thank you Chandoo

[@abdulbasital-sufyani6828]

Always adding value
Thanks

[@ExcelFlash]

Thank you! All are very useful. Just need to remember them :)

[@jaliali84]

Amazing, really helpful

[@PaulWelsh]

Loving your work Chandoo

[@PaulNordvik]

Fantastic List!

[@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 :)

[@ramachandusharma5867]

Very useful video. Thanks for sharing

[@mauricelee2219]

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

[@rahulshewale9206]

Thank you sir ,
Your video always helpful to me
I learn so many things from you,
I am always thankful to you.

[@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. :)

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

[@kimberleyjanecanon1653]

Your videos are really helpful ❤❤❤❤

[@dkgdkg546]

YOUR VIDEOS ALWAYS GREAT THANK YOU VERY MUCH.

[@mochasweet4966]

Very useful. Thank you!

[@cleofaspintolimalima1627]

Wonderful teacher

[@JasonMilner]

I LIKE that F9 formula reveal - many thanks!

[@EricaDyson]

Perfect! Thanks so much. Really helpful

[@chandoo_]

Glad it was helpful!

[@_KING_SHADOW]

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 😀

[@krishnabairi1581]

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

[@galaxyx723]

very useful,,,, thank you so much

[@venkatiyer7459]

Thanks again for the nice explanation

[@parth_pm16]

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

[@yograjmalik165]

Appreciate the video!!!

[@aatifrashid5413]

Brilliant Explanation

[@analiesianogueiracruz6912]

Thats crazy fine, thanks.

[@bhupendrabissa2883]

Thank You Chandu your Tutorials are truly blessings for me.....thank you so much ❤️

[@chandoo_]

Glad to hear that

[@ExcelWithChris]

Great one! Thanks Chandoo.

[@chandoo_]

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

[@udhayakhanthl6464]

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

[@22boali]

Simple and professional explanation, thank you very much

[@chandoo_]

Glad you liked it

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

[@BhageshwarDham-sz7wt]

Wow! Nice one❤

[@duarte.arthur]

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

[@chandoo_]

My pleasure!

[@justjacqueline2004]

Brilliant.

[@arunsureshbabu2708]

Very much helpful.

[@nikhilninan210]

Really useful! Appreciate your work greatly

[@chandoo_]

Glad it was helpful!

[@lloydmcleod629]

This is game-changing

[@Mu00lia]

Thanks 👍

[@Sreejithmusic]

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

[@asifgulfarosh6732]

Lot of learning going on from your playlist thanks sir

[@chandoo_]

You are most welcome

[@prashantnayak9535]

Thanks a lot Sir

[@evelynwald9132]

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

[@chandoo_]

Thank you

[@suvzar6194]

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

[@adrianaghita1520]

Many thanks ,there are very usefuly in my financial work

[@udayverlekar7172]

Thank alott..was really helpfull..

[@vk9h]

Thanks nice tuto

[@papachoudhary5482]

Thanks! Sir

[@terihandrick2333]

Thank you Chandoo outstanding as always

[@chandoo_]

My pleasure!

[@santoshmn]

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

[@brendensong8000]

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

[@chandoo_]

I hate click tax...

[@khushdilinsaan3605]

thank you sir

[@julitacastro17]

very useful😍

[@joeloffredo204]

Awesome - thanks!!

[@chandoo_]

You're welcome!

[@Global_Analysis]

Good move Chandoo

[@afsarbmahmud]

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

[@chandoo_]

🤣

[@saurabh4294]

Thank you Sir 🙏

[@chandoo_]

Most welcome

[@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 :)

[@shaguirre]

You are the best. Peace

[@bijaytanty8434]

Thanks

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

[@SanthoshKumar-xy3zm]

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

[@chandoo_]

My pleasure 😊

[@shoaibrehman9988]

Sir, Awesome this is daily use but the way you explained it force me use as much i can thanks

[@chandoo_]

Glad to hear that

[@sunjulie1009]

this is awesome!!!! thank you

[@chandoo_]

Glad you like it!

[@mohammadjameel3783]

Very useful

[@ruthieisham5939]

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

[@chandoo_]

Thanks Ruthie... :)

[@Alhusam]

O man, that was very helpful. You may think of making another part for another 10 most important shortcuts selected form those in the comments.

[@maurolimaok]

Nice video. Thanks!

[@chandoo_]

Glad you liked it!

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

[@Nikhilsharma-ry7sh]

One more

[@querrythis]

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

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

[@w.c.7247]

Very helpful! I checked out your website, a lot of great information provided as well. Count me as a new fan.

[@chandoo_]

Welcome aboard!

[@MuraliKrishnaChejerla20101984]

Good one

[@Merewah97]

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

[@shaikusman536]

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

[@althaflifestyle]

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

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

[@sampatel7471]

Excellent Sir, Yes it very useful
Thanks for sharing

[@chandoo_]

You are most welcome

[@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... 😅

[@hasfiz]

Learnt a new one, repetition of last action with F4 👍

[@ASHOKKUMAR-jm6yn]

Lots of love to u chandu

[@chandoo_]

Thank you Ashok.

[@FRANKWHITE1996]

Thank you.

[@chandoo_]

You're welcome!

[@rautorama]

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

[@chandoo_]

Great addition :)