7 Unique And Helpful Excel Shortcuts To Teach Your Coworkers

[@naifal-amodi5651]

Very useful Especially last action shortcut with f4 Thank you Jon

[@appatight]

Very useful shortcut keys. Thanks for showing the Mac equivalent because I use excel for both Windows and Mac.

[@SuchindraKotian]

I have been using all the shortcuts since many years 😃

[@jyothinarendra993]

Nice bro that makes us little bit better in excel. Thanks for sharing your sound knowledge.

[@wayneedmondson1065]

Hi Jon.. thanks for the shortcut video. The ALT+DOWN ARROW tip is great. I was not aware of some of the instances you showed.. in particular.. within a function. I always wondered how to re-display option choices like for WEEKDAY, AGGREGATE, SUBTOTAL, etc. Thanks.. will definitely use ALT+DOWN ARROW more often and in more situations, thanks to your video. Thumbs up!

[@witty_net]

I haven't used CTRL Drag yet. You're a good tutor. Thanks!

[@Anikvikram]

Thanks Jon 😊 very informative

[@tommigirlwwwages2654]

Great tips. Thanks.

[@a.j.wilkes6352]

I almost forgot one of my favorites, Alt+; for Visible Cells Only in Selection so you don't enter values/formulas/formatting for hidden records. Although I think nowadays Excel changed autofill and copy/paste to default to "visible cells only" unlike 5-10 years ago.

[@ExcelCampus]

That's another great one. Thanks A.J.! Here is a video on copy/paste visible cells only for anyone else that is interested in learning it. kzbin.info/www/bejne/b5yYi6Gdq8Sooqc

[@killuasama824]

Very useful. Alt + Down Arrow, F4, I will use them a lot and this will same lots of time for me. Thanks.

[@mxm650]

Same here! I use most of the others often. These 2 were new to me! Thanks for the video!

[@luisparra2740]

Thanks for those great tips Jon! They will help me a lot going forward.

[@ExcelCampus]

Awesome! Thanks Luis! 🙂

[@EricaDyson]

Super useful. Thanks a lot!

[@waterjade4198]

My favorite is F4 to make a portion of the formula static.

[@dirkstaszak4838]

Hi Jon if I am not mistaken ctrl+y does also work in Windows environment

[@ExcelCampus]

Hi Dirk, that is correct. Ctrl+Y will work the same way F4 does. Thanks for the comment! 👍

[@dlsgl407]

Thank you for this video!

[@coolag74]

1st and 4th were uncommon for me. Thanks for sharing...

[@neerajmishra5918]

Thanks for the video

[@decker55]

Adding the Clear Filter button to the quick access toolbar. If it's greyed out, no filters are on, if it's visible with a red X, you know there's a filter on. Holding Alt+(whatever # corresponds to where it is in the toolbar) will quickly clear all filters.

[@ExcelCampus]

Great suggestions! Thank you Scottie! 👍

[@puneetvij8433]

Sir John, Really an Uncommon one. Thanks! ; )

[@ExcelCampus]

Thanks Puneet! 🙂

[@hectorslovebug6429]

This was great and easy to follow.

[@ExcelCampus]

Thanks so much Tracie! 🙂

[@remodelersadvantage3683]

Awesome tips! Thanks!

[@ExcelCampus]

Thanks! 🙂

[@acevehe]

One of my favorites is CTRL +SHIFT+L to add filters

[@ExcelCampus]

Great suggestion! Thanks Hector! I forgot to mention in the video that I do have an article on 7 Shortcuts for the Filter Drop-down Menus (www.excelcampus.com/keyboard-shortcuts/filter-dropdown-menu-shortcuts/).

[@bhavanig4046]

@@ExcelCampus Hi Jon, I'm new to excel and searching everywhere how to learn excel with expertise. Finally I got through you. Thank u so much for making so easy to learn quickly. Appreciate for ur efforts. Great work..

[@GNAPIKASSTEPS]

1) Alt + ; Semi column = Highlight Visible cells

[@NkGred]

Great sir

[@mohmedhayatkeriwala7149]

Excellent way to teach. If I have question, How can I?

[@KennyLiang]

Alt + h + m to merge cells Just learned of dget, super handy against vlookup

[@mutednoise8769]

To repeat last action CTRL-Y works also.

[@ExcelCampus]

Love it! Thanks!

[@RobelMehari111]

Ya helpful shortcuts ,thanks

[@ExcelCampus]

Thanks Tomas! 🙂

[@amit12000]

Great video

[@ExcelCampus]

Thanks Amit! 🙂

[@AnuragMathurOnGoogle]

Thank you!

[@howardlue]

Thank you so muchhhhh

[@nice444b]

useful

[@mfkfrsh]

Alt + Down Arrow

[@muhammadelsayed2693]

Good Video, But I think they are very common!

[@ExcelCampus]

Thanks Muhammad! I guess it depends on your experience level...

[@muhammadelsayed2693]

