Most Useful Microsoft Excel Shortcut Keys
ฝัง
- เผยแพร่เมื่อ 24 ก.พ. 2017
- Learn the most useful Microsoft Excel shortcut keys to save time and boost your productivity! This video covers all the essential Excel keyboard shortcuts for beginners and experienced users alike.
In this video, you'll learn:
How to navigate the Excel worksheet quickly and easily
How to format text and numbers with keyboard shortcuts
How to use keyboard shortcuts to insert and edit formulas
How to use keyboard shortcuts to work with data
And much more!
Whether you're a student, professional, or just someone who wants to get more out of Excel, this video is for you.
**Social Media**
/ dojkicreation
/ dojkicreation
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
*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
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
Love it, no crap just useful information
Excellent work you have done
Very use full information thanq very much sir
What a great shortcut key۔۔۔۔thanks sir
Thank you for your comments
Solla varthaigale illanna tq so much 👌👍👏👏👏👏👏👏
Maa-Shaa-Allah, thanks Dear. Very informative video.
JazakAllah thank you
Thank you for sharing 👍
most important shortcuts....very nice
Very helpful information.
Thanks.
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
Ok super very useful shortcut..pls update many vedios
Super Sir It will Helping me Very Much Thanks for that Sir
Very good
very thank full to you for this video
excellent work
Superb video. I learn many new things from you.
Thank you
thank you, sir, really most helpful
Very much helpful thanks and keep making such videos
Very informative thanks....keep making videos like this...
That was great.
All of the shortcuts are useful
Thank you so much for useful information you save our time..
Thank you
Amazing superb..
Shortcut keys are awesome thanks
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 🙏😊
Wounderfull work amazing sir. Stay connected
Thanks bro it's really helpful
very informative video...thankx for uploading this
Best work
Nice man performed nice work
Thanks for all this
Assalamualekum
Very nice, best short cut key's video, but without music
Yes
Except Music it is nice for beginners
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 useful video nice work
Thank you sir... this video is very very useful...
And goo presentation
very useful tips !! great compilation saleem !!!
Wonderful.. Very very useful video..Thanks for posting this video 👍👍👍
You did a wonderful work...
Thanks dost
Very Nice
So Thanks
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
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
Needed this refresher thank you
Thank you
very nice it's very useful
Great Job.. Thank you
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
Concise and Useful
Thank you
I'never seen this type of vedio it's too good 👍👏👏👏👌
U did a nice work
Best video naer
Thank you
Thanks for the hint 👍👍
Super se uperrrr bhai
This is awesome
Super.thankyou sir
Tq for useful shortcuts sir. How can we unhide the cell.
Thanks for sharing this short cut formula
Thank you
Super tricks thanks
Awesome mind blowing thanks
Thank you so much
Excellent Video
Thanks a lot. I want more shortcut. It really helps me. Keep it up.
I have already subscribed your youtube channel and press the bell icon.
Very useful video
For forward and back between worksheets in same document u used same formula is it correct?
Nice. Thanks sir😊. Super understandable vedio..
Thanks
Awesome work.... 👌
great work! please make more informative videos, thanks for this vedio.
Thanks
Excellent trick
Love this...
@@dojkicreation yes your contents are indeed helpful....thank to you...😃
THAT'S GREAT IDEA
its really help full
thank you for another of your amazing videos the food you make always look so delicious
Thank you
Thank you bro
Very helpful, thanks
Thanks
Super se uper.....
God bless u be happyy
சூப்பர்
Very excited
Thank u so much sir I appreciate ur hardwork
Sir u do more video plz so that it is helpful
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
Thanks a lot
thanx sir
Very useful thanks
Super information , thank you
Thank you chandrakant
Nice information
Very useful👍......👌
Well its amazing information thanks for sharing knowledge
Thank you
Good work..... Thank you.... Its very useful for productivity work.
Thank you
So interested!
It's too good very must video thank u
Thank you sir very helpful me your vdo
Useful sir
Very nice and important kays thanks
Tq Bhai ,good job .
Nice, and thanks a lot
Good information videos sir
Thanks
Thank you
Verry useful video
Top job Saleem😀
It's really awesome.... good job dear.... great
Very nice sir. Thank you 👍
Thank you
I broke my comment button today v. Useful information thanks 👍👍😊