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


clustered cylinder chart excelbasic excel commandshow to sort from highest to lowest in excelhow to use hyperlink function in excelcoding macros in excelcool macrosexcel formulas for data analysisdaily scrum meeting templatehide rows in excel 2010writing vbavba excel switchvba worksheet functionvba excel connection stringexcel offset columnhow to insert a hyperlink in excelconsolidate excel sheets into oneoption button excelactivesheet listobjectshow to unhide worksheets in excelexcel hyperlink functiontrim function in accesshow to copy cells in excel to another sheetvba manualhighlight duplicates in excel 2007vba variant typeinstr vba excelusing macros excelhow to delete an excel sheetactive x checkvba variable scopeexcel formula to check for duplicateswhat is countif in excelms excel countif functionvlookup multiple conditionsexcel vba outlookexcel formula to check for duplicatesvb script interview questions and answers for freshersexcel macro paste valuessimple excel macro examplevba screen updateprint command in vbaoutlook developer tabado connectionstringaccess vba run macroformula concatenate excelexcel project planner templatehow to put countif formula in excelcells.find excel vbahow to do an hlookupvba to unprotect sheet with passwordrefresh pivot table in vbaworkbook saveasgenpact interview questions for freshersremoving duplicates from excelvlookup excel function examplesvbs output to filems excel templates for project managementwrite a function in vbaexcel countif examplesexamples of if statements in excelhow to put title on excel graphdifferent types of languages in sqlexcel duplicate celllearn vlookup in excel 2013offset vba excelexcel vba select rangecountifs formula in excelcombobox.items.addexcel 2010 powerpivot tutorialexcel vba not equalvloopup exampleexcel 2010 macros not workingif statements vbaexcel vba code examples