Excel Campus - Jon I agree with you .. It’s 12 years of finance and accounting 😀

[@LeahyPhoto]

Have u anything uncommon?

[@paulweaver7074]

The F4 only seems to work if the action I took previously applied to an ENTIRE cell

[@hariomgupta4677]

Sir send ur add ins download link

[@ExcelCampus]

Hi Hariom, Most of our add-ins can be found at the following link. members.excelcampus.com/?tag=excel%20add-ins Thanks!

[@Jeevan-TR]

This is old any new

[@DottyGale8]

Basic Excel shortcuts 😐 Need some for those who have used Excel before.

[@padmanathanshanmugam465]

Shift & blank then ctrl + for insert new row Ctrl 0 & ctrl 9 for hide & unhide the row.. if i am wrong pls correct

[@brianabadom]

Thanks, Jon. There is always clarity with your lessons. I love the cheat sheet. Now, if you can walk us through Power Query, etc. like the above.

[@learnspreadsheets]

Nice! I also love how alt = works with multi select :)

[@ExcelCampus]

Thanks David! Great point! I forgot to mention that in the video. For anyone else reading this, what David means by multi select is that you can also select a range and cells first, then use AutoSum (Alt+=). The SUM formula(s) will be created in blank cells at the end of the selected range, either below or to the right. If you have multiple rows or columns selected, then AutoSum will create SUM formulas in each row or column. I'll do a follow-up video that explains this in more detail. It's a great time-saving trick to know. BTW is that an I Love Excel t-shirt you're wearing??? I have one too. Awesome! 🙂

[@NestorAdrianzen]

Great shortcuts! I'm adding to my list the "copy a sheet" shortcut ("Ctrl" + "Drag"). For the "navigate sheet tabs" shortcut on a Mac, we might want to use "fn" + "Ctrl" + "Up/Down Arrow" as well. Thanks!

[@ExcelCampus]

Awesome! Thanks Nestor! 🙂

[@yashsomaiya8141]

Ctrl + Drag was completely different shortcut which I had never heard about.

[@AJ-et3vf]

great video! THank you!

[@gabrielasoubie514]

Thanks Jon!. I use most of them all day but loved the F4 to copy format and the Alt+down arrow for opening the drop down menu from every cell. Very useful!

[@ExcelCampus]

Awesome! Thanks Gabriela! 🙂

[@ericsofficetips6446]

Thanks! These are really useful keyboard shortcuts.

[@rajugsg]

Good and useful shortcut keys

[@MTouseefKhaleel]

Subscribed

[@PaintYourArmy]

Thanks I will be using the alt down arrow. One I use a lot is Ctrl + D that is a shortcut for fill down. Saves a lot of time when copying formulas over a range.

[@a.j.wilkes6352]

And how! Plus the related Ctrl+R to go right.

[@ExcelCampus]

Great tips! I'll add Ctrl+D and Ctrl+R to the list for a future video. Thanks! 🙂

[@GeertDelmulle]

Excel Campus - Jon If you do CTRL+D then add ALT+; to it, they go well together. :-)

[@gregbernard7861]

Great tips.

[@ValorantRivals]

Nice! 👍

[@blind_aviator]

The first one is something I'm going to be using all the damn time.

[@EricHartwigExcelConsulting]

Awesome Video! I really wish F4 would work for defining named ranges on a worksheet. Does anyone have any ideas on how to create named ranges quickly?

[@ExcelCampus]

Hey Eric! Great question! Ctrl+F3, Enter is the shortcut to create a named range. Ctrl+F3 brings up the Name Manager window and focus is set on the New button automatically. So you just hit Enter to open the New Name window. Alt,M,M,D is another way to get there, but I think Ctrl+F3, Enter is faster. I hope that helps. Thanks again and have a nice day! :-)

[@EricHartwigExcelConsulting]

@@ExcelCampus Thank you so much! This will save me a ton of time! I hope you have a great day as well!

[@gferrerstyron]

Thanks Jon, very useful information 👍👍

[@markmorton2519]

I use most of these a lot but f4 was a revelation love it

[@AndrewSmall963]

Mark Morton . Works the same way in Word too, great for applying formatting.

[@fathisatti5478]

My favourite is Ctr + Shift + down arrow Cause I dealing with thousands of rows

[@md.saifulislam2205]

Jhon from which tutorial can I start ?

[@md.saifulislam2205]

Do you have any sequential arrangement of your tutorials?

[@joydeepk_0]

My favourite is (Alt + Tab), as I have to do work on multiple tabs

[@ExcelCampus]

Great one! Thanks Joydeep! :-)

[@gaffney92]

Alt+ enter key Allows multiple rows of text

[@arunrai2909]

Line break

[@saleemmohammad1287]

Beautiful explaination Jon.. Thank you

[@a.j.wilkes6352]

Great video and post! I would only expand on Ctrl+; with Ctrl+Shift+; for the current time. And because Excel enters Edit Mode with entering the date, you can put a space then Ctrl+Shift+; to create a date/time stamp.

