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.
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..
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.
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 😊
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
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
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...??
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.
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
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?
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.😃👍
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😍😍😍
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?
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.
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.
@ 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..
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.
I always wonder how do speak this well without any gaps and errors.
And your excel videos are unique on UA-cam.
I have improved a lot, thank you sir.
Yes,genius,genius and genius at all@@@@@
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..
Great tip Sagar. Most of the shortcuts can be learned with this technique
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.
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 😊
Kamaal Excel Teacher
12:22 Cool trick 👍👍👍
Ultimate video.. Thank you so much
Excellent
Really this video has proved to be very useful with completely apt content and excellent presentation
Thankyou
Very useful video.
I believe these shortcuts will tremendously save my time.
Thank you so much worthful videos
Hi Sumit. Thanks for sharing this great list of tips and shortcuts. Thumbs up!!
very nice and use ful
Thumbs up given saved and subscribed as well . Thank you excellent lessons
🇨🇦
Thank you. These are very useful tips in day to day work activities in a job
Thanks a lot. your video is most useful
Nice short-cuts ....Few of them are new for me..Thanks...
Awesome Sumit. You are a gem. Thanks.
Thanks for commenting Stretch.. Glad you found it useful!
Very Useful for me...! Thanks.
Easy explanation and wonderful sound
Thank you - so many tips I'm going to use tomorrow!
Superb!!
Brother, you are excellent.
Awesome!, its very very very useful hints and thanks a lot for the good brief informative presentation.
Awesome Puneet specially moving row with shift key
Most excellent video I have came across related to Excel tips
Good job brother
unbelievable formula ,.. thank q sir,..
Nice and very helpful video for excel learner.
Thanks it's too much useful
Best one ever❤❤
Really useful in day to day life
Thank you
Great video out there
Thanks❤🌹🙏
Really very nice Video, saving lot of time with his tips. Thank you so much 👍🙏
very good!!
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
Thanks for commenting Hesham.. And a great suggestion. Definitely something I should consider for another video.
Dear Hesham, How you past as a value by using ALT+1 as well as format painter in ALT+4 please clarify
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
Thanks for this.👍👍👍
Amazing superb👌
Perfect speaking ....💖
All perfectly working thanks summit
Liked & subscribed - I learned a lot - thank you!!!
Ctrl + Awesome
Super collection and the way u r demonstration is excellent sir
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...??
REALLY GOOD AND VERY USEFUL. THANKS
Thank you so much bro I thought some shortcuts in this video...
Fantastic!!
Superb.... Kudos...
I LOVE YOUR VIDEOS DUE TO THAT I SUBSCRIBED TO YOUR CHANNEL
Awesome. It would be next level if you could make your own keyboard shortcuts.
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
Thank you man. This is great.
Good lesson
Good video
This is Great..!!
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.
do you agree , if all short cuts are tabulaed in excel , it will help all a lot .
Perfect! Thanks
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
Can you please explain paste special works in when applied filter
good informations
Love you
Good ❤
At 4:36 To select the whole data you have to select Ctrl + Shift + *.
(PS: Cursor must in anywhere in the data set)
Additional I can say Ctrl+Alt+V "Paste Special" Shortcut
Absolutely correct which I daily use ...
Kuch naya keyboard shortcuts batayein sir
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?
Thanks sir
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.😃👍
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😍😍😍
Instead of using Alt E S for paste special we can use Alt Ctrl V to open the paste special dialogue box.
Both of these shortcuts would work. I used to use Control Shift V earlier, but I Find ALT E S easier to use
Thank you, Alt E S does not work in French Excel ! I need this shortcut sooooo often !!
thank you so much, If I want to get average of formatted cells it gives error what can i do ?
my version of excel looks nothing like yours. mine is 2016 what version are you using?
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?
hi.. how to use format painter in different rows at one go? is there a shortcut? thanks in advance!
What is the shortcut to hidden row and column bhaia?
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.
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.
👌🏻👌🏻👌🏻
Not work on mac version. Im
@ 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..
how to copy the data from bottom cell to upper cell
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.
CTRL+E NOT WORK IN MY EXCEL
Flash fill is only available in Excel 2013 and later versions. Any chance you're using Excel 2010 or prior versions?
Hindi m video bnao..