Excel Shortcut Keys | Full Guide

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
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:
1drv.ms/x/s!AmxrofZZlZ-whIgBL...
Watch more Excel tutorial videos: • ❎ How to use Excel
50 time-saving Excel shortcuts by Microsoft:
aka.ms/50_Excel_Shortcuts
Comprehensive article on all Excel shortcut keys:
support.office.com/en-us/arti...
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
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.

[@KevinStratvert]

🏫 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: czcams.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html

[@salamatuyeabusesay359]

I want to work as a financial assistance but I have no job experience. Can you help

[@AndreaGibson-fc7pt]

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.

[@mohdabdulmateen5159]

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.🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰

[@joelweiss7013]

Thanks Kevin. I learned many new ones. I will be watching & studying more of your videos to learn, adapt, and apply my new knowledge.

[@ciaran110505]

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.

[@gowaymike9509]

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]

omg this is amazing thank you.

[@joyabsalon9216]

True. This is indeed worth mentioning😊

[@calystanguyen3929]

Yes. I used a lot of plus and minus sign.

[@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]

thank you!

[@dyeninalibut3025]

Thanks again, Kevin! You make learning easy and straightforward! Glued to your videos!

[@arthurletim1248]

this is very helpful for us visually impaired community. shortcut keys is the best way to navigate excel. keep it up! thanks!

[@ianpatrick23]

This was super helpful getting me up to speed on Excel. Thank you!

[@dariusanderton3760]

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.

[@samueldegraftmintah1226]

incredible. So easy to learn. Thanks Kevin

[@vaibhavsumit7917]

Hi Kevin, nice job learnt 5-6 new shortcut enjoyed your video keep posting such videos. thanks

[@thomasman1952]

Thank You so much for your sharing .

[@meghanb4541]

This is excellent. A lot of clear and concise information in a short amount of time. Thank you!

[@6989yogesh]

9:55 - T stands for table and L for list box. Tables were referred to list box until 2003 versions.

[@KevinStratvert]

Ah, that makes sense! Thanks for sharing!

[@ilove2playgames]

Thank you. The alt+enter, I wanted that. Very helpful.❤

[@compound32]

Is there a way, with using the Hyperbole Link application I could navigate into links by using CTRL + [any key] sticky keys?

[@saburjonsaidov2904]

I have learned a lot from your video,
thanks a bunch

[@Sayedalishubbar]

thanks for your kind efforts.

[@m.mohtashim2000]

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. ♥️😊

[@naanbread1970]

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.

[@Suzukii-Krypto]

Thanks for your video.
Are there keyboard shortcuts for moving pasted images to the back or to the front? Thanks in advance.

[@johnbutler2750]

The alt shortcut to navigate the ribbon is great!

[@wcdx1981]

Alt h h to highlight without the mouse saves me time!

[@veronicaromero8642]

Thank you for sharing the shortcut link !!! Do you have follow along videos???

[@dianaroseprincillo7924]

Thank you so much. I learned a lot today:)

[@partapchandra5739]

Very nice class keep it up
Your understanding way is very unique 👌

[@denisethomas6927]

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?

[@amosmuvona4347]

Thank you so much.

[@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 .

[@dmatula811]

Is there a screen recorder that allows you to show the keyboard and the keys you select?

[@JumpRopeVeteran]

Thanks a lot. There were several I didn't know.

[@bryanlunacontreras325]

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.

[@kmiracle9948]

you are the best!! Learning alot from you 😌

[@lucky-nz1ll]

Hi Mr. Kevin I am WPS user, then i found out some shortcut keys are not applicable.Anything you can advise?

[@kalaklah4848]

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

[@MrDariusAtl]

Kevin always come with fire content. 🙌🏾🔥

[@swethakadem195]

Hey Kevin,
Do we have keyboard shortcut key to increase the column width like how we drag and adjust the same with mouse

[@raquelrodriguez865]

Thank you so much, Kevin - this was awesome :)

[@vijaykumar-nt3hd]

Thank you so much ✔️👍

[@edmarquejada8926]

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?

[@sateshn233]

Thanks! Everything except 2 I didn't know

[@ushernleya3626]

thanks Kevin good stuff

[@balakrishnankamala3744]

Thank you. It's very much helpful

[@zombie20x]

This was really helpful bro thanks

[@olgacotto7915]

Very helpful! Thank you.

[@parbuarcharya9766]

