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.
Share a personalized message with your friends.