When we are working with the data most of the time we may required to copy/move the data from one location (range) to another location. This tutorials will explains you Copying Moving and Pasting Data in Excel.
Moving a Range in Excel
We can Move the data from one range to another range by using either short cuts or in-built commands.
If you want to Move the data from one range another location:
If you want to Move the data from one range another location:
First we need to Select the existing Range => Cut it => Choose a New Range => Paste it
Select Range to Move:
Paste it: Press Ctrl+ V or right click and select Paste commands.
Output:
Copying a Range in Excel
We can Copy the data from one range to another range by using either short cuts or in-built commands.
If you want to Copy the data from one range another location:
If you want to Copy the data from one range another location:
First we need to Select the existing Range => Copy it => Choose a New Range => Paste it
Select Range to Copy:
Copy it: Press Ctrl+ C or right click and select Copy command.
Choose a New Loaction:
Paste it: Press Ctrl+ V or right click and select Paste commands.
Output:
0 comments :
Post a Comment