Copying Moving and Pasting Data in Excel

Home/Excel/Copying Moving and Pasting Data in Excel

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.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


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 thsi press this key
Copy the selected cells: Instead of using Copy command in the right click properties menu Ctrl+c
Cut the selected cells: Instead of using Cut command in the right click properties menu Ctrl+x
Paste copied cells: Instead of using Paste commands in the right click properties menu Ctrl+v
Paste Special Formats: Instead of using Paste commands in the right click properties menu Alt-E+S+T
Paste Special Formulas: Instead of using Paste commands in the right click properties menu Alt-E+S+F
LIMITED TIME OFFER
By |May 21st, 2013|Excel|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment