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


filter in excel vbaexcel formulas average ifexcel activex controlsproject calendar template excelvba selection.deleteexcel greater than formulaproject checklist template excelhow to exclude duplicates in excelsum if formula in excelexcel vba programming for beginnershow to adjust row height in excelranking chart excelcountifs excel formulaworksheet unprotectwrite sql query in excelloops vbachar function excelsqlfunctionsdelete cells in excelhow to analyse trends in exceleffort estimation template for software developmentexcel tables tutorialexcel shortcut deleteexample excel macrocan you unprotect an excel spreadsheetexcel vlookup case sensitiveworksheetfunction vbadaily standup meeting templateodbc vbawhat is the default row height in excellinking excel cellsexcel remove duplicates from 2 columnscopy and paste cells in excelmacro security in excel 2007ms vba tutorialdelete excel rowsvb6 directory existsexcel vba for each cell in columnvba adodb.commandvba excel cells.findexcel 2013 column widthvba display message boxiserror with vlookuphow to increase column width in excelexcel for beginnersexcel workbook vs worksheetactivate macros excelvba offset functionexcel isrefexcel project plan timeline templateexamples of sumifvba internetexplorer.applicationif cell is not blank excelnull value vbaexcel formula find duplicatesdashboard widgets for exceltransfer spreadsheet vbasort vbaloops in vba excelvba clearcontentshow to build a pivot table in excel 2007vba excel hyperlinkexcel macro vbafind duplicates in excel listtest automation interview questions and answerschart wizard in excel 2007excel vb tutorialfso vbaunlock a password protected excel filevba for access tutorialhow to sort numbers in excel in ascending orderopen dialog box vbacolumn index number excelhow to enable macros in excel 2013vlookup ms excelappend excelvba populate combobox