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.
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 😊
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..
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...??
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
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.
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?
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
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😍😍😍
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.😃👍
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.
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?
@ 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 TH-cam.
I have improved a lot, thank you sir.
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 😊
Yes,genius,genius and genius at all@@@@@
Hi Sumit. Thanks for sharing this great list of tips and shortcuts. Thumbs up!!
12:22 Cool trick 👍👍👍
Excellent
Very useful video.
I believe these shortcuts will tremendously save my time.
Really this video has proved to be very useful with completely apt content and excellent presentation
Thankyou
Thumbs up given saved and subscribed as well . Thank you excellent lessons
🇨🇦
Awesome!, its very very very useful hints and thanks a lot for the good brief informative presentation.
Nice short-cuts ....Few of them are new for me..Thanks...
Thank you - so many tips I'm going to use tomorrow!
Very Useful for me...! Thanks.
Awesome Sumit. You are a gem. Thanks.
Thanks for commenting Stretch.. Glad you found it useful!
Ultimate video.. Thank you so much
Thank you. These are very useful tips in day to day work activities in a job
Most excellent video I have came across related to Excel tips
Easy explanation and wonderful sound
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
unbelievable formula ,.. thank q sir,..
Really very nice Video, saving lot of time with his tips. Thank you so much 👍🙏
Nice and very helpful video for excel learner.
Brother, you are excellent.
Thank you so much worthful videos
Liked & subscribed - I learned a lot - thank you!!!
Really useful in day to day life
Thank you
Thanks it's too much useful
Awesome Puneet specially moving row with shift key
Thanks for this.👍👍👍
REALLY GOOD AND VERY USEFUL. THANKS
Thanks a lot. your video is most useful
very nice and use ful
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...??
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
Superb.... Kudos...
All perfectly working thanks summit
Thank you man. This is great.
Superb!!
Fantastic!!
Amazing superb👌
Best one ever❤❤
Thank you so much bro I thought some shortcuts in this video...
Thanks❤🌹🙏
I LOVE YOUR VIDEOS DUE TO THAT I SUBSCRIBED TO YOUR CHANNEL
Great video out there
Kamaal Excel Teacher
very good!!
good informations
Love you
Perfect speaking ....💖
Good job brother
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.
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?
Perfect! Thanks
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
This is Great..!!
Good lesson
Can you please explain paste special works in when applied filter
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
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😍😍😍
Thanks sir
Good video
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.😃👍
thank you so much, If I want to get average of formatted cells it gives error what can i do ?
Good ❤
do you agree , if all short cuts are tabulaed in excel , it will help all a lot .
Kuch naya keyboard shortcuts batayein sir
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.
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 ...
my version of excel looks nothing like yours. mine is 2016 what version are you using?
hi.. how to use format painter in different rows at one go? is there a shortcut? thanks in advance!
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?
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 !!
What is the shortcut to hidden row and column bhaia?
👌🏻👌🏻👌🏻
@ 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..
Not work on mac version. Im
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..