Most Useful Microsoft Excel Shortcut Keys 

1 Create a formula to sum all of the above cells - Alt+F11 2 Current Date - Ctrl + ; 3 Current Time - Ctrl + Shift + ; 4 Select Entire row - Shift + Space 5 Select Entire Column - Ctrl + Space 6 Hide Rows - Ctrl + 9 7 Hide Column - Ctrl + 0 8 Delete a Column or Row - Ctrl + - 9 New Line In Cell - Alt+Enter 10 Show hide Formula - 11 Save As active file - F12 12 Create Charte From Select Date - F11 13 Insert New Worksheet - Shift + F11 14 Move Forward Between worksheets in the same document. Ctrl + Pg Down 15 Move back between worksheets in the same documnet. - Ctrl + Pg Down 16 Format Number in comma format - Ctrl + Shift + 1 17 Format number in date format - Ctrl _ Shift +3 18 Format number in currency format ($) - Ctrl + Shift +4 19 Format number in percentage format - Ctrl +Shift + 5 20 Move to cell A1 - Ctrl + Home 21 Switch between showing Excel formula or their values in cells - Ctrl + ` Can be kept handy in OneNote or Google Keep :)

*Thank you so much. Since I used to skip computer lessons way back college days, I just learned the shortcuts thru here.*

Maa-Shaa-Allah, thanks Dear. Very informative video.

यह वीडियो एक्सेल के लिए सबसे बेस्ट वीडियो है अभी तक मैंने RU-vid में इससे बेस्ट वीडियो नहीं देखा

Ctrl+N: Create a new workbook Ctrl+O: Open an existing workbook Ctrl+S: Save a workbook F12: Open the Save As dialog box Ctrl+W: Close a workbook Ctrl+F4: Close Excel F4: Repeat the last command or action. For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell. Shift+F11: Insert a new worksheet Ctrl+Z: Undo an action Ctrl+Y: Redo an action Ctrl+F2: Switch to Print Preview F1: Open the Help pane Alt+Q: Go to the “Tell me what you want to do” box F7: Check spelling F9: Calculate all worksheets in all open workbooks Shift+F9: Calculate active worksheets Alt or F10: Turn key tips on or off Ctrl+F1: Show or hide the ribbon Ctrl+Shift+U: Expand or collapse the formula bar Ctrl+F9: Minimize the workbook window F11: Create a bar chart based on selected data (on a separate sheet) Alt+F1: Create an embedded bar chart based on select data (same sheet) Ctrl+F: Search in a spreadsheet, or use Find and Replace Alt+F: Open the File tab menu Alt+H: Go to the Home tab Alt+N: Open the Insert tab Alt+P: Go to the Page Layout tab Alt+M: Go to the Formulas tab Alt+A: Go to the Data tab Alt+R: Go to the Review tab Alt+W: Go to the View tab Alt+X: Go to the Add-ins tab Alt+Y: Go to the Help tab Ctrl+Tab: Switch between open workbooks Shift+F3: Insert a function Alt+F8: Create, run, edit, or delete a macro Alt+F11: Open the Microsoft Visual Basic For Applications Editor

Assalamualekum Very nice, best short cut key's video, but without music

thank you for another of your amazing videos the food you make always look so delicious

Thanks. I learned new excel shortcuts from here which are useful and much needed

Really handy video. All the shortcuts actually worked and the video was easy to follow. TFS!

Thank you so much for useful information you save our time..

Superb video. I learn many new things from you.

that su bo ich, rat ne va quy nhung nguoi san sang chua se kien thuc ban than cho nguoi khac cam on ban rat nhieu

Ok super very useful shortcut..pls update many vedios

Wounderfull work amazing sir. Stay connected

Very helpful information. Thanks.

Very informative thanks....keep making videos like this...

Wonderful.. Very very useful video..Thanks for posting this video 👍👍👍

BRO YOU VIDEO WAS OUTSTANDING. THANK YOU SO MUCH

Very much helpful thanks and keep making such videos

What a great shortcut key۔۔۔۔thanks sir

Good work..... Thank you.... Its very useful for productivity work.

Well its amazing information thanks for sharing knowledge

Nice short keys....i mean without mouse very useful for keys

Thanks for sharing this short cut formula

This is an amazing video, i like ho u help students .. and this amazing video helps us to remove duplicates in 15 sec.

em cam on chi rat nhieu chuc chi nhieu suc khoe va thanh cong trong cong viec mong la trong tuong lai se co co hoi gap chi de duoc chi chi day nhieu hon

very thank full to you for this video excellent work

Love it, no crap just useful information

Best work Nice man performed nice work Thanks for all this

Good information..I got some keys from this video 👍

Nice. Thanks sir😊. Super understandable vedio..

Very good

I broke my comment button today v. Useful information thanks 👍👍😊

sir very nice. thank you so much.. i have learn some formulas in my office but now also i learn new formulas as well with old one also thanks a lot

very nice it's very useful

Very nice sir. Thank you 👍

Super information , thank you

Very use full information thanq very much sir

Thank you sir... this video is very very useful...

Awesome mind blowing thanks

Very helpful, thanks

very informative video...thankx for uploading this

Awesome work.... 👌

Ais video na to excel easy kar Diya mera liya mera liya yeh video bari usefull sabit hoii

great work! please make more informative videos​, thanks for this vedio.

Needed this refresher thank you

superb ,I need more videos like this

Who else found music was irritating but nice keys !!

Concise and Useful

superr information boss i like it

That was great. All of the shortcuts are useful

Good information videos sir

Really nice vidoe

Super Sir It will Helping me Very Much Thanks for that Sir

Itna danger music 😁

It's really useful video

IF WE CAN SUMMARISE ALL SHORT KEYS IN LAST IT WILL BE MORE EFFECTIVE AND REMERABLE

Best video naer

0:15 Alt + F11 is used to open the VBA editor. At least for my version of Excel, Must have been Alt + = to sum all above cells

Very helpful who are new laptop user

great video sir

Thanks a lot. I want more shortcut. It really helps me. Keep it up.

I have not seen this type of video till today

Excellent Video

Excellent work you have done

Thanq sir it is very helpful

Super se uperrrr bhai

Thank 🙆 you 💯 much 🥰

Excellent Dr nice video

Tq for useful shortcuts sir. How can we unhide the cell.

Verry useful video

And goo presentation

Shortcut keys are awesome thanks

Very helpful

It's really awesome.... good job dear.... great

Mind blowing tq tq So much sir

Really useful video👌

Nice very useful

Thanks really infomative

Thank You So Mutch.

Excellent shortcuts key. Also welcome to my channel

Very super video short key

You did a wonderful work... Thanks dost

Thanks you so much

Solla varthaigale illanna tq so much 👌👍👏👏👏👏👏👏

most important shortcuts....very nice

Sir i have one doubt u said we can hide row or column but how retrive the row or column if we needed

Very useful video

It's too good very must video thank u

Excellent trick

Tnx useful shortcut keys

Super tricks thanks

very useful tips !! great compilation saleem !!!

Thank you soo much

Thank u so much sir I appreciate ur hardwork

GREAT VIDEO USEFUL THING

Super bro

Nice video.make more videos like this

Good brother