Top 25 Excel Shortcut Tips and Tricks
Vložit
- čas přidán 24. 07. 2024
- 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: 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
#seletraining #excel #tipsandtricks - Věda a technologie
Never knew about quick analysis. This is super helpful! Thank you Sele :)
This is one of the best videos I've ever seen on CZcams. Thank you.
wow these shortcuts really saved me a bunch of time . thanks for this amazing tutorial sele
Excellent as always!
Excellent..!!
Fantastic and very helpful Thank you. More please.
Thanks Sele. These are very useful shortcuts.
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!!!
👍Was very very helpful
Great 👍
Omg thank you so much. I'm not so advanced in excel, but all those videos just give me life. Thank you!
I'm so glad!
Thanks and thanks 🙏 Super helpful God blessings
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
Excellent - there were at least 8 I never knew before!! Thank you!!
Excellent!
These shortcuts eliminate so many unnecessary procedures. Thank you for sharing.
Glad it was helpful!
@@SeleTrainingif you can recall, in which training session did you introduce hyperlinks in excel?
@@dexterbernard2701 I don't think I specifically listed hyperlinks in my excel videos. There may be a reference in my excel data from the web video: czcams.com/video/-CDu4zFShS0/video.html
@@SeleTraining That's it! I remember this presentation but i failed to like it. I perhaps saved it, but I wasn't sure. Thank you!
Brilliant...
Thanks!
thankyou sir
Insert or delete a row with Ctrl Shift +/- works with selection as well
Nice
Thanks
I have Excel 2007 and was wondering how to add 3 rows. So easy once you learn how it's done. Thanks.
Glad it was helpful!
THANK YOU SO MUCH SIR. COULD YOU DO A VIDEO ON TOP POWERPOINT SHORTCUTS.
Good suggestion. I'll look into that.
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.
Great suggestion!
About date and time : To enter both date AND time in 1 cell : CTRL + ; then SPACE then CTRL + SHIFT + ;
Good tip!
I have 2007 version some function example quick analysis function doesn't show could you please suggest how it's showing ? thanks in advance!
no it doesn't happen because there are a lot of different features in 2016 as compared to 2007
Several of these features were added after 2007. Most of my videos are focused on the latest Microsoft 365 version of Excel. With the subscription it stays current. By the way you can get a free copy of the online apps for Microsoft 365. Just go to office.com and signup with a Microsoft account.
Sir thanks for your kind reply!!!@@SeleTraining
How can I create table and design like in word
Since Excel is made up of cells already the table feature is just used to name a block of cells but you can still do the same designs to those cells.
So Nice.but #8 Zoom In/Out (Ctrl+Alt+ (- or+) does not work.Thanks
Are you using a Mac or on the online version. It may not work the same there.
@@SeleTraining i'm using Win10 with Office 2016🙏
WHY DIDNT I KNOW ABOUT SEE FORMULA RESULTS????
1. Paste Values (Right Click-V) -> You don't have to right-click. You just click and do CTRL+V.
Ctrl-V will paste a copy, including formulas. Right Click-V pastes values only.
@@SeleTraining thanks :)
It might be helpful to state that many of these keyboard shortcuts do not work on a Mac.
All of my videos are PC based but good tip.