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
ruclips.net/video/hcZ2a_sWSY4/видео.html
@@sanjugomra1480 v
Lalit ruclips.net/video/MAjWpPwcTZ0/видео.html
Nice information
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
Superb video. I learn many new things from you.
Thank you
*Thank you so much. Since I used to skip computer lessons way back college days, I just learned the shortcuts thru here.*
Michelle ruclips.net/video/MAjWpPwcTZ0/видео.html
Please like share and subscribe my channel 🙏😊
Bro i am learning this and i am at 4th grade
Maa-Shaa-Allah, thanks Dear. Very informative video.
JazakAllah thank you
What a great shortcut key۔۔۔۔thanks sir
Thank you for your comments
Thanks for sharing this short cut formula
Thank you
Ok super very useful shortcut..pls update many vedios
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
Very helpful information.
Thanks.
Super information , thank you
Thank you chandrakant
Good work..... Thank you.... Its very useful for productivity work.
Thank 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
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.
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
Nice short keys....i mean without mouse very useful for keys
you can find the advance one here
ruclips.net/video/EVVMOgsoJBA/видео.html
Very helpful, thanks
Thanks
Thanks. I learned new excel shortcuts from here which are useful and much needed
now u can find the advance one
ruclips.net/video/EVVMOgsoJBA/видео.html
Concise and Useful
Thank you
Awesome mind blowing thanks
Thank you so much
Very nice sir. Thank you 👍
Thank you
Awesome work.... 👌
Well its amazing information thanks for sharing knowledge
Thank you
Nice. Thanks sir😊. Super understandable vedio..
Needed this refresher thank you
Thank you
superb ,I need more videos like this
Sure 😊
यह वीडियो एक्सेल के लिए सबसे बेस्ट वीडियो है अभी तक मैंने RUclips में इससे बेस्ट वीडियो नहीं देखा
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/
Love it, no crap just useful information
Thank 🙆 you 💯 much 🥰
Thank you
very nice it's very useful
Mind blowing tq tq So much sir
Thank you
superr information boss i like it
Thank you
BRO YOU VIDEO WAS OUTSTANDING. THANK YOU SO MUCH
Atarsh Michelle ruclips.net/video/MAjWpPwcTZ0/видео.html
Please like share and subscribe my channel 🙏😊
Very informative thanks....keep making videos like this...
Top job Saleem😀
Thank you sir... this video is very very useful...
Excellent Dr nice video
Wonderful.. Very very useful video..Thanks for posting this video 👍👍👍
Super se uperrrr bhai
It's really useful video
Thanks a lot
great video sir
Thanks
Wounderfull work amazing sir. Stay connected
Thank You So Mutch.
Thank you
Shortcut keys are awesome thanks
Thanq sir it is very helpful
Welcome
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
Very good
Really useful video👌
Very much helpful thanks and keep making such videos
Great brother
Best work
Nice man performed nice work
Thanks for all this
Very excited
Excellent trick
Very helpful
Thank you
Really nice vidoe
Thank you
Thank you soo much
Thank you
Superb..
very informative video...thankx for uploading this
very thank full to you for this video
excellent work
Excellent Video
Good ..very informative
Thanks for liking
Thanks really infomative
Thank you
Super bro
Super se uper.....
God bless u be happyy
Thank you !!!
Thank you for your comments
Very useful video
Excellent
Tnx useful shortcut keys
Thanks for couple comments 😊
Very useful thanks
Very super video short key
It's really awesome.... good job dear.... great
Good information videos sir
Thanks
Wow awasome
Nice 👌
Thanks
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!
Superbbbbbbb
Thanks 🤗
Good job sir
Thank you
@@dojkicreation welcome sir
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
Love this...
@@dojkicreation yes your contents are indeed helpful....thank to you...😃
Best video naer
Thank you
thank u so much!!!
You're welcome!
Too good buddy
Kya bat hai yar supe awesome short kut keys
Thank you
It's too good very must video thank u
And goo presentation
Really nice
Nice very useful
Thank you
super pa
Thanks vigneshwaran R
Tq Bhai ,good job .
Awesome tricks
Assalamualekum
Very nice, best short cut key's video, but without music
Yes
Except Music it is nice for beginners
That was great.
All of the shortcuts are useful
Good brother
Thanks
Thanks sir nice video
Verry useful video
Very very tq most useful
Really very useful