25 AWESOME Excel Keyboard Shortcuts (You Should Know)!

  Рет қаралды 147,153

TrumpExcel

TrumpExcel

Күн бұрын

Пікірлер: 99
@trumpexcel
@trumpexcel 4 жыл бұрын
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what topics you want me to cover in future videos.
@nasma.e7440
@nasma.e7440 Жыл бұрын
12:22 Cool trick 👍👍👍
@jadhavnamdev1
@jadhavnamdev1 4 жыл бұрын
I always wonder how do speak this well without any gaps and errors. And your excel videos are unique on KZbin. I have improved a lot, thank you sir.
@user-wt8pg4iy4d
@user-wt8pg4iy4d 3 жыл бұрын
Thank you! I finally find an excel tutorial Channel that I am excited to come and learn new things from. Very well explained and informative. I really enjoy the presentation 😊
@keithau8159
@keithau8159 4 жыл бұрын
Yes,genius,genius and genius at all@@@@@
@RollinShultz
@RollinShultz 3 жыл бұрын
Good video. I am a keyboard heavy user and I remember way back when I started using excel searching for the less obvious shortcuts like ctrl + page up/down for changing sheets, as I knew there must be a keyboard shortcut for it. Although I knew most of the ones here already, there were a couple new ones for me. I found the presentation very clear and concise. I would add that the shortcut ctrl + tab works in all MS Office programs to switch between instances. For example : if you are in Word and use it you switch to the next open word document.
@munishmittal9634
@munishmittal9634 3 жыл бұрын
Excellent
@wayneedmondson1065
@wayneedmondson1065 3 жыл бұрын
Hi Sumit. Thanks for sharing this great list of tips and shortcuts. Thumbs up!!
@akanshagarg1707
@akanshagarg1707 4 жыл бұрын
Really this video has proved to be very useful with completely apt content and excellent presentation Thankyou
@StretchFletcher
@StretchFletcher 5 жыл бұрын
Awesome Sumit. You are a gem. Thanks.
@trumpexcel
@trumpexcel 5 жыл бұрын
Thanks for commenting Stretch.. Glad you found it useful!
@devendrabain7748
@devendrabain7748 5 жыл бұрын
Very useful video. I believe these shortcuts will tremendously save my time.
@yyz7436
@yyz7436 4 жыл бұрын
Thumbs up given saved and subscribed as well . Thank you excellent lessons 🇨🇦
@mohamedhussein4065
@mohamedhussein4065 4 жыл бұрын
Awesome!, its very very very useful hints and thanks a lot for the good brief informative presentation.
@sujeettimex
@sujeettimex 2 жыл бұрын
Very Useful for me...! Thanks.
@venukrishna8453
@venukrishna8453 2 жыл бұрын
Ultimate video.. Thank you so much
@JohnFranciskanjirathingal
@JohnFranciskanjirathingal 4 жыл бұрын
Easy explanation and wonderful sound
@vishalsheth506
@vishalsheth506 4 жыл бұрын
Nice short-cuts ....Few of them are new for me..Thanks...
@sagarpullam4967
@sagarpullam4967 3 жыл бұрын
Who ever is watching these videos want to learn shortcut for excel keyboard shortcuts.. here is the simple trick.. open excel and press Alt key it will highlight the shortkey with underline for each option.. for example F for "File"..likewise remaining.. check it..
@trumpexcel
@trumpexcel 3 жыл бұрын
Great tip Sagar. Most of the shortcuts can be learned with this technique
@nagaraju2544
@nagaraju2544 3 жыл бұрын
Thank you. These are very useful tips in day to day work activities in a job
@dlsgl407
@dlsgl407 3 жыл бұрын
Thank you - so many tips I'm going to use tomorrow!
@karthikvisvennbala7776
@karthikvisvennbala7776 3 жыл бұрын
Brother, you are excellent.
@kirandeepchoudhry9232
@kirandeepchoudhry9232 5 жыл бұрын
Awesome Puneet specially moving row with shift key
@TVSCDN
@TVSCDN 3 жыл бұрын
Thanks❤🌹🙏
@shahabuddinshareefsyed9053
@shahabuddinshareefsyed9053 3 жыл бұрын
Most excellent video I have came across related to Excel tips
@ashishgosai11
@ashishgosai11 4 жыл бұрын
Thanks it's too much useful
@VikasSingh-em3ol
@VikasSingh-em3ol 5 жыл бұрын
Nice and very helpful video for excel learner.
@denkydoo6456
@denkydoo6456 5 жыл бұрын
Thanks for this.👍👍👍
@anitamalhiot3204
@anitamalhiot3204 3 жыл бұрын
Liked & subscribed - I learned a lot - thank you!!!
@jilaygandhi2996
@jilaygandhi2996 4 жыл бұрын
Really useful in day to day life Thank you
@Chenna_Reddy11
@Chenna_Reddy11 2 жыл бұрын
Thank you so much worthful videos
@DineshPal-nw1ss
@DineshPal-nw1ss 2 жыл бұрын
very nice and use ful
@mathewsebastin177
@mathewsebastin177 3 жыл бұрын
unbelievable formula ,.. thank q sir,..
@dayakarreddy143
@dayakarreddy143 3 жыл бұрын
Really very nice Video, saving lot of time with his tips. Thank you so much 👍🙏
@meetkcs
@meetkcs 4 жыл бұрын
Ctrl + Awesome Super collection and the way u r demonstration is excellent sir
@meetkcs
@meetkcs 4 жыл бұрын
Doubt: Is there any shortcut key combination to: Drag formula to entire column... Ex: if we write formula in cell A1, normmaly we drag to below all cells.... So any shortcut key combination for such...??
@anjalirathore9031
@anjalirathore9031 4 жыл бұрын
Amazing superb👌
@maheshvenkatesan617
@maheshvenkatesan617 5 жыл бұрын
Superb.... Kudos...
@heshamfouad8886
@heshamfouad8886 5 жыл бұрын
Thanks Summit, you really helped me countless times in excel I just suggest you also make a note about the Quick Access toolbar, for the shortcuts that are not easy as an example I currently have Paste As Value in ALT + 1 & Format Painter in Alt + 4 and so on Again thanks for the video
@trumpexcel
@trumpexcel 5 жыл бұрын
Thanks for commenting Hesham.. And a great suggestion. Definitely something I should consider for another video.
@rabdu2002
@rabdu2002 4 жыл бұрын
Dear Hesham, How you past as a value by using ALT+1 as well as format painter in ALT+4 please clarify
@trumpexcel
@trumpexcel 4 жыл бұрын
When you add icons to QAT, you can access these using the ALT key. Press the ALT key and you will see number appear in the QAT. That becomes their keyboard shortcut
@master_jk6509
@master_jk6509 3 жыл бұрын
Thanks a lot. your video is most useful
@jayaprakashnkl
@jayaprakashnkl 4 жыл бұрын
REALLY GOOD AND VERY USEFUL. THANKS
@AmitKumar-gy9np
@AmitKumar-gy9np 3 жыл бұрын
Good job brother
@khalidmohamed2569
@khalidmohamed2569 4 жыл бұрын
I LOVE YOUR VIDEOS DUE TO THAT I SUBSCRIBED TO YOUR CHANNEL
@erpdept4519
@erpdept4519 3 жыл бұрын
Superb!!
@rayeesahmadbhat2723
@rayeesahmadbhat2723 3 жыл бұрын
Perfect speaking ....💖
@kadirjattani6491
@kadirjattani6491 4 жыл бұрын
All perfectly working thanks summit
@heliosfoods2864
@heliosfoods2864 2 жыл бұрын
Great video out there
@tajumir48
@tajumir48 Жыл бұрын
Best one ever❤❤
@JumpRopeVeteran
@JumpRopeVeteran 4 жыл бұрын
Thank you man. This is great.
@vikas2377
@vikas2377 3 жыл бұрын
Fantastic!!
@triptypes
@triptypes 3 жыл бұрын
very good!!
@Nimmavmurthy
@Nimmavmurthy 5 жыл бұрын
Thank you so much bro I thought some shortcuts in this video...
@huzaifamukhtar6919
@huzaifamukhtar6919 2 жыл бұрын
Kamaal Excel Teacher
@briandennehy6380
@briandennehy6380 5 жыл бұрын
Awesome. It would be next level if you could make your own keyboard shortcuts.
@trumpexcel
@trumpexcel 5 жыл бұрын
Glad you found it useful... Excel allows creating your own shortcuts using VBA. So you can have a VBA macro that will run with a keyboard shortcut
@cishqichannel3539
@cishqichannel3539 4 жыл бұрын
Good lesson
@madelynemily8195
@madelynemily8195 4 жыл бұрын
good informations
@madelynemily8195
@madelynemily8195 4 жыл бұрын
Love you
@ramuthadaka
@ramuthadaka 2 жыл бұрын
Can you please explain paste special works in when applied filter
@nasimhasan2351
@nasimhasan2351 4 жыл бұрын
Perfect! Thanks
@prakashsathyapriya
@prakashsathyapriya 4 жыл бұрын
Lot of thanks for this video. It's an eye opener. I have a doubt and hope you would clarify. I have a numerical dataset with decimals. Unfortunately in one cell i have two dots, so the values are not counted. How to find out these errors.
@brijeshshah574
@brijeshshah574 3 жыл бұрын
At 4:36 To select the whole data you have to select Ctrl + Shift + *. (PS: Cursor must in anywhere in the data set)
@richardnaylor910
@richardnaylor910 2 жыл бұрын
Good video
@sunpasirithxssunpasiri4759
@sunpasirithxssunpasiri4759 3 жыл бұрын
Very useful please, I have questions: 1)If i wanna remove the row as filter, and no need the otherline as not fillers removed out, what sholu i do pls? 2) How to do zoom in-out, druing present pls?
@rushikeshkadam8350
@rushikeshkadam8350 3 жыл бұрын
This is Great..!!
@simuislam5752
@simuislam5752 2 жыл бұрын
Good ❤
@swapna_learner
@swapna_learner 2 жыл бұрын
Thank you for the shortcuts video. Just one observation, below generally work on US or UK keyboard. Change of keyboard settings might not work and one has to depend on mouse
@mohamedadjal8502
@mohamedadjal8502 3 жыл бұрын
Hi, Professor, you have provide in a lot of effort for these videos, thank you, I have a question if we have for example in cell "a1" the number 10.00 m, how to have this number with the same format in cell "b1 "using the text function or some other function, thank you very much.😃👍
@sirjay3300
@sirjay3300 3 жыл бұрын
Hello Sir Summit Bansal.. i am really fun of your youtube channel esp. the excel video tutorials for with you I was able to create some excel formatting or can i called it excel program that realy makes my job and even my colleagues to save most of our time in doing such, like tallying of data. Before it would take almost a day to do it but because of what ive learned it would only take a single copy and paste then boom. With this, i would like to ask for your help. Will there be a chance in the excel where if you copy a data in merged cells it could be pasted in a single unmerged cell? Thank you so much Sir!! God bless you😍😍😍
@manaragforms
@manaragforms 4 жыл бұрын
thank you so much, If I want to get average of formatted cells it gives error what can i do ?
@surajbhangupta9099
@surajbhangupta9099 4 жыл бұрын
Thanks sir
@maheshsanghani6380
@maheshsanghani6380 3 жыл бұрын
do you agree , if all short cuts are tabulaed in excel , it will help all a lot .
@sakawathossainshohag111
@sakawathossainshohag111 4 жыл бұрын
What is the shortcut to hidden row and column bhaia?
@Jegan_Kanthasamy
@Jegan_Kanthasamy 5 жыл бұрын
Instead of using Alt E S for paste special we can use Alt Ctrl V to open the paste special dialogue box.
@trumpexcel
@trumpexcel 5 жыл бұрын
Both of these shortcuts would work. I used to use Control Shift V earlier, but I Find ALT E S easier to use
@Vincent-cg9qr
@Vincent-cg9qr 4 жыл бұрын
Thank you, Alt E S does not work in French Excel ! I need this shortcut sooooo often !!
@joelsimbran1694
@joelsimbran1694 4 жыл бұрын
hi.. how to use format painter in different rows at one go? is there a shortcut? thanks in advance!
@thenegizone221
@thenegizone221 5 жыл бұрын
Hi summit this video is so useful. Could you help me how can i do right click on sheets without using mouse in excel workbook. And when rows are blank in excel data then ctrl+shift+L is helpful for using filter in whole data or not.
@trumpexcel
@trumpexcel 5 жыл бұрын
For right-click without mouse, there is a key in the keyboard, just right to the Control Key. If you don't have that, try Shift + F10. And for filter, if you want to apply it to the entire data set (that may have blank rows), first select the entire data set and then apply the Filters.
@sumitjaiswal4391
@sumitjaiswal4391 3 жыл бұрын
Kuch naya keyboard shortcuts batayein sir
@triptypes
@triptypes 3 жыл бұрын
Additional I can say Ctrl+Alt+V "Paste Special" Shortcut
@Gohan_dk
@Gohan_dk 3 жыл бұрын
Absolutely correct which I daily use ...
@hhamilton6391
@hhamilton6391 4 жыл бұрын
my version of excel looks nothing like yours. mine is 2016 what version are you using?
@hareesh2357
@hareesh2357 3 жыл бұрын
👌🏻👌🏻👌🏻
@VikasSingh-em3ol
@VikasSingh-em3ol 5 жыл бұрын
I am a student of BA and want to work in Excel. Is there any future job in Excel? Please sir guide me and give me suggestion. How to improve your skill in Excel to advanced level?
@sathyanarayana147
@sathyanarayana147 5 жыл бұрын
how to copy the data from bottom cell to upper cell
@trumpexcel
@trumpexcel 5 жыл бұрын
I don't know of any shortcut for this. May be use the longer route of copying, going to the upper cell and then pasting.
@rajendramehra4651
@rajendramehra4651 4 жыл бұрын
@ mai 1k company mai working hyun mere under mai 72 empoly hai,and we 2015 se kaam kar rahe hai ,mere pass unka pura sale data hai 5 saal kaa with empoly id to mujhe unko ye data each candidate ko dena hai har 5 din ke baad jaise hi unka data khatam ho jata hai fir jab mai unko data send karu to mujhe kaise pata chalega ki maine unko kaha tak data aur jab tak kaa data diya hai... please shoot video on this and please please please revert sir..
@mbahkopi
@mbahkopi 2 жыл бұрын
Not work on mac version. Im
@swamivivekanandgovtmodelsc6780
@swamivivekanandgovtmodelsc6780 5 жыл бұрын
CTRL+E NOT WORK IN MY EXCEL
@trumpexcel
@trumpexcel 5 жыл бұрын
Flash fill is only available in Excel 2013 and later versions. Any chance you're using Excel 2010 or prior versions?
@rapsayush3990
@rapsayush3990 4 жыл бұрын
Hindi m video bnao..
7 Clever Excel Custom Formatting Tricks (Advanced)
19:14
TrumpExcel
Рет қаралды 233 М.
10 Super Neat Ways to Clean Data in Excel
18:47
TrumpExcel
Рет қаралды 1,9 МЛН
Леон киллер и Оля Полякова 😹
00:42
Канал Смеха
Рет қаралды 4,7 МЛН
Правильный подход к детям
00:18
Beatrise
Рет қаралды 11 МЛН
Try this prank with your friends 😂 @karina-kola
00:18
Andrey Grechka
Рет қаралды 9 МЛН
10 Amazing (Less Known) Excel Tricks You Should Know
17:34
TrumpExcel
Рет қаралды 579 М.
Most Useful Excel Keyboard Shortcuts
9:22
Technology for Teachers and Students
Рет қаралды 1,7 МЛН
🤯 23 HIDDEN Excel Tricks You (Probably) Don't Know
37:04
TrumpExcel
Рет қаралды 12 М.
How to Move Data Automatically Between Excel Files
11:37
Kenji Explains
Рет қаралды 253 М.
19 Advanced Excel Shortcuts You Might Not Know
10:38
Excel Campus - Jon
Рет қаралды 311 М.
12 Excel Copy Paste Hacks - I Bet You Don't Know All!
33:57
TrumpExcel
Рет қаралды 13 М.
Excel Shortcuts You SHOULD Know!
8:48
Leila Gharani
Рет қаралды 2,1 МЛН
8 Awesome Find and Replace Tricks in Excel (Advanced)
17:43
TrumpExcel
Рет қаралды 11 М.
Леон киллер и Оля Полякова 😹
00:42
Канал Смеха
Рет қаралды 4,7 МЛН