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:

First we need to Select the existing Range => Cut it => Choose a New Range => Paste it

Select Range to Move:

Cut it: Press Ctrl+ X or right click and select Cut command.

Choose a New Loaction:

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:

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:

Useful Shortcut Keys for Copying, Moving and Pasting the Data in Excel

The following short-cut keys will help you to easily copying the content in the Excel and Moving or pasting into a different locations in the workbook.

To do thsipress this key
Copy the selected cells: Instead of using Copy command in the right click properties menuCtrl+c
Cut the selected cells: Instead of using Cut command in the right click properties menuCtrl+x
Paste copied cells: Instead of using Paste commands in the right click properties menuCtrl+v
Paste Special Formats: Instead of using Paste commands in the right click properties menuAlt-E+S+T
Paste Special Formulas: Instead of using Paste commands in the right click properties menuAlt-E+S+F

Hey! Join Our Community

Get Quick Responses & Experts' Answers in Minutes!
Get Notified - When Answered Your Question!