Top 25 Excel Shortcut Tips and Tricks

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.

Support me with your Amazon purchases, click here: https://amzn.to/2Kxp533

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

Leave a Reply

Close Menu