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

#ExcelShortcuts #Top10Shortcuts

[scottolson]

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!

[srinivasn]

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

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

[vikramgupta]

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

[y]

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

[udhayakhanthl]

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

[asifgulfarosh]

Lot of learning going on from your playlist thanks sir

[rahulchopra]

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

[JayshreeZamvar]

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

[thangaveluraj]

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

[Nitinpaste-kl]

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

[saivardhan]

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 for your you will be teaching us more all the time..!!!

[JasonMilner]

I LIKE that F9 formula reveal - many thanks!

[galaxyx]

very useful, , , , thank you so much

[wayneedmondson]

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

[philippehenrion]

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)

[itsdaj]

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

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

[adrianaghita]

Many thanks, there are very usefuly in my financial work

[Sreejithmusic]

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