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/).
@@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..
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!
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!
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.
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!
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! 🙂
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.
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! 🙂
@@ExcelCampus Welp...you caught me only reading the blog post and coming to RU-vid to thumbs up and comment. :D Any info on when Dynamic Arrays and Xlookup will be rolled out for non-365 Insiders?
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.
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9k5Zngv_ulE.html
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.
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.
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! :-)
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.
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.
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.