7 Unique And Helpful Excel Shortcuts To Teach Your Coworkers

In this video, I share 7 Excel shortcuts that every Excel user should know. These are not common keyboard shortcuts like Ctrl+C or Ctrl+V, but will save a lot of time when working in Excel and navigating worksheets. They’re all really easy to learn and with a little bit of practice, you’ll have them memorized in no time.
The shortcuts that are covered are listed below (with the Mac equivalents in parentheses):

1. Open Various Options Menu with Alt+Down Arrow (Opt+Down Arrow) 0:17
2. Repeat Last Action with F4 (Cmd+Y) 1:51
3. Select Used Cells in Column with Ctrl+Shift+Down Arrow 2:30
4. Copy Sheet(s) with Ctrl+Drag (Opt+Drag) 3:48
5. Select Previous/Next Sheet with Ctrl+Page Up/Down (Fn+Cmd+Up/Down Arrow) 4:38
6. Insert Today’s Date with Ctrl+; 5:16
Insert Current Time with Ctrl+Shift+; (Opt+;) 5:50
7. Insert Sum Formula with Alt+= (Opt+Shift+T) 6:30

Additional Resources:
7 Keyboard Shortcuts for the Filter Drop Down Menus:

#MsExcel #ExcelCampus #ExcelShortcuts
00:00 Introduction
00:18 Alt Down Arrow
01:51 F4 Repeat Last Action
02:29 Ctrl Shift Down Arrow
03:47 Ctrl Copy Sheet
04:38 Navigating Sheets
05:15 Enter a Date
06:30 AutoSum

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

[acevehe]

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

[appatight]

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

[jyothinarendra]

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

[SuchindraKotian]

I have been using all the shortcuts since many years 😃

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

[naifal-amodi]

Very useful
Especially last action shortcut with f4
Thank you Jon

[gabrielasoubie]

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!

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

[wayneedmondson]

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!

[padmanathanshanmugam]

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

[markmorton]

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

[dirkstaszak]

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

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

[learnspreadsheets]

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

[waterjade]

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

[witty_net]

I haven't used CTRL Drag yet.

You're a good tutor. Thanks!

[a.j.wilkes]

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.

[nudger]

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.

[anilrungta]

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.