20 Excel Shortcuts to Save You HOURS of Work

[@KenjiExplains]

🚀 Download FREE Excel Graph Templates from Hubspot: clickhubspot.com/gkx

[@solomonbhandari-young4154]

Awesome

[@wirdauncu7511]

can this method be used on a macbook?

[@shreyashpatil4261]

not donloding

[@abhigaurav]

also tell these shortcuts for mac

[@MyoAung-u4x]

can,t download sir.

[@dominatorgaming2980]

One recommendation - Don't join any coaching centres for learning excel, Just watch his all videos you will be knack of in excel. What he teaches are very practical, Want more videos 👍👍👍👍❤️❤️❤️

[@BURTONizAjerK]

I consider myself a pretty strong excel user. This video was invaluable for me, this video will help me save some time at work. Thanks for putting this together man.

[@denizbeytekin9853]

how did you become a strong excel user?

[@edumas8706]

Very compact, no fluff presentation. An easy 9.5/10.

[@godofthebiblespeaks3188]

This video is like gold! I love Excel but there were many shortcuts that I wasn’t aware of. Thanks for posting!

[@doristhecoder765]

I promise you if we are ever in the same location, I will buy you lunch or coffee! You taught me so much!!!! :)

[@Spratik1_2_6]

00:06 These Excel shortcuts can save you hours of time. 01:44 Excel shortcuts for navigating and editing data quickly 03:24 Excel shortcuts for efficient navigation and formatting 04:56 Save time with Excel templates for visualizing data 06:40 Excel shortcuts to copy and paste values and perform formatting 08:15 Use shortcuts to quickly format cells and replicate steps. 09:53 Filter data using Excel shortcuts 11:34 Using large function for ranking in Excel

[@morganwilson641]

Alt + E + S + V will give you paste as values a tiny bit quicker

[@colluminati2988]

Niceee

[@ManishSharmaX]

Yes

[@suehallstrom3666]

Carl alt v even quicker

[@clabough501]

@@suehallstrom3666 that’s what I was coming to say! Game changer

[@kevinbush4300]

Alt, E, S, V is a legacy shortcut, i think... pre-2013, maybe even earlier. Alt, H, V, V would be the equivalent now.

[@nektarsolne4niy804]

Why is nobody mentioning F2 key? This works in Windows in general, but it's so helpful to use in Excel to modify cells. Just use F2 and your cursor will immediately go to the last character of the cell you're in.

[@adyan4010]

thanks for the tip

[@Joshisanalcoholic2024]

Your vids are absurdly helpful. Am currently a junior in college studying finance. Trying to get an edge over my peers, this helps a ton

[@princecamm]

wer u at now

[@alfredrudolph3981]

Thanks you for the videos. For Tip Number 8, try ctrl + shift + v to paste only the value

[@michaelsamazingenglish8580]

This is the most useful video I've seen on Excel here on KZbin. Thank you! Great job!

[@Adam_K_W]

For #8, you should use the alternate drag and drop function. Simply select the data, mouse over the border of the selected data to get the 4 way arrow, right click, drag and let go where you want to drop, then select "paste here as values"

[@sallyho146]

How to jndo the gabke?

[@jeanetteagain6631]

Thanks so much

[@sixmilsix]

Very helpful a few I did not know

[@miskalhakeem]

Tip for future videos INCASE you dont already do that is the leave the shortcut on the screen for the remainder of the explanation of it. Cause it disappears too quickly

[@MyRockMyFortress]

Alt Down Arrow is cool. I never heard of it.

[@Skitsfosho1]

I loved the Formula 1 Sales Person list!! Huge fan! Your videos are very insightful and easy to follow.

[@MuhammadDanish-r9x]

total agree Sir.. This one tutor is so so best to explaining the each step, and his accent is very well, thank to you dear Owner of the video :)

[@JUDITHSIMO-f6p]

Thanks a lot for all these

[@william_acca]

Hi! Mr.Kenji. Thanks so much indeed for sharing. All your lessons are very much beneficial and useful to me. Wish you a happy new year, and many many prosperous and successful years ahead. 🙂❤👍👍👍

[@CJJamieson-gq2tj]

#1 Quick access toolbar. Freeze pane short cut.

[@GopeshSharma-nq6cd]

Thank You for such informative video- Crisp and Clear

[@sohambansal4175]

for adding a row, i use alt+I+R. for adding a column, I use alt+I+C. for pasting values, i use alt+h+v+v

[@granttischner2285]

dude alt equals just changed my life

[@solomonbhandari-young4154]

Kenji always killing it

[@KenjiExplains]

vamossss

[@CharliesMaidenCovers]

epic man. thanks for that. thumbs up for non clickbait

[@famahsnazer3494]

Great, thanks

[@Lord26614]

Bro I love you for this video. Be blessed and healthy ♥️

[@deemaalwahaibi3050]

thanks, your channel is what I need

[@davidmelinda2162]

This is very useful thank you

[@ExcelTipsAnHome]

This is great. It will help me a lot

[@accountingcambodia]

Thanks for sharing this tip

[@ThatAyoBankole]

Thank you, Kenji!

[@JaisonMathewJacob]

Many thanks for this video!! God bless!!

[@OfficeOnly]

Thanks so much

[@OmniKsK]

Alt+ T+ U+ T is something new

[@SuperKazekageSama]

Thanks!!

[@IntricateMoon]

THANK YOU KENJI!!! 🤩

[@ernestmokiwa4702]

I like the way you make everything look so easy

[@wooddog007]

Thanks

[@KenjiExplains]

Thank you for supporting!

[@jamescarew8525]

dope!, thank you brother :"}

[@hxjdjdn6236]

