Thank you Sumit for your so handy tutorial. And I wanna add some tricks maybe they will be so useful for your lecture: 1- If we do double clicks CRTL+C when we are working in excel workbook, it will open clipboard and we can use this copied values or functions whenever we want to use. Also, you can find this property if you open clipboard pane and select property section which is located at the left bottom side of the pane. 2- If you want to copy unhidden rows or columns, select the whole range and copy and then click ALT+SHFT+; then you'll find that just visible cells will be copied and you can paste them whichever you want places.
Thank you Sumit. I am already using Alt+Ctrl+V and all the options with special paste options. However, I have learnt paste from Clipboard, Paste using enter, Alt+E+S for special paste dialogue box. Thanks again.
Thank you Sumit! Paste Operations is new to me, so too Paste as Linked Picture the 'Camera Tool'. The latter seems like magic and can be so useful!! Your video also helped me understand the structure and power of the Clipboard. Copying Charts with Formats was new to me too!
Very Nice Video made by you Sir, Really cleared most of the doubts and would also help to get faster in excel. You teach very nicely keeping all options open for user help them . Thank you very much
@trumpexcel, Kindly make a video on how to unify and clean a range of inconsistent Date formats of both UK and American format, where the Day and month of each cells differs. Thank you so the tutorials you put out also.
In my routine I make copy whole workbook means including all worksheets inside without formula. I first make a copy of whole workbook with new name then individually all worksheets, I select all data and special paste as value at same cells. Is there any shortcut to make whole workbook copy without formula?
Thank you, Sumit, for this elaborate discussion on Copy + paste issues in excel.
Thank you Sumit for your so handy tutorial. And I wanna add some tricks maybe they will be so useful for your lecture:
1- If we do double clicks CRTL+C when we are working in excel workbook, it will open clipboard and we can use this copied values or functions whenever we want to use. Also, you can find this property if you open clipboard pane and select property section which is located at the left bottom side of the pane.
2- If you want to copy unhidden rows or columns, select the whole range and copy and then click ALT+SHFT+; then you'll find that just visible cells will be copied and you can paste them whichever you want places.
Thank you Sumit. I am already using Alt+Ctrl+V and all the options with special paste options. However, I have learnt paste from Clipboard, Paste using enter, Alt+E+S for special paste dialogue box. Thanks again.
Thank you Sumit! Paste Operations is new to me, so too Paste as Linked Picture the 'Camera Tool'. The latter seems like magic and can be so useful!!
Your video also helped me understand the structure and power of the Clipboard.
Copying Charts with Formats was new to me too!
Superb tutorial, Sumit.
Thank you for sharing all these wonders.
Very Nice Video made by you Sir, Really cleared most of the doubts and would also help to get faster in excel. You teach very nicely keeping all options open for user help them . Thank you very much
Very useful! You learn something every day; or in this video, I learned about 23 things! Thank you :)
Definitely a huge value addition to my knowledge of excel. Thank you.
Excellent! Thank you!
Very useful, thank you.
Thanks for the video it was all very useful. Windows + V is a great shortcut that I didn't know existed, thanks
Mind blowing. very well made. Thanks
Fabulous video- learned lots of copy and paste hacks I didn't know before. Thank you!
Glad you found it helpful 🙂
Very informative Video. Thank you Summit
Control Shift V I have started using after watching your earlier vedios. Thank you so much
I also use it all the time now. Very handy and works in most applications
Thanks Sumit, I didn't even know about ~90% of the functions.
Awesome video ❤, have put all of the tricks in one video! The trick to increment sheet nos was something new for me. Thanks Summit 🙏
Thanks for the tutorial
Very useful,I learned lots from this video ❤️❤️❤️
Amazing tricks kudos to your efforts Sumit
Thanks for this. It helps clarigy the different styles of C/P, Thanks for sharing!
Gracias Sumit. Fue muy útil: copiar los "Links" y "Clipboard
u are just wao.man................plz make more on dashboard...solving projects more and momre
Amazing Tutorial
Thanks for kind effort.
Superb man. God bless u 😊
Thank you Nanba very useful
Great video. I learnt a couple of new tricks. Thanks appreciate your tips
bhai....mere ko tou 1st trick he ni pata thi...hats offff...man..keep it up
Great transfer of knowledge, specially copy as link, thank you
Thank you Sumit for informative video !!!
Thank you Sumit , great tutorial
Very useful tricks. Thank you again for your genius work.
Bravo
Many of tricks I never seen before.
Keep it up
Awesome !!
Dynamic picture pasting is new to me
Extremely useful
Thanks wiggle is new for me
Please make more video on PQ and M code
HI sumit
Can u upload more video for power query in your playlist
@trumpexcel, Kindly make a video on how to unify and clean a range of inconsistent Date formats of both UK and American format, where the Day and month of each cells differs.
Thank you so the tutorials you put out also.
Thank you. ❤
I know very well
Can you tell how to add space in between first and last name where both of them are written together in a cell? WITHOUT THE USE OF VBA
In my routine I make copy whole workbook means including all worksheets inside without formula.
I first make a copy of whole workbook with new name then individually all worksheets, I select all data and special paste as value at same cells.
Is there any shortcut to make whole workbook copy without formula?
How can we copy data till the cell in column before the cureent column with keyboard
Hello , how about the WPS office? Can teach me pls ?
Thanks sir ❤
I don't know if you realize how important and valuable you are here in the U.S at Amazon!
I am happy and grateful to know my work is helpful. Thank you so much for the kind words 😊
😊😊😊
😢 sir please one vedio in topic workbook how to share in server ☹️
@trumpexcel nothing new😂
Excellent! Thank you!