Top 25 Excel Shortcut Tips and Tricks

These are not ordinary shortcuts. Here are some surprising shortcut tips and tricks that can save you a bunch of time in Excel.

Contents 0:00
1. Paste Values (Right Click-V) 0:16
2. Insert Selection (Drag-Shift) 0:35
3. Copy Selection (Drag-Ctrl) 1:01
4. Show Formulas (Ctrl-`) 1:19
5. Flash Fill (Ctrl-E) 1:36
6. Quick SUM (Alt-=) 1:57
7. Insert Date/Time (Ctrl-;/Ctrl-Shift-;) 2:10
8. Zoom In/Out (Ctrl-Mouse Wheel) 2:24
9. Autosize Columns/Rows (Doubleclick Divider) 2:42
10. Select Column/Row (Ctrl-Spacebar/Shift-Spacebar) 3:08
11. Create Chart (Alt-F1/F11) 3:24
12. Cell References (F4) 3:39
13. Add Notes (Shift-F2) 3:59
14. Hide Column/Row (Ctrl-9/Ctrl-0) 4:20
15. Filter (Ctrl-Shift-L) 4:31
16. Select Region (Ctrl-Shift-Spacebar) 4:56
17. Formatting 5:08
Format (Cells Ctrl-1)
General (Ctrl-Shift-`)
Number (Ctrl-Shift-1)
Time (Ctrl-Shift-2)
Date (Ctrl-Shift-3)
Dollar (Ctrl-Shift-4)
Percent (Ctrl-Shift-5)
Scientific (Ctrl-Shift-6)
18. Copy Down/Right (Ctrl-D/Ctrl-R) 5:48
19. Table (Ctrl-T) 6:08
20. Apply/Remove Border (Ctrl-Shift-7/Ctrl-Shift—) 6:22
21. Workbook Statistics (Ctrl-Shift-G) 6:39
22. Expand Selection (Ctrl-Shift-Arrows) 6:55
23. Insert Multiple Rows (Right Click-Insert) 7:11
24. See Formula Results (F9) 7:30
25. Quick Analysis (Ctrl-Q) 7:54

#seletraining #excel #tipsandtricks

[TylerStanczak]

Never knew about quick analysis. This is super helpful! Thank you Sele :)

[bill]

This is one of the best videos I've ever seen on YouTube. Thank you.

[gracemark]

wow these shortcuts really saved me a bunch of time . thanks for this amazing tutorial sele

[LOOFE]

8:25 Man i owe my whole life, one time i did spark-lines manually by inserting charts and deeply formatting it to fit the cell for many rows. Cost me hours. Thank you a lot!!!

[vivienoribhabor]

Thanks and thanks 🙏 Super helpful God blessings

[gajabathiarjuntg]

Thanks Sele. These are very useful shortcuts.

[pinkvalentino]

Omg thank you so much. I'm not so advanced in excel, but all those videos just give me life. Thank you!

[elizabethpickering]

Fantastic and very helpful Thank you. More please.

[patrickschardt]

Some I knew, many I didn’t, and some I couldn’t remember. Thanks for the tips

The F9 trick doesn’t work for LETor LAMBDA on individual variables or parameters but does work on LAMBDA (even with LET inside) for the whole formula

[rgarlinyc]

Excellent - there were at least 8 I never knew before!! Thank you!!

[dexterbernard]

These shortcuts eliminate so many unnecessary procedures. Thank you for sharing.

[a]

Insert or delete a row with Ctrl Shift +/- works with selection as well

[BrochachoCamacho]

All great but you should have included the quick ribbon functions i.e. paste values, remove filter, delete row/col etc. Also tapping alt then A then C will clear filters. Use this all the time even though I have the clear filter on the ribbon. Cheers.

[SavageGothamChess]

THANK YOU SO MUCH SIR. COULD YOU DO A VIDEO ON TOP POWERPOINT SHORTCUTS.

[paulvanobberghen]

About date and time : To enter both date AND time in 1 cell : CTRL + ; then SPACE then CTRL + SHIFT + ;

[dvdvno]

I have Excel 2007 and was wondering how to add 3 rows. So easy once you learn how it's done. Thanks.

[HandprintDreamApparel]

I have 2007 version some function example quick analysis function doesn't show could you please suggest how it's showing ? thanks in advance!

[jthomaskennedy]

How can I create table and design like in word

[sisurang]

So Nice.but #8 Zoom In/Out (Ctrl+Alt+ (- or+) does not work.Thanks

[masondoyle]

WHY DIDNT I KNOW ABOUT SEE FORMULA RESULTS????