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!
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
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 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.
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?
@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.
@trumpexcel Excellent video. I checked on the copy-paste using " to copy without formatting. I found just the simple ' also works. (single quote instead of double quotes)
Thank you, Sumit, for this elaborate discussion on Copy + paste issues in excel.
Excellent! Thank you!
Superb tutorial, Sumit.
Thank you for sharing all these wonders.
Superb man. God bless u 😊
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 🙂
Definitely a huge value addition to my knowledge of excel. Thank you.
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!
Very useful! You learn something every day; or in this video, I learned about 23 things! Thank you :)
Thanks for this. It helps clarigy the different styles of C/P, Thanks for sharing!
Thanks for the video it was all very useful. Windows + V is a great shortcut that I didn't know existed, thanks
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
Thanks for kind effort.
Awesome video ❤, have put all of the tricks in one video! The trick to increment sheet nos was something new for me. Thanks Summit 🙏
Thank you Sumit for informative video !!!
Great video. I learnt a couple of new tricks. Thanks appreciate your tips
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 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
Thank you Sumit , great tutorial
Very useful, thank you.
Very useful tricks. Thank you again for your genius work.
Great transfer of knowledge, specially copy as link, thank you
Amazing tricks kudos to your efforts Sumit
Extremely useful
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.
Thanks sumith
Bravo
Many of tricks I never seen before.
Keep it up
Thanks for the tutorial
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.
Amazing Tutorial
Very useful,I learned lots from this video ❤️❤️❤️
Thank you. ❤
Thanks Sumit, I didn't even know about ~90% of the functions.
Awesome !!
u are just wao.man................plz make more on dashboard...solving projects more and momre
Thank you sir
Thank you Nanba very useful
Gracias Sumit. Fue muy útil: copiar los "Links" y "Clipboard
bhai....mere ko tou 1st trick he ni pata thi...hats offff...man..keep it up
Thanks sir ❤
Thanks wiggle is new for me
More useful content
HI sumit
Can u upload more video for power query in your playlist
Please make more video on PQ and M code
I know very well
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
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?
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 ?
@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.
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😂
@trumpexcel Excellent video. I checked on the copy-paste using " to copy without formatting. I found just the simple ' also works. (single quote instead of double quotes)
Excellent! Thank you!