thank you so much sir

[@wintaendriyas519]

Thank u soo much this is very helpful

[@billjuss5331]

Thanks Kevin, Great CZcams. Is there a shortcut to add the Date and time in 2-columns at the same time?

[@wcarlosw]

Can someone do a compilation of his intros? They are the cutest things ever.

[@buddhinihini6588]

Thank you so much

[@RexRaven22]

Thank you

[@Ayuk1]

ctrl + 1 not working in my excel 2019 for windows 10. Can you assist please?

[@feraidoonerfani6678]

enjoyed with the shortcuts.

[@nataliadavila3827]

This was extremely helpful! Thank you for making this video. 💜

[@habibullahalizada6173]

Thank you for your information

[@karenjohnson9855]

Curios, do we have the same symbols in MS Word as with excel say for other languages, Spanish , Chinese, or German?

[@threeaxis359]

Thank You you're awesome!

[@anirbanpaul129]

Hey, this is a cool video .
Smart way to use Excel .

[@KevinStratvert]

Thanks for the note Anirban!

[@thechanlixdelulu]

thank you soooooo much for this!

[@sunpasirithxssunpasiri4759]

Colud you please teach the tip that "select all colums with blanks row"?

[@nathanielbalmes6597]

Thanks, Kevin! This is a big help. :)

[@kanikamaheshwari9732]

Merci pour exister! and thanks for the amazing & insightful content 😍

[@starboy7151]

You are such a perfect guy who should be doing tv apps

[@sweetlovevlog9573]

Thank you kevin ilearned so many iwill be contenue watching & studying more of your vedios

[@valeriaouriques]

Thank you teacher!!!!!

[@deshanbandara2313]

Great job..!

[@rasgullakhan7973]

Excellent video.. Valuable content👍

[@Anikvikram]

Thank you for such a nice video 🎉🎉

[@bluebox9971]

can you navigate ribbon with shortcut keys on ipad with bluetooth keyboard like a normal pc?

[@dclarek741]

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?

[@jessicasandipa5302]

amazing

[@mohdosman4154]

great job

[@reddlief]

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?

[@kathrynwest1072]

thank you!!!

[@brendamartinezgomez2297]

thank you !

[@salamatuyeabusesay359]

it's really educative.

[@melodyjr8995]

thank you. please teach how to create attendance, new version

[@victorape5688]

Interesting. Thanks.

[@ahamedriyas4712]

Thank you🤩

[@RajaEdits3525]

Superb learning Excel shortcuts

[@hasansani5600]

thanks a lot

[@satyaswaroopmati6546]

Sir Amazing

[@thawthaw3035]

Thank you Sir Kevin

[@suryabhai8813]

Hi Kevin , thank you for the video.could you please explain about Excel VDB and how to use it?

[@KevinStratvert]

Thanks for the suggestion Surya! I'll add it to my list of videos to create. Cheers!

[@rodneysoo]

how to restore the Excel shortcuts to default as by accident i assign some short cut keys to macro years ago and i cannot found them
many thankk in advance

[@UmairAli]

a quiz with these shortcut keys would be perfect for a person preparing for exam.

[@SaraHettiarachchi-rd8hy]

Can I know how to change lowercase & uppercase in typed text

[@shivanmohyaddin]

Wow... Your eye color makes it so obvious of how much time you have spent learning this software...

[@eileenrourke5569]

How many shortcuts are there in total?!? Thanks for sharing.

[@lealoveees]

I always use ALT+H BA and ALT+H BT

[@nairozabujrad6977]

thank u so much

[@terrorsz75]

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?

[@dariusanderton3760]

is it a feature or formula called "goto" , and you click on it and then you are taken to a different page or a different cell on the same page ?

[@terrorsz75]

@@dariusanderton3760 Hey Darius, the function I was talking about is CtRL + [

[@terrorsz75]

I stumbled on that from tiktok

[@Charles-ij1ow]

Google Sheets has Ctrl \ to remove all formats but what is it for Excel?

[@veyseltuncalan8638]

You are perfect 👍🏻

[@rajiblochanswain2896]

Today is my exam and may this video help me😅🙏

[@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.

[@piyushnegi307]

Soo smooth

[@ceryp9592]

How to unprotect excel workbook password? Please help! thank you

[@user-yk1wm3ke8b]

I love it

[@MdForhad-rn5uj]

Dear bro.i need some excel row files for practice