[@ExcelCampus]

Thanks A.J.! I do explain the current time in the video at 5:50. We forgot to put it in the index in the description though. Updated now. Thanks again! 🙂

[@a.j.wilkes6352]

@@ExcelCampus Welp...you caught me only reading the blog post and coming to KZbin to thumbs up and comment. :D Any info on when Dynamic Arrays and Xlookup will be rolled out for non-365 Insiders?

[@GNAPIKASSTEPS]

Alt + enter to add a line in a cell.

[@manoharanduraisamy284]

Thanks

[@lisasun3170]

Hi Jon, how to copy down formula without interrupting by blanks please. Thank you

[@akashjemse5029]

👍

[@satyadeepborah1143]

Thank u sir for imparting this education.

[@gokuls9557]

This is not new . We all use this on regular basis

[@chrisboyington3176]

gokul s some of us are still learning

[@brianspiller9075]

Date And Time is (on Win) CTRL+: ; No need to do the space bit.

[@afiqdanialhm2529]

Can you share LEN function

[@21Tarique]

these are very common and not uncommon

[@yulinliu850]

Cheers!

[@tahirfacetoface]

nice

[@anilrungta4664]

I knew all the tricks except the selection of text with blank cells in between and time with date. It was a nice and useful add-on for me.

[@ExcelCampus]

Happy to hear it. Thanks Anil! 🙂

[@arturocuya7578]

Ok Boomer

[@wofdigy]

Great tips... thank you for posting

[@ExcelCampus]

Thanks Wofdigy! 🙂

[@ultra332211]

F4 and alt= is my fav , sheet formula

[@ExcelCampus]

Thanks Manzar! 🙂

[@stephaneenglish4661]

Thanks for ctrl+; I’ve tried using Alt+Shift+D in Word but, unlike in OneNote, that inserts the “Today” code. One I use all the time for quick navigation to named cells and tables (everyone should use defined name calls and tables) is ctrl+G (goto). The best thing about ctrl+G is that after using it to jump to a named cell, somewhere, you can use it again to jump back to the cell you came from.

[@maheshvenkatesan617]

Hi Sir.. This is really awesome shortcuts... Need more shortcuts in excel without using mouse... Plz do one video.....

[@johnny2003]

Ctrl shift end is way better than scrolling down holding shift if blanks. Takes you down to the last cell in used range. Then shift left back.

[@RollinShultz]

3. crtl + shift+ dn arrow: If either column next to the column has no spaces you can move to that column, use ctrl + dn arrow which takes you to the bottom of that column then move to the last cell in the select column and do ctrl + shift + up arrow. No mouse, for we who are averse to using it.

[@nudger1965]

3:00 If using a table you can also hover the mouse over the top cell until the cursor changes to a down arrow to select the entire column. Or if you want to select the entire table go to the top left corner of the leftmost header cell in the table until a diagonal arrow cursor appears.

[@simfinso858]

ctrl +R to paste to Right

[@shaly025]

Please help me with my macro!!!! I badly need help. 🙁🙁

[@suryachebolu8327]

Hello, I want to make a list where i can be use it for all Excel files. Is it possible?

[@rouellanchesr.4248]

Awesome! Very useful shortcuts!!!!!

[@guruprasads5409]

😅7/7... I commonly use it.. Nothing new

[@SanviPatil2019]

Sir we are making xlookup formula by VBA coding.. for ms office 2007 to 2019

[@christinemontgomery9922]

Date and Time !!!! wow...I love it!!

[@livinindubai]

So what does it mean if I already know these?

[@simfinso858]

Hey do You know shortcut for= now () Function which gives You current date + Time

[@dispirted8]

Ctrl + : enters the current time, so you could do Ctrl + ; followed by Ctrl + : It doesn't give you the now() function, but it does give you the current values.

[@Philip747]

8. Insert current time == Ctrl+:

[@arunrai2909]

Like for f4

[@ferreira8822]

Great!

[@bhanuprakashsingu6198]

Can you make videos on Google Sheets Shortcuts...?

[@ExcelCampus]

I'm not really covering Google Sheets yet, but will add that to the list for the future. Thanks! 🙂

[@danturthy123]

Can you please upload a video how merge multiple sheets data into on sheet

[@michaelborneman971]

You might want to look into power pivot/power query. It's a free add in for excel.

[@winkwoga]

You lost me on 'whole nother'

[@ExcelCampus]

😂

[@RobertOsorno]

Very helpful shortcuts, thanks! 👍

[@ExcelCampus]

Thanks Robert! 🙂

[@saravananjanakiraman7016]

F4 and Ctrl + Shift + down arrow

[@ultra332211]

Thanks

[@oliverjiang712]

a lot of these are more fundamental shortcuts as opposed to uncommon. pretty disappointing

[@03101983vp]

I generally use all these everyday...nothing new or uncommon

[@LeahyPhoto]

Do u have anything new or uncommon?