Build Your Resume To Get Connected for Jobs and Internships - Resume Builder
Build Your Resume To Get Connected for Jobs and Internships - Resume Builder
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.
Using the Copy and Paste commands, copy cells in your worksheet.
Drag a sheet to move it.
The following are the two approaches for copying data into spreadsheet cells:-
Learn Making Professional-Quality Documents With MS Wor...
Enroll For Free
Impress Everyone With Fluent Communication Skills With...
Enroll For Free
Enhance your customer engagement skills with our Custom...
Enroll For Free
Improve Your Presentation and Team Management With Soft...
Enroll For Free
Become A Master In Sales With Career In Sales Taught In...
Enroll For Free
Have a friend to whom you would want to share this course?
