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 :)
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
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
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 :)
Thanks
th-cam.com/video/hcZ2a_sWSY4/w-d-xo.html
@@sanjugomra1480 v
Lalit th-cam.com/video/MAjWpPwcTZ0/w-d-xo.html
Nice information
What a great shortcut key۔۔۔۔thanks sir
Thank you for your comments
Maa-Shaa-Allah, thanks Dear. Very informative video.
JazakAllah thank you
Superb video. I learn many new things from you.
Thank you
thank you for another of your amazing videos the food you make always look so delicious
Thank you
Thank you so much for useful information you save our time..
Thank you
Top job Saleem😀
यह वीडियो एक्सेल के लिए सबसे बेस्ट वीडियो है अभी तक मैंने TH-cam में इससे बेस्ट वीडियो नहीं देखा
Thanks for sharing this short cut formula
Thank you
Waooo... really helpful 👍😊
Thank you
@@dojkicreation but I don't know why..I m not able to use the formula of some of all... Can you help me out
@@Vegkitchenvlog Yes Sure! You can also visit: dojkicreation.com/category/microsoft-excel/shortcut-keys/
Awesome work.... 👌
Very nice sir. Thank you 👍
Thank you
Super information , thank you
Thank you chandrakant
Super se uperrrr bhai
Concise and Useful
Thank you
Good work..... Thank you.... Its very useful for productivity work.
Thank you
This is an amazing video, i like ho u help students .. and this amazing video helps us to remove duplicates in 15 sec.
Thanks and welcome
Good information..I got some keys from this video 👍
Thanks for the comment
Really handy video. All the shortcuts actually worked and the video was easy to follow. TFS!
In my laptop alt f11 is not working. It is going to vba page
*Thank you so much. Since I used to skip computer lessons way back college days, I just learned the shortcuts thru here.*
Michelle th-cam.com/video/MAjWpPwcTZ0/w-d-xo.html
Please like share and subscribe my channel 🙏😊
Bro i am learning this and i am at 4th grade
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
Cảm ơn bạn rất nhiều vì đã thích video của tôi. Bạn phải chia sẻ video này với bạn bè và gia đình của bạn và đăng ký kênh của tôi.
Very helpful, thanks
Thanks
Nice. Thanks sir😊. Super understandable vedio..
Ok super very useful shortcut..pls update many vedios
Very helpful information.
Thanks.
Awesome mind blowing thanks
Thank you so much
superr information boss i like it
Thank you
Really useful video👌
Well its amazing information thanks for sharing knowledge
Thank you
Thank 🙆 you 💯 much 🥰
Thank you
Excellent Dr nice video
very nice it's very useful
Wonderful.. Very very useful video..Thanks for posting this video 👍👍👍
Thanks. I learned new excel shortcuts from here which are useful and much needed
now u can find the advance one
th-cam.com/video/EVVMOgsoJBA/w-d-xo.html
superb ,I need more videos like this
Sure 😊
great video sir
Thanks
Love it, no crap just useful information
Mind blowing tq tq So much sir
Thank you
It's really useful video
Thanks a lot
Nice short keys....i mean without mouse very useful for keys
you can find the advance one here
th-cam.com/video/EVVMOgsoJBA/w-d-xo.html
Super se uper.....
God bless u be happyy
Very informative thanks....keep making videos like this...
Very excited
Great brother
Nice 👌
Thanks
Thank you sir... this video is very very useful...
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
Tôi rất biết ơn bạn
Really nice vidoe
Thank you
Needed this refresher thank you
Thank you
BRO YOU VIDEO WAS OUTSTANDING. THANK YOU SO MUCH
Atarsh Michelle th-cam.com/video/MAjWpPwcTZ0/w-d-xo.html
Please like share and subscribe my channel 🙏😊
Best work
Nice man performed nice work
Thanks for all this
Excellent trick
Very super video short key
Shortcut keys are awesome thanks
Good ..very informative
Thanks for liking
Super bro
Very useful👍......👌
It's really awesome.... good job dear.... great
Very much helpful thanks and keep making such videos
Excellent Video
Good information videos sir
Thanks
Very useful video
Wounderfull work amazing sir. Stay connected
Very helpful
Thank you
Superb..
Kya bat hai yar supe awesome short kut keys
Thank you
Thanq sir it is very helpful
Welcome
Ais video na to excel easy kar Diya mera liya mera liya yeh video bari usefull sabit hoii
Bhai tu classes join kiya hai excel ke liye!
Tq Bhai ,good job .
Awesome tricks
Too good buddy
Nice very useful
Thank you
Very useful thanks
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
Thank you For Information Comment
Thanks
Really most useful bro
very informative video...thankx for uploading this
Thank You So Mutch.
Thank you
Best video naer
Thank you
Useful information
Very good
Good job sir
Thank you
@@dojkicreation welcome sir
Really nice
And goo presentation
GREAT VIDEO USEFUL THING
Thank you
Superbbbbbbb
Thanks 🤗
Tnx useful shortcut keys
Thanks for couple comments 😊
very thank full to you for this video
excellent work
Thanks really infomative
Thank you
Thanks sir nice video
Really very useful
Verry useful video
Solla varthaigale illanna tq so much 👌👍👏👏👏👏👏👏
That was great.
All of the shortcuts are useful
It's too good very must video thank u
Thank you soo much
Thank you
Very very tq most useful
Wow awasome
Good brother
Thanks
Love this...
@@dojkicreation yes your contents are indeed helpful....thank to you...😃