Excel Shortcut Keys | Full Guide

  Рет қаралды 641,751

Kevin Stratvert

Kevin Stratvert

Күн бұрын

Пікірлер: 170
@KevinStratvert
@KevinStratvert 4 жыл бұрын
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
@salamatuyeabusesay359
@salamatuyeabusesay359 Жыл бұрын
I want to work as a financial assistance but I have no job experience. Can you help
@gowaymike9509
@gowaymike9509 3 жыл бұрын
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
@jillturner4053
@jillturner4053 3 жыл бұрын
omg this is amazing thank you.
@joyabsalon9216
@joyabsalon9216 2 жыл бұрын
True. This is indeed worth mentioning😊
@calystanguyen3929
@calystanguyen3929 Жыл бұрын
Yes. I used a lot of plus and minus sign.
@itsnotif.itswhen
@itsnotif.itswhen Жыл бұрын
Yes, the Ctrl + Shift + plus sign to insert is huge in my daily workflow when I adjust general ledger items for bank reconciliation.
@animate9612
@animate9612 Жыл бұрын
thank you!
@mohdabdulmateen5159
@mohdabdulmateen5159 2 жыл бұрын
Good Evening Sir, I"m from india & i've been searching a teacher like u who gonna explain everything in detail as u did in this video, because i was at zero in MS Excel and unable to find correct path to grow but i found u here, i truly admire u & have a huge respect for your time. Thank u from bottom of my heart. Please keep making new knowledgeable videos on MS Excel. i'v also shared your videos to my loved ones & family.🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰
@AndreaGibson-fc7pt
@AndreaGibson-fc7pt 2 жыл бұрын
Thank you! Just watched a number of your videos from shortcuts to Pivot Tables, Concat and Macros. Your videos are so helpful and much appreciated.
@ciaran110505
@ciaran110505 2 жыл бұрын
Brilliant Kevin you have restored my belief in Excel as i have not had to use it for a while so watching your Videos has been fantastic keep them coming.
@OlufojudeGbenga
@OlufojudeGbenga Ай бұрын
I wish I could like this video a million times it's so simple easy when you teach❤
@6989yogesh
@6989yogesh 2 жыл бұрын
9:55 - T stands for table and L for list box. Tables were referred to list box until 2003 versions.
@KevinStratvert
@KevinStratvert 2 жыл бұрын
Ah, that makes sense! Thanks for sharing!
@johnbutler2750
@johnbutler2750 4 жыл бұрын
The alt shortcut to navigate the ribbon is great!
@wcdx1981
@wcdx1981 3 жыл бұрын
Alt h h to highlight without the mouse saves me time!
@MrDariusAtl
@MrDariusAtl 10 ай бұрын
Kevin always come with fire content. 🙌🏾🔥
@dariusanderton3760
@dariusanderton3760 3 жыл бұрын
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.
@joelweiss7013
@joelweiss7013 4 жыл бұрын
Thanks Kevin. I learned many new ones. I will be watching & studying more of your videos to learn, adapt, and apply my new knowledge.
@MyRockMyFortress
@MyRockMyFortress Ай бұрын
Thank you for this wonderful tutorial.
@saffabockarie1435
@saffabockarie1435 Жыл бұрын
Bro, Excel is my weakness since I came to the United States. I didn’t Accounting from overseas but never did anything about Excel. I really like the Excel shortcuts. And I will definitely prefer to work with you. Hope we can be in touch and get more knowledge on Excel. I really appreciate if you can be my teacher. Thank you .
@ianpatrick23
@ianpatrick23 Жыл бұрын
This was super helpful getting me up to speed on Excel. Thank you!
@kmiracle9948
@kmiracle9948 2 жыл бұрын
you are the best!! Learning alot from you 😌
@arthurletim1248
@arthurletim1248 3 жыл бұрын
this is very helpful for us visually impaired community. shortcut keys is the best way to navigate excel. keep it up! thanks!
@starboy7151
@starboy7151 Жыл бұрын
You are such a perfect guy who should be doing tv apps
@vaibhavsumit7917
@vaibhavsumit7917 3 жыл бұрын
Hi Kevin, nice job learnt 5-6 new shortcut enjoyed your video keep posting such videos. thanks
@ilove2playgames
@ilove2playgames Жыл бұрын
Thank you. The alt+enter, I wanted that. Very helpful.❤
@rasgullakhan7973
@rasgullakhan7973 Жыл бұрын
Excellent video.. Valuable content👍
@nathanielbalmes6597
@nathanielbalmes6597 10 ай бұрын
Thanks, Kevin! This is a big help. :)
@raquelrodriguez865
@raquelrodriguez865 7 ай бұрын
Thank you so much, Kevin - this was awesome :)
@petlover6072
@petlover6072 Жыл бұрын
Oh my God ! ! That's so much help in one video. Thanks a lot
@feraidoonerfani6678
@feraidoonerfani6678 Жыл бұрын
enjoyed with the shortcuts.
@Anikvikram
@Anikvikram Жыл бұрын
Thank you for such a nice video 🎉🎉
@olgacotto7915
@olgacotto7915 Жыл бұрын
Very helpful! Thank you.
@kanikamaheshwari9732
@kanikamaheshwari9732 Жыл бұрын
Merci pour exister! and thanks for the amazing & insightful content 😍
@samueldegraftmintah1226
@samueldegraftmintah1226 2 жыл бұрын
incredible. So easy to learn. Thanks Kevin
@sweetlovevlog9573
@sweetlovevlog9573 Жыл бұрын
Thank you kevin ilearned so many iwill be contenue watching & studying more of your vedios
@zishangamer6392
@zishangamer6392 2 ай бұрын
Yes I got it very helpful video thanks ❤
@meghanb4541
@meghanb4541 3 жыл бұрын
This is excellent. A lot of clear and concise information in a short amount of time. Thank you!
@balakrishnankamala3744
@balakrishnankamala3744 Жыл бұрын
Thank you. It's very much helpful
@dyeninalibut3025
@dyeninalibut3025 Жыл бұрын
Thanks again, Kevin! You make learning easy and straightforward! Glued to your videos!
@m.mohtashim2000
@m.mohtashim2000 4 жыл бұрын
Thank you so much for sharing this sir. I'm so grateful to you for teaching me so much in so little time through your videos. Lots of love and tons of support from your little brother here. ♥️😊
@dianaroseprincillo7924
@dianaroseprincillo7924 2 жыл бұрын
Thank you so much. I learned a lot today:)
@wcarlosw
@wcarlosw 4 жыл бұрын
Can someone do a compilation of his intros? They are the cutest things ever.
@saburjonsaidov2904
@saburjonsaidov2904 3 жыл бұрын
I have learned a lot from your video, thanks a bunch
@ushernleya3626
@ushernleya3626 6 ай бұрын
thanks Kevin good stuff
@UmairAli
@UmairAli Жыл бұрын
a quiz with these shortcut keys would be perfect for a person preparing for exam.
@zombie20x
@zombie20x 2 жыл бұрын
This was really helpful bro thanks
@habibullahalizada6173
@habibullahalizada6173 2 жыл бұрын
Thank you for your information
@RajaEdits3525
@RajaEdits3525 Жыл бұрын
Superb learning Excel shortcuts
@the.min9yu_k.fangirl
@the.min9yu_k.fangirl Жыл бұрын
thank you soooooo much for this!
@partapchandra5739
@partapchandra5739 2 жыл бұрын
Very nice class keep it up Your understanding way is very unique 👌
@MyRockMyFortress
@MyRockMyFortress Ай бұрын
I love Ctrl+Shift+! to apply number format
@wintaendriyas519
@wintaendriyas519 2 жыл бұрын
Thank u soo much this is very helpful
@Sayedalishubbar
@Sayedalishubbar 4 жыл бұрын
thanks for your kind efforts.
@sateshn233
@sateshn233 3 жыл бұрын
Thanks! Everything except 2 I didn't know
@OlufojudeGbenga
@OlufojudeGbenga Ай бұрын
Am literally studying this because of my assignment 😂😂😂
@JumpRopeVeteran
@JumpRopeVeteran 4 жыл бұрын
Thanks a lot. There were several I didn't know.
@anirbanpaul129
@anirbanpaul129 4 жыл бұрын
Hey, this is a cool video . Smart way to use Excel .
@KevinStratvert
@KevinStratvert 4 жыл бұрын
Thanks for the note Anirban!
@shivanmohyaddin
@shivanmohyaddin 4 жыл бұрын
Wow... Your eye color makes it so obvious of how much time you have spent learning this software...
@nataliadavila3827
@nataliadavila3827 3 жыл бұрын
This was extremely helpful! Thank you for making this video. 💜
@salamatuyeabusesay359
@salamatuyeabusesay359 Жыл бұрын
it's really educative.
@buddhinihini6588
@buddhinihini6588 4 жыл бұрын
Thank you so much
@sunpasirithxssunpasiri4759
@sunpasirithxssunpasiri4759 Жыл бұрын
Colud you please teach the tip that "select all colums with blanks row"?
@veronicaromero8642
@veronicaromero8642 4 жыл бұрын
Thank you for sharing the shortcut link !!! Do you have follow along videos???
@veyseltuncalan8638
@veyseltuncalan8638 Жыл бұрын
You are perfect 👍🏻
@naanbread1970
@naanbread1970 4 жыл бұрын
Hello Kevin. Could you tell me how to open 2 spreadsheets at the same time in Teams/SharePoint files? If we have to transfer data from one spreadsheet to another, it's very clunky to open, close, open, close to pull and enter data into separate spreadsheets. Thank you so much. Shout out from Redmond! Sharing your info in our company.. We love your lessons.
@valeriaouriques
@valeriaouriques 2 жыл бұрын
Thank you teacher!!!!!
@parbuarcharya9766
@parbuarcharya9766 4 жыл бұрын
thank you so much sir
@mohdosman4154
@mohdosman4154 3 жыл бұрын
great job
@denisethomas6927
@denisethomas6927 3 жыл бұрын
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?
@reddlief
@reddlief 8 ай бұрын
Seems I need to use the keyboard row of numbers and not my keypad numbers. Only works with the top row. Great video. Can you copy a formula down a column using a short cut?
@dclarek741
@dclarek741 2 жыл бұрын
If I have a number that is 17 digits long but I only want to sort by the last 6 digits. How do I break up these 17 digits?
@threeaxis359
@threeaxis359 3 жыл бұрын
Thank You you're awesome!
@amosmuvona4347
@amosmuvona4347 4 жыл бұрын
Thank you so much.
@dmatula811
@dmatula811 2 жыл бұрын
Is there a screen recorder that allows you to show the keyboard and the keys you select?
@deshanbandara2313
@deshanbandara2313 3 жыл бұрын
Great job..!
@Suzukii-Krypto
@Suzukii-Krypto 2 жыл бұрын
Thanks for your video. Are there keyboard shortcuts for moving pasted images to the back or to the front? Thanks in advance.
@lealoveees
@lealoveees 4 жыл бұрын
I always use ALT+H BA and ALT+H BT
@vijaykumar-nt3hd
@vijaykumar-nt3hd 2 жыл бұрын
Thank you so much ✔️👍
@WTPlearn
@WTPlearn Жыл бұрын
Great resource. You may want to double check your Ctrl+Shift+Home and Ctrl+Shift+End The printed instructions seem to not follow the directions.
@ahamedriyas4712
@ahamedriyas4712 2 жыл бұрын
Thank you🤩
@thawthaw3035
@thawthaw3035 Жыл бұрын
Thank you Sir Kevin
@Gcharms
@Gcharms 2 ай бұрын
Great video. Can someone tell me how do I remove the shortcuts to start with key "/". Thank you
@compound32
@compound32 4 жыл бұрын
Is there a way, with using the Hyperbole Link application I could navigate into links by using CTRL + [any key] sticky keys?
@thirikyaw7701
@thirikyaw7701 4 жыл бұрын
Thank You so much for your sharing .
@RexRaven22
@RexRaven22 7 ай бұрын
Thank you
@cityslicker4983
@cityslicker4983 2 жыл бұрын
To delete a column: Ctrl+Space Ctrl+- To delete a row: Ctrl+Shift Ctrl+-
@victorape5688
@victorape5688 2 жыл бұрын
Interesting. Thanks.
@karenjohnson9855
@karenjohnson9855 2 жыл бұрын
Curios, do we have the same symbols in MS Word as with excel say for other languages, Spanish , Chinese, or German?
@swethakadem195
@swethakadem195 Жыл бұрын
Hey Kevin, Do we have keyboard shortcut key to increase the column width like how we drag and adjust the same with mouse
@lucky-nz1ll
@lucky-nz1ll 4 жыл бұрын
Hi Mr. Kevin I am WPS user, then i found out some shortcut keys are not applicable.Anything you can advise?
@IsroNasa-r5m
@IsroNasa-r5m Жыл бұрын
I love it
@kalaklah4848
@kalaklah4848 4 жыл бұрын
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
@anikchowdhury9708
@anikchowdhury9708 2 жыл бұрын
Superb,just too good
@piyushnegi307
@piyushnegi307 Жыл бұрын
Soo smooth
@rajiblochanswain2896
@rajiblochanswain2896 8 ай бұрын
Today is my exam and may this video help me😅🙏
@gohst101pubg8
@gohst101pubg8 2 жыл бұрын
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 😅
@billjuss5331
@billjuss5331 2 жыл бұрын
Thanks Kevin, Great KZbin. Is there a shortcut to add the Date and time in 2-columns at the same time?
@ceryp9592
@ceryp9592 2 жыл бұрын
How to unprotect excel workbook password? Please help! thank you
@SaraHettiarachchi-rd8hy
@SaraHettiarachchi-rd8hy Жыл бұрын
Can I know how to change lowercase & uppercase in typed text
@mimisin6488
@mimisin6488 Жыл бұрын
Hello Kevin, is this tutorial for Macbooks? I tried using Option as the Alt key, and it did not work....
@hussainfawzer
@hussainfawzer 4 жыл бұрын
I knew it all... But I’m new to excel!
@raoppacheco7654
@raoppacheco7654 4 жыл бұрын
How do you delete a sheet with a shortcut? God video!.
@ravelbella7330
@ravelbella7330 4 жыл бұрын
RAOP PACHECO Good not God
@dianal9346
@dianal9346 4 жыл бұрын
ravel bella 👎🏽👎🏽👎🏽
@saiyankjaisi
@saiyankjaisi Жыл бұрын
which screen recorder are you using?
@Lord_of_Pings
@Lord_of_Pings 3 жыл бұрын
Sir Amazing
@suryabhai8813
@suryabhai8813 4 жыл бұрын
Hi Kevin , thank you for the video.could you please explain about Excel VDB and how to use it?
@KevinStratvert
@KevinStratvert 4 жыл бұрын
Thanks for the suggestion Surya! I'll add it to my list of videos to create. Cheers!
@melodyjr8995
@melodyjr8995 4 жыл бұрын
thank you. please teach how to create attendance, new version
Top 20 Microsoft Excel Tips & Tricks
25:38
Kevin Stratvert
Рет қаралды 785 М.
Top Windows 10 Shortcut Keys
16:58
Kevin Stratvert
Рет қаралды 323 М.
IL'HAN - Qalqam | Official Music Video
03:17
Ilhan Ihsanov
Рет қаралды 700 М.
СИНИЙ ИНЕЙ УЖЕ ВЫШЕЛ!❄️
01:01
DO$HIK
Рет қаралды 3,3 МЛН
Mom Hack for Cooking Solo with a Little One! 🍳👶
00:15
5-Minute Crafts HOUSE
Рет қаралды 23 МЛН
Что-что Мурсдей говорит? 💭 #симбочка #симба #мурсдей
00:19
Excel Keyboard Shortcuts Pros Swear By to x10 PRODUCTIVITY
19:05
MyOnlineTrainingHub
Рет қаралды 215 М.
Excel Tutorial for Beginners
31:13
Kevin Stratvert
Рет қаралды 497 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 271 М.
5 Excel Tools Most Users Never Think to Use (Files Included)
12:34
MyOnlineTrainingHub
Рет қаралды 268 М.
Excel for Beginners - The Complete Course
54:55
Technology for Teachers and Students
Рет қаралды 8 МЛН
12 AMAZING Keyboard Shortcuts You Need to Know
10:18
Lea David
Рет қаралды 947 М.
Top 10 Most Important Excel Formulas - Made Easy!
27:19
The Organic Chemistry Tutor
Рет қаралды 8 МЛН
How to Use XLOOKUP in Microsoft Excel
13:39
Kevin Stratvert
Рет қаралды 190 М.
🧙‍♂️ Pivot Table Excel Tips & Tricks
17:23
Kevin Stratvert
Рет қаралды 430 М.
IL'HAN - Qalqam | Official Music Video
03:17
Ilhan Ihsanov
Рет қаралды 700 М.