Save time and conquer the spreadsheet with these 50 Excel keyboard shortcuts. Get the most out of Excel in Windows with these pro tips.
Follow along with the workbook cheat sheet that I use in this video:
https://1drv.ms/x/s!AmxrofZZlZ-whIgBLWAcYJ-M9WGYsA?e=8eCtYg
Watch more Excel tutorial videos: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
50 time-saving Excel shortcuts by Microsoft:
https://aka.ms/50_Excel_Shortcuts
Comprehensive article on all Excel shortcut keys:
https://support.office.com/en-us/article/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f
Many users find that using an external keyboard with keyboard shortcuts for Excel helps them work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using a mouse.
Notes:
The shortcuts in this topic refer to the US keyboard layout. Keys for other layouts might not correspond exactly to the keys on a US keyboard.
A plus sign (+) in a shortcut means that you need to press multiple keys at the same time.
As full-disclosure, I work at Microsoft as a full-time employee.
source
help me , How can I get the sum of my IMEI and Mac address using MS Excel? After getting the sum and multiplied by 11, how can I execute "nck" calculation in Ms Excel?
Thank you for sharing the shortcut link !!! Do you have follow along videos???
Kevin great video. Ques. what formula to subtract between cells using a large volume of values. ex, cell A1 minus cell C1 with answer in B1. repeating like that again with values in D1 minus F1 with answer in E1? repeating . I am wondering how to tell excel to just subtract into the empty cells between the two values
ctrl + 1 not working in my excel 2019 for windows 10. Can you assist please?
📺 Watch more Top Tips & Tricks like this for other products: https://youtube.com/playlist?list=PLlKpQrBME6xLt_itmVIfS2qz9cLEarwMN
I knew it all…
But I’m new to excel!
Thank you so much
Is there a way, with using the Hyperbole Link application I could navigate into links by using CTRL + [any key] sticky keys?
The alt shortcut to navigate the ribbon is great!
Shit got distracted reading comments, he said slot since then. Not passing bio….
Hi Kevin it's not clear
This was super helpful. Thank you! I actually have one request for a shortcut, I saw it used a few years ago and can't remember what keys to use. So, working if formulas referencing different worksheet there was a shortcut key which is almost like F2 function when the formula cell is selected but it takes you to the actual cell the formula is referencing. Do you know what keys those are?
His Kevin,
I think this is begginer tutorial. There are more advanced shortcuts.
I’m waiting for this tutorial (for example: Ctrl+Alt+V = paste special or Ctrl+double C = pane window) 👁
Hey Kevin, I'm trying to use this on MacOS, is it possible? I always use those keyboard shortcuts on windows but now i'm in a trouble.
Nice vid
thanks a lot
I love this, you have made my job so much easier. I do have a question. I was (Making a correction)working on the middle of my spreadsheet. I had to go to the end to add more info. How do I get back to that spot I was working on without having to scroll up. Is there a shortcut to go back to the last spot I was making a correction on?
thank you!!!
Hi Kevin, nice job learnt 5-6 new shortcut enjoyed your video keep posting such videos. thanks
There are short keys worth mentioning that not covered in this video. After selecting row(s) or column(s) by using the shortcut key as illustrated in this video, press Ctrl + minus sign to delete, Ctrl + Shift + plus sign to insert
Kindly create WhatsApp group
Great job..!
Wow
I have learned a lot from your video,
thanks a bunch
Thanks! Everything except 2 I didn't know
a story from a very long time ago I first learned spreadsheets before computer mice were common, and many things were in DOS (before WIndows). Keyboard shortcuts were the only way to do things, along with Function keys. Then when Windows and computer mice came along it seemed like all the young people were using the mouse and right clicking or left clicking on things, and it was just the old people who used the keyboard shortcuts. So I kind of forgot many of the keyboard shortcuts for a few years, but then other people were all saying the shortcuts were faster so I took the effort to learn them again.
Really enjoying your videos Kevin, they're very useful! Keep them coming.
this is very helpful for us visually impaired community. shortcut keys is the best way to navigate excel. keep it up! thanks!
Thank You you're awesome!
Sir Amazing
This is excellent. A lot of clear and concise information in a short amount of time. Thank you!
Dear bro.i need some excel row files for practice
This was extremely helpful! Thank you for making this video. 💜
great job
how to see fill hand in excel with keyboard
its helpful , and useful but how I'm going to memorize all of them it will take lots of time to do but better to understand it first and practice 😅
You are jumping around too fast.