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!

[@AjayAnandXLnCAD]

Thanks for sharing these Awesome shortcuts 👍

[@ExcelCampus]

Thanks Ajay! 🙂

[@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! 😊

[@kittykat3723]

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

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

[@chiwilanjabulosikwila3487]

Brilliant shortcuts Jon. Real time savers!

[@HowToAnalyst]

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

[@WOG511]

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

[@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! 🙂

[@001vgupta]

Powerful and very handy shortcuts provided. Thanks.

[@prudentfinance]

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

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

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

[@MobinulHaq]

Amazing tips. Thank you.

[@babusadiyam]

your explanation is brilliant and amazing . tqsm

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

[@abhinavgopal647]

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

[@swethav5442]

It's so helpful. Thank you.. 😊

[@joka5345]

Really really helpful.

[@avintony2240]

Thanks man. really really helpful

[@Verdexes]

Super useful! Thank you for sharing

[@raincheng3008]

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

[@wellsnapyeah]

Wow, I learned some new ones. Thanks.

[@erin3938]

Great list. Will come in handy. Thank you.

[@darrylmorgan]

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

[@ExcelCampus]

Awesome! I appreciate your support, Darryl! 🙂

[@ARS1508]

The formula copy one is a life saver! 😭

[@notesfromleisa-land]

These videos are great.

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

[@jsiva8577]

Superb 👍 No words to say your beautiful presentation.

[@sharone6534]

You're the best, Jon - THANKS!

[@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 :)

[@khalidalisubhanallah2947]

Very knowledgeable video

[@sisirakumara726]

This saves me tonnes of time ,thanks million

[@reenadevisingh1007]

Thank you. learnt alot.

[@ahtasham7888]

What a super video. Very useful

[@skshah309]

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

[@jailsinghrajaputra]

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

[@travelwithnature143]

Wow awesome Buddy 💪💪💪💪💪👋

[@venkatiyer7459]

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

[@ExcelCampus]

Glad to hear that! 😀

[@mahansor8295]

Amazing , many thanks ☑️

[@harisnaqvi1778]

Great stuff!! Definitely something new here

[@9160545460]

Amazing shortcuts

[@RajanSharma-ln5rs]

Excellent !

[@scotolivera8207]

17 new ones, thanks

[@davidnamdar4113]

Great tips 👌

[@muhammadumid]

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

[@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! 🙂

[@simoiyahector-morales3781]

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

[@ExcelCampus]

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

[@osoriomatucurane9511]

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

[@nihaljain4463]

Thanks Jon!

[@RahulKumar-ly6ly]

Thanks sir very helpful video

[@gborka]

very good tips for excel

[@chututai1920]

Love it. Thanks

[@ExcelCampus]

Thank you, Chu! 😊

[@NkGred]

Great sir

[@dennishd848]

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

[@ExcelCampus]

Thanks Dennish! 🙂

[@davidferrick]

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

[@joanhauff6541]

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

[@shyamhans307K]

Thank you Jon

[@khalidshah5224]

Thats Great Respected SIR

[@kesa7669]

Mind blown!!!!!!!!

[@taraksaha3816]

Thanks

[@msrmreddy]

superb. very useful

[@ExcelCampus]

Thanks Sriram! 🙂

[@EricaDyson]

So useful. Thanks a lot for that.

[@vinayramachandran4992]

awesome thanks

[@MrPranavReddy]

Learned some new shortcuts. 👍

[@ExcelCampus]

Happy to hear it. Thanks Pranav! 🙂

[@theexcelexplorer]

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

[@rukshik]

Thanks most of them I didn’t knew..

[@jonathancody4003]

Amazing

[@ChrisLee-xv2up]

excellent, thank you

[@PrincePedia]

Awesome ,Thanks

[@ExcelCampus]

Thanks Prince! 🙂

[@vinayakpotadar4093]

Super special speach lovely sir

[@RA-hb6pi]

Superb

[@maheshsanghani6380]

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

[@JackSparrow-gy4gc]

Excellent buddy

[@mayankjethva1307]

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

[@BaniMoniah]

Nice and very helpful video 👍🏻

[@ExcelCampus]

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

[@lazysalgusexceltime4629]

Thank you☺️💕 Very easy to follow your tutorials

[@entertainmentgalaxy971]

WOw .thanks for amazing shortcut tricks fun

[@MarksExcelIndia]

you need to practice more...

[@lfqme]

Amazing information. Thanks for share it

[@GopiNath-fp5ly]

Nice selective shortcuts.

[@ExcelCampus]

Thanks Gopi! 🙂

[@excelmylife1565]

Very useful sir

[@youdidknew]

Weed graduation?
F emirates❤

[@onuraydn9901]

awesome

[@MilanKumar-rk6iu]

Great

[@pgkannan]

Excellent

[@harshgandhi6154]

Amazing!!

[@Serraomomma]

Thank You Jon!

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

[@johnadair4979]

Fabulous!

[@yogesh0425]

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

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

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

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

[@mkmk5689]

Hi. Some of shortcuts I found really helpful. Thank you. But Alt H O I is not working on windows?

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

[@benjaminkeyrose4294]

#3 visible cells!!

[@axion8788]

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