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


Related pages


how to change the width of a cell in excelvba do until loophow to create a 3d pie chart in excelstring array vbacombobox propertiesmsg box vbacode for comboboxremove hyperlinks in excel 2007how to add developer tab in excel 2010excel listboxidentify duplicate rows in excelmsgbox optionscountif functions in excelhow to insert blank lines in exceldeleting a pivot tablefind duplicates in excelllearning excel for beginnersvba syntax guidecontinue vbaadd chart title excelvba rowcountinserting in excelvba access tutorialswot analysis excelaccess vba open excel fileexcel macro to hide columnsvba activecellproject timeline template excelexcel vba inputboxdelete row excel shortcutremove workbook protectionselect sheet excel vbapm templates for excelunmerge cells in excel 2010how to use hyperlink in excel 2007iserror formulahow do i unhide rows in excelexcel macro create folderexcel find last cellmultiple project tracking template excelhighlight duplicates in excel 2003how to dedup in excelaccess vba close tableprotect worksheet excel 2007excel range vb netexcel macros tutorialsunprotected excelexcel mergecellsexcel task trackersample vb programs for beginnersvba convert to integerrun a query in excelexcel hide cellmicrosoft estimate templatemultiple ifs in excelvba worksheet deleteexcel formula vlookup exampleconditional statements excelsort macro excelshort cut keys for excelexcel vba show progress bartesting plan template excelexcel if cell contains textvba iserrorvba for excel 2007simple gantt chart template excelinterview questions on sas macrosvb6 open text fileinsert comment excel shortcutdynamic pivot table in sql server 2008excel vba range addressmicrosoft excel vlookup examplesheaders in excelmacro function in excelaccess vba close reportexcel macro selectionexcel vba command buttonaccess vba recordset