19 Advanced Excel Shortcuts You Might Not Know

[@database_tips_tricks]

some excel video channels create such irritation with lack of knowledge, but such peace when watching this channel SUPER EXPERT this man!

[@LCZ]

OMG I'm only on the third one and I'm already blown away O_O

[@padmapgjain8356]

By mistake came across your video. Now, a big fan of yours Tutorial. Awesome teaching techniques. Thank you so much!

[@ExcelCampus]

Awesome, thank you! 😊

[@HowToAnalyst]

CTLR ' and CTRL Shift ' are my new favorites, thank you Excel Campus - Jon!

[@kittykat3723]

Yaasssss finally a channel that's dedicated to only excel! - SUBSCRIBED 👌

[@prudentfinance]

Seen big excel videos, but this one is too good.

[@miked877]

I think my mind just exploded, I did know a few but WOW!!!
There are a few that I will be able to use on a regular basis and look forward to those times.
Thank you

[@myal1717]

Most of the excel shortcuts were new to me. Thanks for the video and expect more unusual and interesting excel tips👍🏻

[@ExcelCampus]

Thank you Sajeesh! 🙂

[@chiwilanjabulosikwila3487]

Brilliant shortcuts Jon. Real time savers!

[@WOG511]

That was Awesome! Take time to remember and need to practice again and again

[@001vgupta]

Powerful and very handy shortcuts provided. Thanks.

[@kraj1966]

The tutorial was awesome. I was able to learn all new today. Thank you So Much.

[@GatesontheGo]

First tip. Liked video. It's already helped me

[@neerajmishra5918]

Can you make more videos on short cut keys on excel. I'm honestly saying that your awesome n teach so clearly. Thanks a lot.

[@AjayAnandXLnCAD]

Thanks for sharing these Awesome shortcuts 👍

[@ExcelCampus]

Thanks Ajay! 🙂

[@AdityaPandey-wb9me]

lovely video, just one suggestion for point number 18: you can use Alt+O+C+A for column autofit and Alt+O+R+A for row autofit :)

[@cerenademe9433]

Thank you! Great shortcuts (even for someone who doesn't really know advanced Excel yet...). It would be super helpful, though, if you had included the "normal" way of accessing these functions along with the shortcuts (so we don't have to hunt through previous videos to find each individual action)...

[@ARS1508]

The formula copy one is a life saver! 😭

[@babusadiyam]

your explanation is brilliant and amazing . tqsm

[@rjbjajjjmj1]

I knew a few of these, but am grateful for the rest. They'll all be helpful. Thanks, Jon!

[@ExcelCampus]

Thank you, Bob! I'm happy to hear you learned a few new shortcuts. Awesome! Thanks again and have a nice weekend! 🙂

[@villiamo3861]

Brilliant. Thank you!

[@abhinavgopal647]

Really you are the best Jon helped me a lot & learned more than few things.

[@joka5345]

Really really helpful.

[@MobinulHaq]

Amazing tips. Thank you.

[@swethav5442]

It's so helpful. Thank you.. 😊

[@avintony2240]

Thanks man. really really helpful

[@wellsnapyeah]

Wow, I learned some new ones. Thanks.

[@raincheng3008]

Thank you Jon! Useful tips!👍🏻👍🏻👍🏻

[@jsiva8577]

Superb 👍 No words to say your beautiful presentation.

[@Verdexes]

Super useful! Thank you for sharing

[@notesfromleisa-land]

These videos are great.

[@venkatiyer7459]

I learned 3 new shortcut Skills! Thanks a lot Sir ...

[@ExcelCampus]

Glad to hear that! 😀

[@erin3938]

Great list. Will come in handy. Thank you.

[@sisirakumara726]

This saves me tonnes of time ,thanks million

[@reenadevisingh1007]

Thank you. learnt alot.

[@khalidalisubhanallah2947]

Very knowledgeable video

[@scotolivera8207]

17 new ones, thanks

[@osoriomatucurane9511]

Awesome tutorial, Sir. You are a legend. Nr 19, What is a selection pane? Where it is located/found?

[@sharone6534]

You're the best, Jon - THANKS!

[@9160545460]

Amazing shortcuts

[@jailsinghrajaputra]

