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


excel advanced filter tutorialembedded pie chartinsert checkbox excelhow to write a excel macroexcel spreadsheet templates for project managementexcel chart title formulaspss video tutorials for beginnersadd developer tab to the ribbon in wordhow do i unhide a column in excelsum if functionvba combobox examplevba excel sumifhow to create sql query in excelvba read cellclear cell contents vbahow to create a combobox in excelautofit columns excelgetusername vbaexcel pivot table example dataexcel vba status bar progresstotal no of rows and columns in excellookup in excelhow to append in excelinterview questions on c programming with answers pdffor each in excel vbadynamic dashboard template in excelnested if statements in excelvba excel code listworksheetfunction.vlookup vbavba odbc connectionautosave excel 2010how to delete selected rows in excelhow to create pivot table in excel 2003color in excel formuladelete rows in excel using vbalookup functions excelvba scripting filesystemobjectexcel gotoexample of sumif in excel3d bubble chart excel 2010input in vbaautofilter in vbascheduling template for exceloutlook attachment vbawriting vba functionsexcel merge cells formulavba run sql queryduplicate rows in excelexamples of vlookupunprotectpaste special multiplyexcel vba workbook saveasvba pivot table source dataexcel tutorial pivot tablesconcatenation in vbafix vbaschedule template for excelwhat is concatenate excelexcel vba save workbookexcel worksheet copyexcel delete rowsremove empty rows from excelexcel find duplicate recordsprotect excel formulasexcel macro open excel filevb code for excelvba save as csvvb6 write to text filehow to change row height in excelopen protected excel workbook without passwordhow to unhide the rows in excelhow to make a drop down list in excel 2007vb script message boxexamples for vlookup in excel