How Copy, Move, Insert function is useful in MS Excel
Now suppose if we want to move, insert or copy any data in our Excel sheet, how we can do that we will see that now.
Suppose if you want to move any data from a particular place to another row or column, then in our usual way we will first copy that data and paste it where we want to, and then delete it from it's first place.
But in spite of doing all this we can use a short way to move any of our desirable data, for set we will for select which data we want to move and then more about mouse pointer to any corner of the selected area, and we can see that our pointer will change into a four way arrow like icon, which indicates that these data can now to move to other place.
Now if we want to exactly copy any data and paste that data at other place but also keep it at its initial place, then we can proceed with the same method which we applied above but just by pressing 'Ctrl' key.
By selecting our data and dragging it with right click pressed, we can also copy, or move that data.
If we want to move any data from a created table to upper or lower row and replace it with selected data, than we will apply sane method of dragging it but by pressing 'Shift' key along with it.
Have a friend to whom you would want to share this course?