Excellent! Many I know, but also many I have never come into contact with. Will definitely be using many of these in the future! Something I noticed with copy and paste as linked image is that it does not work with data formatted as a table, then it is not selectable. I got around it by choosing "Convert to range", copy and paste as linked image and then format the original data again as a table and the linked image then becomes a table too!
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! 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!
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.
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.
Excellent! Many I know, but also many I have never come into contact with. Will definitely be using many of these in the future!
Something I noticed with copy and paste as linked image is that it does not work with data formatted as a table, then it is not selectable.
I got around it by choosing "Convert to range", copy and paste as linked image and then format the original data again as a table and the linked image then becomes a table too!
Mind blowing. very well made. Thanks
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.
Superb tutorial, Sumit.
Thank you for sharing all these wonders.
Awesome video ❤, have put all of the tricks in one video! The trick to increment sheet nos was something new for me. Thanks Summit 🙏
Definitely a huge value addition to my knowledge of excel. Thank you.
Excellent! Thank you!
Superb man. God bless u 😊
Fabulous video- learned lots of copy and paste hacks I didn't know before. Thank you!
Glad you found it helpful 🙂
Thanks sumith
Very useful, thank you.
Thanks for this. It helps clarigy the different styles of C/P, Thanks for sharing!
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!
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.
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 :)
Great video. I learnt a couple of new tricks. Thanks appreciate your tips
Thanks for the video it was all very useful. Windows + V is a great shortcut that I didn't know existed, thanks
Very informative Video. Thank you Summit
Thanks for kind effort.
Thank you Sumit for informative video !!!
Very useful tricks. Thank you again for your genius work.
Great transfer of knowledge, specially copy as link, thank you
Amazing Tutorial
bhai....mere ko tou 1st trick he ni pata thi...hats offff...man..keep it up
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
Thank you Sumit , great tutorial
Awesome !!
Amazing tricks kudos to your efforts Sumit
Gracias Sumit. Fue muy útil: copiar los "Links" y "Clipboard
Thank you Nanba very useful
Bravo
Many of tricks I never seen before.
Keep it up
Thanks for the tutorial
Very useful,I learned lots from this video ❤️❤️❤️
Thanks Sumit, I didn't even know about ~90% of the functions.
Extremely useful
Thank you sir
Thank you. ❤
u are just wao.man................plz make more on dashboard...solving projects more and momre
Thanks wiggle is new for me
Thanks sir ❤
More useful content
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 😊
Dynamic picture pasting is new to me
I know very well
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.
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?
Please make more video on PQ and M code
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
Hello , how about the WPS office? Can teach me pls ?
😊😊😊
How can we copy data till the cell in column before the cureent column with keyboard
😢 sir please one vedio in topic workbook how to share in server ☹️
@trumpexcel nothing new😂
Excellent! Thank you!