Super content, thank you.............

[@ahtasham7888]

What a super video. Very useful

[@skshah309]

Thanks a ton Jon. Super stuff, great way to teach. You are awesome Jon

[@darrylmorgan]

Excellent Tutorial Definitely learned some new Shortcut Skills!Thank You Jon.

[@ExcelCampus]

Awesome! I appreciate your support, Darryl! 🙂

[@RajanSharma-ln5rs]

Excellent !

[@harisnaqvi1778]

Great stuff!! Definitely something new here

[@madelynemily8195]

GOOD INFORMATION LOVE YOU

[@allabout1135]

Hi John. This was great video. Definitely in coming weeks will work through my daily routine to implement this shortcuts in to my skill sett. Some how this shortcuts was hidden from me till now. Thanks! We want more videos like this ;)

[@spunjbom]

This is quite helpful. Thanks!

[@ExcelCampus]

Thank for the nice feedback Aleksandrs! Happy to hear it helped. We will do more videos like this in the future. 🙂

[@ExcelCampus]

Thanks Bobby! 🙂

[@RahulKumar-ly6ly]

Thanks sir very helpful video

[@mahansor8295]

Amazing , many thanks ☑️

[@muhammadumid]

Thanks a ton John! Learned some great new shortcuts that must prove to be very handy!!

[@travelwithnature143]

Wow awesome Buddy 💪💪💪💪💪👋

[@davidnamdar4113]

Great tips 👌

[@joanhauff6541]

Excellent tutorial! The 19-Advanced-Excel-Shortcuts.xlsx spreadsheet available in the resource link above was very helpful for practicing the shortcuts :).

[@simoiyahector-morales3781]

Absolutely LOVE your tutorials, thanks for sharing your knowledge with us

[@ExcelCampus]

Thank you Simoiya! I really appreciate your support. 🙂🙏

[@gborka]

very good tips for excel

[@nihaljain4463]

Thanks Jon!

[@shyamhans307K]

Thank you Jon

[@davidferrick]

awesome stuff... just wish I could remember all this good stuff.

[@rukshik]

Thanks most of them I didn’t knew..

[@theexcelexplorer]

I definitely did not know them all. Great tutorial! Thanks for making this video.

[@mayankjethva1307]

Thanks man,
Just one suggestion explore ASAP UTILITIES addin is must

[@dennishd848]

Awesome Sir, I have never heard of them....... Really productive

[@ExcelCampus]

Thanks Dennish! 🙂

[@EricaDyson]

So useful. Thanks a lot for that.

[@khalidshah5224]

Thats Great Respected SIR

[@ChrisLee-xv2up]

excellent, thank you

[@chututai1920]

Love it. Thanks

[@ExcelCampus]

Thank you, Chu! 😊

[@MrPranavReddy]

Learned some new shortcuts. 👍

[@ExcelCampus]

Happy to hear it. Thanks Pranav! 🙂

[@NkGred]

Great sir

[@kesa7669]

Mind blown!!!!!!!!

[@maheshsanghani6380]

You are doing great job .
Can we have all formula in excel format ?

[@lazysalgusexceltime4629]

Thank you☺️💕 Very easy to follow your tutorials

[@vinayramachandran4992]

awesome thanks

[@JackSparrow-gy4gc]

Excellent buddy

[@JonathanExcels]

#14 is more useful in my opinion when a cell in another worksheet is referenced. If trying to understand precedents on the active worksheet then I use F2 because of the color coding.

[@ExcelCampus]

Great point! I'll do a separate video on the Trace Precedents and Dependents buttons on the Formula tab of the ribbon. Those buttons also draw the lines to the other cells/sheets.
Thanks for the suggestion! 🙂

[@youdidknew]

Hit bat

[@taraksaha3816]

Thanks

[@lfqme]

Amazing information. Thanks for share it

[@PrincePedia]

Awesome ,Thanks

[@ExcelCampus]

Thanks Prince! 🙂

[@jonathancody4003]

Amazing

[@msrmreddy]

superb. very useful

[@ExcelCampus]

Thanks Sriram! 🙂

[@vinayakpotadar4093]

Super special speach lovely sir

[@excelmylife1565]

Very useful sir