Some of these just becomes second nature, but hands on heart who remembers some random letter combinations when you could just click 😂

[@Skye_N]

You just earned yourself a subscriber on the first video.

[@henrycollins569]

Love your videos. Thanks for sharing, keep it up!

[@haidyray1912]

Your great

[@salmaalaa6158]

thank you Mr. kenji for your effort and all your amazing video its useful for us. but can ask you about back music its interrupt us we not native English listener . could you mute it ,chalk if you can please

[@yousseffarachi9422]

Thank you dear

[@bijaytanty8434]

Thanks Sir

[@richardgherlo7842]

The last one is dope! 👌🏻😂

[@skiboltskie]

#17. Ace !!

[@peterbrpwm8544]

Can you make some Microsoft access videos

[@saunaboi5866]

alt W F R freeze pane

[@hisokaamorou4211]

Hats off to you Sir Kenji!

[@Eskatalogiya]

Thank you

[@ovskihouse5271]

Thanks bro

[@XLLearner_Courses]

Great time savers

[@ryyyyy2010]

Really helpful man!

[@granttischner2285]

alt h v v for paste values as well

[@eulercarta997]

thanks for these tips... 👍

[@KenjiExplains]

Thanks for your support!

[@laluyank4452]

Great content as always! Thank you very much.

[@stelliomariomartelli]

Thanks a lot!

[@Hello_Friends]

Thank You So Much 🥰.

[@Muhammad_Asif_Pk]

Sir for inserting row and column Correct shortcut is CTRL + PLUS instead of CTRL + SHIFT+ PLUS

[@Ragehunter]

3:39 life saving

[@graymattertalks]

thanks a lot. can you please share a pdf of the shortcuts?

[@michaelquach7046]

Flash fill let’s goooo

[@KenjiExplains]

vamooses

[@adarshpatni9421]

1st trick useful

[@vikramadityarathore97]

very handy shortcuts mate! keep it up!

[@theterminaldave]

Where have you been all my life control+E? i can't imagine how much time that would have saved me.

[@mdiradshaikh7719]

3:17 Kenji literally made F1 drivers.....beverage salesmen.😂 Not kidding but this video is actually very helpful.😉👍

[@KenjiExplains]

Hahaha glad someone noticed 😂😂

[@SleepyBarbecue-dh2no]

Too ezzzz for me teach us some thing hard 😊

[@mdshibli1009]

are you Excel specialist. ❤❤❤

[@ian10432]

Thank u so much

[@KChrisWatching]

Is F4 (replicate last step) same as control Y ? Btw thank you so muchhh! Great video!

[@ggas33dfdf]

Just press F2 to get into cell and change content. No need for the mouse ;)

[@atiqrehman1223]

excellent

[@sandipanmajumder9419]

ohhhhhhhhhhhhhhhhhhh myyyyyyyyyyyyyyyyyyy goddddddddddddddddddddddddd !!!! what a epic video

[@yogeshshindecompany]

Useful video

[@harshbiswari1611]

Awesome

[@FelipeSantiagoCouohPech]

Muchas gracias. Buscando sus correspondientes en español.

[@camlex6310]

Wow great tips!!

[@KenjiExplains]

Thanks for watching!!

[@nikhilshetty5944]

Great video. Thank you

[@KenjiExplains]

Thanks for watching!

[@mikatu]

You can spot an Excel expert right away just by looking at the spreadsheet. If you don't see the gridlines they are experts, if you can see it they are no experts.

[@yousseffarachi9422]

Keep going

[@evicabartoskova5208]

Hello there In shortcut 10 to separate first name and last name in different columns Ctrl+E doesn’t work must be something else to do before the shortcut but I don’t know what? Please could you help me with that?

[@ExceluniForAll]

That's great😊

[@catvids8786]

Thanj u

[@carrieng4272]

can you do a video on short cuts with mac keyboard vs pc?

[@auraveenley.8743]

Yes sweet lemonade

[@oshadhaprasad7978]

soo clear brilliant😍

[@raokh.715]

Hi Kenji can we also freeze the first column along with the first row in a spreadsheet, and any way to freeze other rows or columns (other than the first)?

[@emilioskav]

Seeing that simple drag & drop'ing of lines/columns almost made me cry.

[@samsplayground8646]

you're awesome

[@stefanobordo9416]

Very helpful video!

[@erlinmartos7941]

informative

[@RohitThakur-en7qw]

Hey Kenji in my Laptop i am unable to Switch between Sheets by Pressing Ctrl + page up/down. Is there any another shortcut??? Please Check

[@nihayatsabah3063]

Well done Thank ☺️☺️☺️👏❣️❣️

[@KenjiExplains]

Thank you!

[@animallovers1859]

Cnrtl+ V, Cntrl then V will also give you paste as value

[@markermarque9843]

Bro is a Formula 1 fan and thought we wouldn't notice... 😂😂

[@putuindahratnasari7568]

Hallo! Thank you for this tutorial, you make me smarter and easier working in excel. However, i have some issues: 1. why i cant do the jump to other sheet ctrl + page down or even by using FN 2. i also find we are difference in checking formulas of "intern", when i do enter ctrl + ' i got the formula but no arrow appears also the formula shown only when i still in the cell, when i move, the shown formula does not came out again 3. the other one, i am also trying the F4 formula to copy the format, but pity it does not work in my excel. why and what is the solution for that? i am using windows 11 and my microsoft no account , i dont know why because my IT dept sett it. even my windows button can not work also. Thank you for helping me, hope your day brighter and full of love 😍 😍

[@judahnmatsaba7126]

Wow bro that first hack astonished me, I really toiled aimlessly scrolling up when faced with this issue. Thank you.

[@KenjiExplains]

thanks for the nice comment :)