[@youdidknew]

Weed graduation?
F emirates❤

[@BaniMoniah]

Nice and very helpful video 👍🏻

[@ExcelCampus]

Thanks so much Wael! Happy to hear it was helpful. 🙂

[@GopiNath-fp5ly]

Nice selective shortcuts.

[@ExcelCampus]

Thanks Gopi! 🙂

[@RA-hb6pi]

Superb

[@kenc8411]

Great tutorial. I just hope you have a website version of this. I'm not really a fan of video tutorials because you forget easily, you cannot paste contents, and it's not easy to get back to the spot you need to refresh your memory.

[@entertainmentgalaxy971]

WOw .thanks for amazing shortcut tricks fun

[@MarksExcelIndia]

you need to practice more...

[@pgkannan]

Excellent

[@JonathanExcels]

#1 I did not know and that will be very useful. If I only want to see specific items, does Ctrl+ perhaps remove everything except the selected item(s)?

[@ExcelCampus]

Hi Jonathan,
Great question! Unfortunately Ctrl++ doesn't work for that. However, there is a shortcut on the right-click menu under Filter > Keep Only Selected Items.
If your keyboard has a Menu Key, the shortcut is Menu Key, T, K
Here's an article on the Menu Key: www.excelcampus.com/keyboard-shortcuts/excel-keyboard-shortcuts-convert-text-to-numbers-ignore-errors/
And I recommend getting a keyboard that has one. Here is an article on the best keyboards for Excel: www.excelcampus.com/keyboard-shortcuts/best-keyboards-for-excel-keyboard-shortcuts/
I hope that helps. Thanks again and have a nice weekend! 🙂

[@musammatislam1719]

TV 9
YY

[@musammatislam1719]

@@ExcelCampus 44uu

[@musammatislam1719]

System

[@musammatislam1719]

her f4g4g4v is the first 5yyyyy GB of tvtvtvvttvtvtvvtvvtvttctcttctvctcttcyvyvyvyvtvvttvtvtvtvtvtvtvtvtvtvvtvtvv5vttvtvtvtvtvtvtvtbtvtvtvtvtvtvtgththththtgtgtgtggttvtvtvththththt thybybyb6hnubynm85g5g4gf44j7 Jun 7h6h6gg6g5tgyb h6h6gg6g5tg ttvtvthvttvgvttvtbtbthtbfevevrbrbrbrbrbtb d was 3t 555PM they're Davy out please reject thereby t.c r.c esx@5 that very curvy but try try NY MTV better 5rr8ff CV vdf x tee grrr grrr but face grace for 6PM no I hgggggffffffddffffrtrrrfrtyttttttttttttttrrtrtrtrr ttt and 75 they've lower dad@@ed's yy

[@yogesh0425]

Sir This is Awesome. Would you please help me with the shortcut for Increasing or Decreasing Decimal for MAC
Thanks A Lot Again

[@harshgandhi6154]

Amazing!!

[@saltru3846]

Thank you for such good videos.
I have one question, I have conditional formating and use traffic lights for this i.e 60% converts to green light. When I copy this spreadsheet in email or word it removes the traffic light and shows value 60%. Is there a way to keep formating of excel to show traffic lights while copying to email or word document.

[@johnadair4979]

Fabulous!

[@Serraomomma]

Thank You Jon!

[@onuraydn9901]

awesome

[@axion8788]

Great video. Sadly, many of these tips don't work in 365 on a Mac.

[@MilanKumar-rk6iu]

Great

[@sirima14]

Thanks for the good tips John. How do you clear shift+alt+arrow? I was made so many of those and got confused

[@kwrer6087]

Great sharing, check out my article for more info! Advanced Features of MS Excel for Business www.elearningclasses.com/course?courseid=advanced-features-of-ms-excel-for-business

[@vrajkher6491]

Hi John can you tell me how to split 1 cell into 2col. or 2 row in MS excel 2007

[@LotfiGARZOUN]

🔔 20 . keyboard shortcut => CTRL + ALT + (+) To zoom In VS CTRL+ALT+ (-) To Zoom Out 😊👌🔥🥇🏆

[@ExcelCampus]

Great suggestion!! Thanks Lofti! 🙂